Importing data with the database scheme

When you select the inbound database scheme, you must define the data source and the data map. The data map is used to map the data from the external source to existing IBM® TRIRIGA® fields.

Procedure

  1. Go to Tools > System Setup > Integration > Integration Object.
  2. Add an integration object record.
  3. Specify the integration name, database scheme, inbound direction, data source, and other integration details.
  4. Test the database connection or generate the test data.
  5. Define the data map by specifying the module, business object, form, and fields. Save the data map.
  6. If you defined default data or must create generic SQL, generate the SQL for the database table.
  7. Create and save the record.
  8. Execute the integration.
  9. Inspect any errors.