5. Move data from dashDB to Cloudant Database

In this section, you’ll move a subset of data in your dashDB instance to your instance of Cloudant NoSQL DB by using Data Connect.

  1. Return to the Bluemix Apps Dashboard.
  2. Scroll down to Services and click the row for your Data Connect service instance.
  3. Click LAUNCH to open the Data Connect dashboard in a new browser tab.
  4. Optional: review the Welcome panels describing high level steps of using Data Connect.
  5. Click Connections to begin creating a connection for your Db2 Warehouse on Cloud instance.
  6. Select IBM dashDB connection type to open the correct connection definition wizard for the service.
  7. Give the connection a name like myCloudWarehouse and enter in the hostname, name of database, username, and password from the credentials you copied for the Db2 Warehouse on Cloud instance. You’ll need the hostdbusername, and password field values that you saved.
  8. Click Create Connection to create the database connection.
  9. The display will show the Connections panel where you will see the connection that was just added. Click on Create New to begin creating a connection for your Cloudant NoSQL DB instance.
  10. Select IBM Cloudant to open the connection definition wizard for Cloudant.
  11. Give the connection a name like myCloudant and enter in the url, username, and password from the credentials you copied for the Cloudant instance. You’ll need the urlusername, and password field values that you saved.
  12. Click Create Connection to create the database connection.
  13. From the left pane, click Activities to open the Activities panel.
  14. Click on Create New to define an activity to move data from one connection to another.
  15. Select your Db2 Warehouse on Cloud connection item, then the GOSALES schema and the PRODUCT table.
  16. Click on Refine Data
  17. elect the PRODUCT_TYPE_CODE column and then from the Operations panel, expand the Cleanse item.
  18. Select Filter Rows.
  19. Select the value 961 and then click Apply to save the row filter.
  20. If you prefer, you can edit the activity name to change it. Click Next to continue to the target selection screen.
  21. Select your Cloudant database connection item.
  22. Click Save to save the activity and then click on the Run icon to begin the filter and copy activity from Db2 Warehouse on Cloud to Cloudant.
  23. Click on the newly added activity tile to open the Activity Dashboard.
  24. Refresh the page until the run status shows complete.