Find and Download Files from an Oracle EPM Cloud Environment

In this Blog lets see the example script to automate the process of downloading files from an Oracle Enterprise Performance Management Cloud environment using a text string as a wildcard.

This script matches the string specified in the FILENAME parameter with file names displayed using the listfiles command, then automatically downloads the matching files.

Ensure you set the appropriate search string to the FILENAME parameter. For example, FILENAME="Scheduler Output/epm" will match file names containing "Scheduler Output/epm" in the listfiles command output, identifying the files to download.

Automation PowerShell Script to invoke EPM Automate commands!

Lets have a detailed walkthrough of the PowerShell script detailing its purpose and functionality. The script is designed to perform several tasks: logging into the EPM, run the Data Management Integration rule, download the generated extract created by the integration rule, download the data file & then logout from the EPM instance.