EPMA Batch Script Password Encryption

Anyone who has used the EPMA batch script utility in the past knows that one of its biggest weaknesses was the fact that you could not encrypt the password, leaving the admin login vulnerable.  Granted, there were other ways to get around this “defect”, but they were not inherent to the system and sometimes were more trouble than it was worth.  With release of 11.1.2.3, Oracle finally provided the functionality of password encryption.

When I researched today how to do this, I realized that there is little information out on the web on how to do this…in fact, there was none outside of the 11.1.2.3 release notes from Oracle.  So, I realized I had a mission – to figure out how and to post the steps needed to encrypt my EPMA batch user password.  Below are the steps to do so:

  1. Open the batch utility client, located on your Foundations server at \Oracle\Middleware\EPMSystem11R1\products\Foundation\BPMA\EPMABatchClient\epma-batch-client.bat
  2. The client has a new command – “encrypt”.  Use this command to encrypt your password.  In this example, my password is “EssbaseForever” and I’m telling the client to save the password to D:/Password.txt.

    3.  You might get confused at first, but once you hit Enter, the client will close and you will not have a command prompt screen anymore.  This is fine…go to the directory where you specified the password to be stored and you will see the file.
    4.  If you open the file, you will see your password encrypted.
     5.  Once you move the encrypted file to the location of your choice, embed the location in your batch script so that you are set to go!

4 comments

  1. HI, thanks for the post.. this is exactly what i m looking for.. is it possible to do with 11.1.2.2 ? I just tried and didn’t seem to work..

  2. Hi Sarah…..thanks for the great post. I just implemented this and it works when I run this in maxl on the server. But when I embed the location into a variable file it fails. My variable file is Set Essuser= ‘usr’ then Set Esspassword=’location of encrypted password’. Any thoughts ?

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s