Onboarding Data from Db2 for AS/400

Prerequisite

Ensure that you manually add the db2jcc_license_ cisuz.jar file to the following folder:

$IW_HOME/lib/ingestion/connectors /db2_as400/lib/dist-jobs

To obtain this jar file, contact the database admin or IBM. For more details, see IBM Support Documentation.

Creating a Db2 for AS/400 Source

For onboarding data from a Db2 for AS/400 source, see $link[page,209865,auto$] a rdbms. Ensure that the Source Type selected is Db2 for AS/400.

Once the settings are saved, you can test the connection.

$inline[badge,NOTE,primary] Crawling auxiliary tables is not supported.

Configuring a Db2 for AS/400 Table

With the source metadata in the catalog, you can now configure the table for CDC and incremental synchronization.

1. Click the Configuration link, for the desired table.
2. Provide the ingestion configuration details.

Target Configuration

Configure the following fields:

Optimization Configuration

Configure the following fields:

Advanced Configuration

Following are the steps to set advanced configuration for a table:

Add Configuration

1. Click the Data Catalog menu and click Ingest for the required source.

$inline[badge,NOTE,primary] For an already ingested table, click View Source -> Tables -> Configure for the required table.

And then click the Advanced Configuration tab.

2. Click the Configure Tables tab, click the Advanced Configuration tab and click Add Configuration.
3. Enter key, value, and description. You can also select the configuration from the list displayed.

Add Subscribers

You can add subscribers to be notified for the ingestion at the table level.

1. Click the Data Catalog menu and click Ingest for the required source.

$inline[badge,NOTE,primary] For an already ingested table, click View Source -> Tables -> Configure for the required table.

And then click the Advanced Configuration tab.

2. Click the Configure Tables tab, click the Advanced Configuration tab and click Add Subscribers.
3. Enter the following fields:
   1. E-mails: The e-mail ID of the subscriber.
   2. Notify via e-mail or Slack: The means of notification.
   3. Notify for: The jobs for which subscribers must be notified.

Sync Data to Target

Using this option, you can configure the Target connections and sync data as described in the section $link[page,210065,auto$].

The following are the steps to sync data to target.

1. From the Data Sources menu, select one of the tables and click View Source/Ingest button.
2. Select the source table to be synchronized to Target.
3. Click the Sync Data to Target button.
4. Enter the mandatory fields as listed in the table below:

5. Click Sync Data to Target to sync the data to the Target table.
6. Click $link[page,209865,auto$] to navigate back to complete the onboarding process.