Overview of the TRIRIGA DataConnect process

IBM® TRIRIGA DataConnect is a tool for importing external data into the IBM TRIRIGA database. It is useful for both initial loads of data and for batch insert and batch update of data on a recurring basis.

With DataConnect, you can write data from an external source directly into the IBM TRIRIGA staging tables. Then, you can use workflows to process the data for insertion into IBM TRIRIGA business objects. In addition to pushing the data, you also can store the data into the language tables.

Implementing the DataConnect process includes the following basic steps:
  • Prepare the staging tables for the business objects that are populated or updated from the external source.
  • Prepare the DataConnect job control business object. This business object controls the integration instance.
  • Prepare the mechanisms to move data from the external source into the appropriate business object staging tables and the DataConnect job control table. You can use ETL maps or SQL.
  • Prepare the workflows to move data from the business object staging tables into new or updated records. Initiated by the DataConnect agent, these workflows can also validate the input data and implement other business logic.