Mapping a single source table to Cloudant

You can use a wizard to map a source table to a Cloudant® database using the Cloudant option in the CDC replication engine for InfoSphere® DataStage®.

Procedure

  1. Click Configuration > Subscriptions.
  2. Select a subscription, right-click and select Map Tables.
  3. Select Custom InfoSphere DataStage Mappings and click Next.
  4. Select Cloudant and click Next.
  5. Expand the database, schema, or table from the Source Tables list to view tables from your database that are available for mapping. Right-click the database user or schema and click Refresh if you do not see your table listed.

    You may be prompted to filter databases, schemas, or tables if Automatically prompt for filter when expanding nodes is enabled in your preferences. To manually define a filter, select a datastore, database, or schema and click Specify Filter.

  6. Enable the table to map from the Source Table list. If you do not see your table listed, right-click the database user or schema and select Refresh.
  7. If you want to hide columns so that the target is not aware of them, select a source table and click Filter Columns. Clear the check box for the column you want to hide and click OK.
  8. Click Next.
  9. Enter the Cloudant Database to select the destination of source changes.
  10. Select the source columns that represent the Primary Key for the Cloudant document.
  11. To specify the table as a repeating element in a compound document, select an existing table mapping as a Parent Table. The Cloudant Database for the parent and child tables must be the same.
  12. Review the mapping settings.
  13. Click Finish.