Friday, July 10, 2020

Oracle EDMCS Idea... Allow saved connections to be used in exportDimension EPM Automate command

Allow saved connections to be used in exportDimension EPM Automate command

Description:
In the Feb 2020 Release of EDM there was an updated command added to EPM Automate for EDM called exportDimension. This new command is missing the ability to specify a defined connection for the export. 
We need the ability to specify the saved connection in EDM for this command so that we can send exports to both EPM targets (Consolidations & Planning) along with ERP (FCGL) targets. 
Use Case and Business Need:
The business wants to use a consistent batch scripting tool without the overhead of REST API or OIC build efforts. Using EPM Automate allows for simple batch command line automation from EDM into the supported applications. 
As an Oracle Cloud application, it is expected that simple configuration in needed to integrate from EDM to EPM or FCGL application as these are out of the box "detected application adapters" provided in EDM for EPM and FCGL.
More details:
Having the option in the exportDimension command or a new command called something like exportDimensionWithConnection is a must have to complete the enterprise data governance process from reference data inception through approval and ultimately into the target consuming applications.

No comments:

Post a Comment