1. Administering Data Integration for Oracle Enterprise Performance Management Cloud
  2. EPM Integration Agent
  3. EPM Cloud to On-premises Connectivity Using the EPM Integration Agent
  4. Writing Back with the EPM Integration Agent
  5. EPM Integration Agent Write-Back Event Scripts
  6. Using a AftExport Event

Using a AftExport Event

When writing back using the EPM Integration Agent, use the AftExport to do any post processing cleanup after inserting data to the table.

The following script example shows how to call an external API that executes after the write-back.

The AftExport event in this example:

  • prints the contents of the agentContextParams map.
  • prints an info message to the agent process log. This entry is logged to the process log in EPM_APP_DATA_HOME\logs.
  • prints any severe error message to the agent process log. This entry is logged to the process log in EPM_APP_DATA_HOME\logs.

For information about EPM Integration Agent Context functions, see EPM Integration Agent Context Functions.

Note that this script is provided only as an example, and it is not warranted against defects, and users may not file a service request with Oracle support in regard to any questions or issues related to the script.

import sys

'''
After export custom script. This script will be called after the writeback finishes execution.
'''
#print "Begin: AftExport.py"

#print 'Event Type is: ' + event

'''
Print the contents of the agentContextParams map which is an unmodifiable map. 
'''
#print 'JOBTYPE: ' + agentContext["JOBTYPE"]
#print 'EPM_APP_DATA_HOME: ' + agentContext["EPM_APP_DATA_HOME"]
#print 'WRITEBACK_DATA_FILE: ' + agentContext["WRITEBACK_DATA_FILE"]
#print 'JOBID: ' + str(agentContext["JOBID"])
#print 'INTEGRATION: ' + agentContext["INTEGRATION"]
#print 'LOCATION: ' + agentContext["LOCATION"]
#print 'SOURCE_APPLICATION: ' + agentContext["SOURCE_APPLICATION"]
#print 'TARGET_APPLICATION: ' + agentContext["TARGET_APPLICATION"]



'''
Log an info message to the agent process log. This entry will be logged only to the process log in EPM_APP_DATA_HOME\logs
folder and not to epmagent.log. The log entry will be created at INFO log level.
'''
#agentAPI.logInfo("SAMPLE: INFO log message from script")


'''
Log an severe message to the agent process log. This entry will be logged into the process log in EPM_APP_DATA_HOME\logs
folder and also into epmagent.log. The log entry will be created at SEVERE log level.
'''
#agentAPI.logError("SAMPLE: SEVERE log message from script")


'''
Return false in case of error, which will throw an exception in the agent.
'''
returnValue = 'true'

#print "End: AftExport.py"