d. Describe the IBM DataWorks service for Bluemix
1. Summarize capabilities of IBM DataWorks
The IBM DataWorks service in Bluemix allows you to identify relevant data, transform the data to suit your needs, and load it to a system for use.
IBM DataWorks is available from the DataWorks service Dashboard. In IBM DataWorks, you begin by finding the data that you want to work with from data sources like IBM SQL Database and IBM dashDB. You use metrics to better understand your data quality and identify areas to improve.
To improve the data quality, you work with a sample of the data and apply shaping actions such as sorting, filtering, and joining. You can apply the actions to the full data set and load the data to destinations such as Cloudant™ NoSQL DB.
IBM DataWorks supports the source and target combinations in the following table. All of the supported targets are compatible with each source.
2. Perform common tasks using DataWorks
a. Data Loading – Filter and move data
A set of steps providing a walk through the process of using DataWorks to move a subset of data in dashDB instance to an instance of SQL Database are provided to show key concepts of the
DataWorks service.
1. Create an instance of dashDB
2. Create an instance of SQL Database
3. Create an instance of IBM DataWorks
4. Once an instance of the DataWorks service has been created in IBM Bluemix you can start using DataWorks. Launch DataWorks by clicking the hexagon for your instance of the DataWorks by clicking on its hexagon from the Bluemix Dashboard
5. Click on the arrow when the service’s landing page appears:
6. Click on Create Connections
7. Click on the dashDB icon and then click on Add Connection.
8. Give the connection a name and description and use the credential information from your dashDB’s instance credentials (note you can get this by clicking on the Show credentials link for the instance).
When you’re done the dialog should like something like this:
9. Click on Create Connection
10. Repeat steps 7-8 to Add another connection to SQL Database
11. Select Refine & Copy from the tasks list
12. Select the dashDB connection as the source
13. Select GOSALES from the Schemas column and Product from the Tables and Views column.
14. Select Product_type_code and then click Refine.
15. Click the dots on the Product_type_code column header and select Filter.
16. Scroll down and select the row with 961 from the list
17. Click on Filter and then click Next.
18. Select the IBM SQL DB connection as the target and then select the USERnnnnn schema.
19. Take the default to append data
20. Assign a name to the Activity at the top and click Run.
21. Verify the data is in SQL Database by launching the SQL Database console (see section 6.c.3.a)
22. Click on Work with Tables and select the Product table. Click Browse Data:
Verify that the PRODUCT_TYPE_CODE is 961 for all the rows (the value that you specified in the filter).
1. Summarize capabilities of IBM DataWorks
The IBM DataWorks service in Bluemix allows you to identify relevant data, transform the data to suit your needs, and load it to a system for use.
IBM DataWorks is available from the DataWorks service Dashboard. In IBM DataWorks, you begin by finding the data that you want to work with from data sources like IBM SQL Database and IBM dashDB. You use metrics to better understand your data quality and identify areas to improve.
To improve the data quality, you work with a sample of the data and apply shaping actions such as sorting, filtering, and joining. You can apply the actions to the full data set and load the data to destinations such as Cloudant™ NoSQL DB.
IBM DataWorks supports the source and target combinations in the following table. All of the supported targets are compatible with each source.
2. Perform common tasks using DataWorks
a. Data Loading – Filter and move data
A set of steps providing a walk through the process of using DataWorks to move a subset of data in dashDB instance to an instance of SQL Database are provided to show key concepts of the
DataWorks service.
1. Create an instance of dashDB
2. Create an instance of SQL Database
3. Create an instance of IBM DataWorks
4. Once an instance of the DataWorks service has been created in IBM Bluemix you can start using DataWorks. Launch DataWorks by clicking the hexagon for your instance of the DataWorks by clicking on its hexagon from the Bluemix Dashboard
5. Click on the arrow when the service’s landing page appears:
6. Click on Create Connections
7. Click on the dashDB icon and then click on Add Connection.
8. Give the connection a name and description and use the credential information from your dashDB’s instance credentials (note you can get this by clicking on the Show credentials link for the instance).
10. Repeat steps 7-8 to Add another connection to SQL Database
11. Select Refine & Copy from the tasks list
12. Select the dashDB connection as the source
13. Select GOSALES from the Schemas column and Product from the Tables and Views column.
14. Select Product_type_code and then click Refine.
16. Scroll down and select the row with 961 from the list
17. Click on Filter and then click Next.
18. Select the IBM SQL DB connection as the target and then select the USERnnnnn schema.
19. Take the default to append data
20. Assign a name to the Activity at the top and click Run.
21. Verify the data is in SQL Database by launching the SQL Database console (see section 6.c.3.a)
22. Click on Work with Tables and select the Product table. Click Browse Data:
Verify that the PRODUCT_TYPE_CODE is 961 for all the rows (the value that you specified in the filter).
0 comments:
Post a Comment