Folks, I find encryption fascinating with MAXL and hence this post. Today we will do a real word small example regarding the same.
In the example below we will encrypt a MAXL file, Decrypt it and create a batch for automation.
Step 1) Type essmsh -gk
Generate Public and Private Keys
Public Key for Encryption: 30289,2059835629
Private Key for Decryption: 1898169137,2059835629
Step 2) Select the script you want to execute. In above case, lets take a simple script(encryptit.msh) which logs into the Essbase and Sets the Database note for one of the cube.
In your case username, password, server and Essbase cube names will be different.
login vaneetgupta ‘welcome’ on ‘dce-spapp02’;
Alter database T_FIN_V2.T_FIN_V2 Set Note “Testing Encryption”;
exit;
Step 3) In the next step we encrypt the file and the new file encryptit.mshs will be created.
Type essmsh -E encryptit.msh 30289,2059835629
As you can see above the login id and password has changed to keys.
Step 4) Decrypt the file using private key and create a batch as shown below
Step 5) Run the batch and check the Essbase for Database note
So we have seen how we have done the needful without anyone looking at the username password of the person who logs in.
Download the code from: http://www.mediafire.com/?im2dq4u6asi36ss
Password = encryptit
Cheers!
Hyperion EPM 