IBM TRIRIGA Application Platform Version 3.5.0

Overview of the TRIRIGA integration object

When you use the integration object to define a new integration definition, you must select the data scheme. Depending on your scheme selection, you must define several elements that can include the data source, import or export file, outbound query, data map, or response map.

Integration object records

To define a new integration definition, you must create an integration object record from the TRIRIGA® integration object. To view existing integration object records, select Tools > System Setup > Integration > Integration Object.

Data schemes
When you define a new integration definition, you must select from several options or schemes to define the payload, protocol, and transport for the data.
Database tools
When you select the database scheme or DataConnect scheme, you can test the database connection, generate the test data, or generate the SQL for the database table. To export binary large object fields, you must use a dynamic outbound query.
File tools
When you select the file scheme or DataConnect scheme, you can test the file connection. You can read from or write to anywhere on the network that the server can access.
HTTP post tokens
When you select the outbound HTTP post scheme, you can add tokens to the values in the Http URL, Http URI, and Headers fields. You can also add tokens to the Parameters field, which is only visible for the Parameter post type.
Outbound queries
For outbound integrations, you must define an outbound query to select which fields are exported from your IBM TRIRIGA database. You can define an outbound query from the IBM TRIRIGA report manager. You can also define a data map as a dynamic outbound query.
Data maps
For inbound integrations, you must define a data map that maps the data from the external source to existing IBM TRIRIGA fields. However, for outbound integrations, you can also define a data map as a dynamic outbound query to select which fields are exported from your IBM TRIRIGA database.
Response maps
For outbound HTTP post integrations, you must define a response map that maps the response parameters from the HTTP request to existing IBM TRIRIGA fields. Although the response map is organized like the data map, it applies to the HTTP post scheme only and it allows simple response values only.
Data validation
You can validate integration object records and specify the maximum number of validation errors that can occur before the importing process is stopped. You can also choose to validate these records with or without loading any records into TRIRIGA staging tables or creating any DataConnect jobs. Time formatting options are also provided on the data map tab for validation purposes. Data validation is only available when you import data with the DataConnect scheme.

Parent topic: Integrating data with the TRIRIGA integration object

Feedback