Synchronizing EPM Cloud Dimensions with Oracle Enterprise Data Management Cloud Applications
This sample scenario explores synchronizing a dimension between an Oracle Enterprise Performance Management Cloud application and an Oracle Enterprise Data Management Cloud application.
You use the scripts in this section to complete these tasks:
- Export metadata (dimensions) from an EPM Cloud application
- Copy the export files containing dimension data to an Oracle Enterprise Data Management Cloud environment
- Import dimension metadata into the Oracle Enterprise Data Management Cloud application
To synchronize a dimension between an EPM Cloud application and an Oracle Enterprise Data Management Cloud application:
- Create a Windows script file by copying the following
script:
rem Integration example to sync an application dimension between EPM Cloud and EDM rem Windows script for demonstration purposes only; do not use in production environments set EDMUSER=userid set EDMSVR=https://hostname set EDMPWDFILE=example_EDM.epw set EDMAPP=appname set EDMDIM=dimname set EPMUSER=userid set EPMSVR=https://hostname set PWDFILE=example_epm.epw set EPMEXPJOB=exportjobname rem Synchronizing EPM ---> EDM rem Export Metadata from EPM call epmautomate login %EPMUSER% %PWDFILE% %EPMSVR% call epmautomate exportmetadata %EPMEXPJOB% call epmautomate logout rem Import Dimension to EDM rem Log into the EDM environment call epmautomate login %EDMUSER% %EDMPWDFILE% %EDMSVR% rem Copy exported metadata file into the EDM environment call epmautomate copyfilefrominstance %EPMEXPJOB%.zip %EPMUSER% %PWDFILE% %EPMSVR% %EPMEXPJOB%.zip call epmautomate importdimension %EDMAPP% %EDMDIM% ReplaceNodes %EPMEXPJOB%.zip call epmautomate logout
Modify the script file and set the required parameter values. See Parameters for Script Execution for explanation and example of the parameters.
- Run the script manually or schedule it to run as needed. See Automating Script Execution.