Exporting data with the file scheme

When you select the outbound file scheme, you must define the export file 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.
Note: When you create an integration object record for an outbound file scheme, the data is exported in the format that the data is stored in the database. Both the Created Time and Modified Time values are stored as millisecond values in the database. To export the data in a human-readable format, you must use the Created Date/Time and Modified Date/Time fields.

Procedure

  1. Go to Tools > System Setup > Integration > Integration Object.
  2. Add an integration object record.
  3. Specify the integration name, file scheme, outbound direction, export file, and other integration details.
  4. Test the file access.
  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. Set the Localized? check box to have query results localized.
    • If the file export type is Flat, all field values in the file will be localized.
    • If the file export type is JSON, the localized value will be contained in the JSON element where the record field name is appended with "_DISPLAY". For example, "name_DISPLAY":"Some Localized Value".
    • If the file export type is XML, the localized value will be contained in the record field child XML element named "displayValue" for each record element that is returned in the XML. For example, <displayValue><![CDATA[Some Localized Value]]></displayValue>.
  8. Create and save the record.
  9. Execute the integration.
  10. Inspect any errors.