Importing data with the DataConnect scheme

When you select the inbound IBM® TRIRIGA® DataConnect scheme, you must define the data source, the import file, the DataConnect job, and the data map.

About this task

The data source is used to access the DataConnect staging tables. The data map is used to map the data from the file to the DataConnect staging tables.

When you run the integration, the entries are inserted or updated in the DataConnect staging tables with an upsert (update or insert) action. You must select one or more fields as key fields. DataConnect uses the keys to determine whether it needs to insert or update the row.

Procedure

  1. Go to Tools > System Setup > Integration > Integration Object.
  2. Add an integration object record.
  3. Specify the integration name, DataConnect scheme, data source, import file, and other integration details.
  4. Test the database connection.
  5. Test the file access.
  6. Create and save the record.
  7. Define the data map by specifying the module, business object, form, and fields. Save the data map.
  8. Specify whether to validate and identify invalid records. If you specify not to validate, the DataConnect Job loads data from the staging table into the environment only if the entire data file is loaded successfully.
  9. Save the record.
  10. Execute the integration.
  11. Inspect any errors.