Writing Back with the EPM Integration Agent

The EPM Integration Agent supports write-back by enabling you to move data from your Oracle Enterprise Performance Management Cloud applications to your on-premises database. To use this feature, you register a data export application to export data to the on-premises database.

• Simple method—you register the application and specify the table name and include all the columns from the table in the application. The system generates the INSERT statements automatically and loads the data.

  To use this method, create a CSV file with the list of columns to export. The names of the column must exactly match the column name in the table. The name of the file must be the name of the application.

• Advanced method—you specify an INSERT statement in the query definition page. The INSERT statement contains the table and column for values and the dimension name of the application. Using this method, you can provide a user-friendly dimension name and also use SQL functions like TO_DATE, TO_NUMBER and other functions to perform data type conversions and other string operations.

  To use this method, create a CSV file with the list of columns to export. The list of columns must exactly match the column name you use in the INSERT statement. The name of the file must be name of the application.

Additionally, the agent can execute two event scripts during the write-back execution: BefExport and AftExport. Using a BefExport event, you can perform any action before inserting data to the table or you can override the default insert processing. Using an AftExport event, you can do any post processing cleanup after inserting data to the table.

The write-back feature is supported for agents running in both SYNC and ASYNC modes.