EPM AUTOMATE UTILITY – copyfilefrominstance, listfiles & deletefile

Oracle added a new EPM Automate utility with July-2018 update. A new version of the EPM Automate Utility is available with this update. This version includes the copyfilefrominstance command, which copies a file from a source environment to the target environment from which you run the command.

This version also includes changes to the following commands to make them consistent with other file operation commands:

listfiles: now lists snapshots and files available in an environment.

deletefile: now deletes snapshots and files from an environment.

Let’s explore the new version of the utility & try these commands.

copyfilefrominstance: Copies a file from a source environment to the environment (target) from which you run this command. Before running this command, start an EPM Automate Utility session and sign into the target environment.

Syntax:

epmautomate copyfilefrominstance SOURCE_FILE_NAME USERNAME PASSWORD_FILE URL IDENTITYDOMAIN TARGET_FILE_NAME

where:

• SOURCE_FILE__NAME is the name of the file (including extension) that you want to copy from the source environment.

• USERNAME is the user name of a Service Administrator of the source environment.

• PASSWORD_FILE is the name and location of the file containing the encrypted password of the Service Administrator of the source environment.

• URL is the URL of the source environment.

• IDENTITYDOMAIN is the identity domain of the source environment.

• TARGET_FILE_NAME is a unique name for the file (including extension) in the environment from which you run this command.

Example:

epmautomate copyfilefrominstance "abcd.zip" username "C:\users\documents\ EPMAutomate\password.epw" https://test-cloud-pln.pbcs.us1.oraclecloud.com IdentityDomain "target data file.zip"

listfiles: Lists the files in the

·       default location,

·       Data Management folders,

·       inbox/ outbox.

·       Also lists incremental and backup export files, and Migration snapshots.

Syntax:

epmautomate listfiles

deletefile: Deletes

·       a file

·       or a snapshot from the default upload location,

·       a Data Management folder,

·       or from profitinbox/profitoutbox.

To delete a file from a location other than the default upload location, you must specify the file location.

Syntax:

epmautomate deletefile "location/FILE_NAME"

Thanks for your time in reading this, meet you all in the next post!!!!

Best Regards,

SST.!

How to Encrypt the Admin Password When Used on a Batch Script

Hi there :)

In this post we will work on encryption of administration password for cloud by using the EPMAUTOMATE utility which we use in batch scripting. Below are the steps we have to follow to encrypt it.

Before continuing, ensure the EPMAUTOMATE has been installed on the computer from which you are running the utility.

1. Click Start, then All Programs, then EPM Automate, and then Launch EPM Automate.

2. Generate a password encryption file. You use the password encryption file to pass encrypted password to initiate a session.

Command Line Example:

epmautomate encrypt P@ssword1 myKey C:\Oracle\EPM\bin\password.epw

• PASSWORD is the password of the Service Administrator in the service. You cannot use corporate credentials with the EPM Automate Utility.
• KEY is the private key that is to be used to encrypt the password.
• PASSWORD_FILE is the name and location of the file that stores the encrypted password. The password file must use the .epw extension.

3. Start a session as a Service Administrator. Use a command line as describe.

epmautomate login adminid C:\Oracle\EPM\bin\password.epw

https://test-cloudpln.pbcs_us1.oraclecloud.com IdentityDomain

4. Sign out of the Service instance.

epmautomate logout


Thanks for your time in reading this, meet you all in the next post!!!!

Best Regards,

SST.!