Exporting file-based data

With the data export feature, you can perform a bulk export of message data from a file to an external system. You can initiate the export process for each publish channel that is associated to an external system.

Before you begin

In a multitenancy environment, you can use the data export feature only if the system provider provides you with access to a file server that is accessible by the application server. You must then configure a file-based endpoint to point to the location of this file server.

You must enable both the external system and the publish channel before you can export data. The data for export must either be in an XML file format that adheres to the object structure schema or in a delimited flat file, such as comma separated, that is a flattened version of the object structure schema format.

About this task

The optional SQL query that you enter in the Export Condition field, can affect the size of the exported XML message. You can filter the content to limit the amount of data that is being exported. The export process performs the standard outbound processing on the result set of the query for the selected publish channel.

Procedure

  1. In the External Systems application, click the Publish Channels tab and select the publish channel that you want to export.
  2. In the End Point field, specify a file-based endpoint handler, for either XML file or flat file format.
  3. Click Data Export.
  4. Optional: Enter a SQL query in the Export Condition field. The query must be against the primary or top-level object in the publish channel object structure.
  5. Optional: Specify an integer value in the Export Count field to limit the number of records that are contained in the exported file. If the result of the query contains more records than the number you specify, those records are not included in the exported file.
  6. Click OK to begin the data export process.

What to do next

When the data export is executed, the selected data is formed into a message and dropped into the outbound queue that is configured for the publish channel and its corresponding external system. The message is then processed from the outbound queue to the configured endpoint. If an error occurs when delivering a message to the endpoint, you can manage and view the data export messages that are flagged with an error in the Message Reprocessing application.