Encrypt Essbase UserID and Password in MaxL script

Hi, You all would be using Encryption - Decryption of MaxL script containing userID and password for Essbase server. But I just thought of posting it in my blog so that if some of you want a quick reference without going to Technical Reference guide.

Follow the below easy steps to encrypt and decrypt the MaxL script:

Step 1: Create a simple MaxL script (Loginscript.mxl) to login into Essbase server using MaxL commands login on ; logout; 


Step 2: Run essmsh -gk command to generate Encryption and Decryption code 


         D:\oracle\Middleware\EPMSystem11R1\common\EssbaseRTC\11.1.2.0\bin>essmsh -gk 
         Essbase MaxL Shell - Release 11.1.2 (ESB11.1.2.1.0B347) Copyright (c) 2000, 2011, Oracle
         and/or its affiliates. All rights reserved. 
     
        Public Key for Encryption: 13005,692804953 
        Private Key for Decryption: 565324885,692804953 


       MaxL Shell completed 


Step 3: Encrypt Loginscript.mxl by issuing the below command along with Encryption Code generated above. This would create an encrypted MaxL script with extension Loginscript.mxls


      D:\oracle\Middleware\EPMSystem11R1\common\EssbaseRTC\11.1.2.0\bin>essmsh -Em D:\ 
      Scripts\Loginscript.mxl 13005,692804953 


         Essbase MaxL Shell - Release 11.1.2 (ESB11.1.2.1.0B347) Copyright (c) 2000, 2011, Oracle 
         and/or its affiliates. All rights reserved. 


Step 4: Open the file Loginscript.mxls to check whether the userID and Password got encrypted or not.  

       login $key 225460064724436062164017310 $key 137249360634406684332940616180146296;  
       logout; 


Step 5: If you want to execute encrypted file, run the below command with decryption code 
        
      D:\oracle\Middleware\EPMSystem11R1\common\EssbaseRTC\11.1.2.0\bin>essmsh -D D:\S   
      cripts\Loginscript.msh.txts 565324885,692804953 
    
        Essbase MaxL Shell - Release 11.1.2 (ESB11.1.2.1.0B347) Copyright (c) 2000, 2011, Oracle 
        and/or its affiliates. All rights reserved. 


        MAXL> login $key 225460064724436062164017310 $key 37249360634406684332940616180  
       146296; 
              
               OK/INFO - 1051034 - Logging in user [admin@Native Directory]. 
               OK/INFO - 1241001 - Logged in to Essbase. 


        MAXL> logout; 


               User admin is logged out 
               MaxL Shell completed 

Hope these simple steps would help you all while encryting and executing an encrypted MaxL script 

Keep Sharing