Exporting data with the database scheme

When you select the outbound database scheme, you must define the data source and the outbound query. The outbound query is used to define which fields are exported from your IBM® TRIRIGA® database.

About this task

You can define an outbound query from the IBM TRIRIGA report manager. You can also define a data map as a dynamic outbound query.

Procedure

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