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.
Outbound queries from the report manager
When you define an outbound query with a query from the IBM TRIRIGA report manager, the mapping of data is defined in the query definition. The report labels that you specify for each field must represent the external table column name, XML node name, label value, or text field header column name.
Data maps as dynamic outbound queries
When you define an outbound query as a dynamic query, the mapping
of data is defined in the data map. With this outbound usage of
the data map, you do not map any inbound data from the external
source to existing IBM
TRIRIGA fields.
Instead, you select which fields are exported from your IBM
TRIRIGA database.
- Database scheme
- If you are using the database scheme and must export binary large objects (or BLOBs), you must use a dynamic query. You can select binary, note, or document manager content fields for export.
- Default data
- To specify default data for fields, you use a dynamic query. For example, if you are using the HTTP post scheme, you can use a dynamic query to pass a static parameter or value. For default data to work correctly with a dynamic query, you must first define and save your data map with the default data set, and then select the Generate SQL for Table action. This action sets the column to use the default data for new inserts.