Synchronizing Oracle Enterprise Data Management Cloud Dimensions and Mappings with EPM Cloud Applications

This sample scenario explores synchronizing a dimension between an Oracle Enterprise Data Management Cloud application and an Oracle Enterprise Performance Management Cloud application.

You use the scripts in this section to complete these tasks:

Export a dimension from an Oracle Enterprise Data Management Cloud application
Export mappings from an Oracle Enterprise Data Management Cloud application dimension
Copy the export files to an EPM Cloud environment
Import dimension metadata and mappings into the EPM Cloud application

To synchronize a dimension and mappings between an Oracle Enterprise Data Management Cloud application and an EPM Cloud application:

Create a script file by copying the following script:

rem Integration example to sync application dimensions between EDM and EPM Cloud
rem Windows script for demonstration purposes only; do not use in production environments

set EDMUSER=userid
set EDMSVR=https://hostname
set EDMPWDFILE=example_EDM
set EDMAPP=appname
set EDMDIM=dimname
set EDMLOC=location

set EPMUSER=userid
set EPMSVR=https://hostname
set EPMIMPJOB=importjobname
set PWDFILE=C:\Oracle\EPM.epw
set DIMFILE=dimension.csv
set MAPFILE=mapping.csv

rem Synchronizing EDM ---> EPM
rem Export Dimension and Mappings from EDM

call epmautomate login %EDMUSER% %EDMPWDFILE% %EDMSVR%
call epmautomate exportdimension %EDMAPP% %EDMDIM% %DIMFILE%
call epmautomate exportdimensionmapping %EDMAPP% %EDMDIM% %EDMLOC% %MAPFILE%
call epmautomate logout

rem Log into the EPM Cloud environment
call epmautomate login %EPMUSER% %PWDFILE% %EPMSVR%

rem Copy exported files from EDM environment to EPM and import metadata and mappings
call epmautomate copyfilefrominstance %DIMFILE% %EDMUSER% %EDMPWDFILE% %EDMSVR% inbox/%DIMFILE%
call epmautomate importmetadata %EPMIMPJOB%

call epmautomate copyfilefrominstance %MAPFILE% %EDMUSER% %EDMPWDFILE% %EDMSVR% inbox/%MAPFILE%
call epmautomate importmapping %EDMDIM% %MAPFILE% REPLACE FALSE %EDMLOC%

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.

Parameters for Script Execution

The script files in this section requires you to specify some of the parameter values explained in the following table. Not all these parameters are used in all the scripts.

Table 3-27 Parameter Values for Script Files

Parameter	Description
`EDMUSER`	User login ID of a Oracle Enterprise Data Management Cloud Service Administrator. Example: `EDMUSER=jdoe@example.com`
`EDMSVR`	URL of the Oracle Enterprise Data Management Cloud environment. Example: `EDMSVR=https:// example.oraclecloud.com`
`EDMPWDFILE`	Name and location of the encrypted password file (EPW) of the Oracle Enterprise Data Management Cloud Service Administrator. Example: `EDMPWDFILE=edm_jdoe.epw`
`EDMAPP`	Name of an Oracle Enterprise Data Management Cloud application dimension. Example: `EDMAPP=USOperations`
`EDMDIM`	Name of the dimension to export or import. Example: `EDMDIM=entity`
`EDMLOC`	Name of the location to export. Example: `EDMLOC=Loc1`
`EPMUSER`	Login name of an EPM Cloud Service Administrator. Example: `EPMUSER=john.doe@example.com`
`EPMSVR`	URL of the EPM Cloud environment. Example: `EPMSVR=https://example.oraclecloud.com`
`EPMIMPJOB`	Name of an existing import job of type import metadata in the EPM Cloud environment. Example: `EPMIMPJOB=imp_DIMMetadata`
`EPMEXPJOB`	Name of an existing job of type `export metadata` in theEPM Cloud environment. Example:`EPMEXPJOB=Exp_DIMMetadata`
`PWDFILE`	Name and location of the encrypted password file (EPW) for EPM Cloud Service Administrator. See the `encrypt` command. Example: `PWDFILE=pwd_jdoe.epw`
`DIMFILE`	Name of the file to hold exported dimension data. Example: `DIMFILE=entity_file.CSV`
`MAPFILE`	Name of the file to hold exported mapping data. Example: `MAPFILE=map_file.CSV`