Essbase

Get Involved. Join the Conversation.

Topic

    Vivekanand Choudhry
    Encrypting UserID and Password in Batch script while loading...
    Topic posted August 26, 2019 by Vivekanand Choudhry 
    26 Views, 1 Comment
    Title:
    Encrypting UserID and Password in Batch script while loading the data into OAC.
    Summary:
    Encrypting UserID and Password in Batch script while loading the data into OAC.
    Content:

    I need to encrypt the user ID and password in the batch script used to load the data in the OAC -Essbase application.

    While encryption is possible in the Maxl Scrpt , but here in this case, the User ID and Password has been set in the batch script

    Here it is --

    Set Username=***.YYY@aaaa.com
    Set Password=ZZZZZZZ1234

    Any one can put some light on how to do that . Thanks 
     

     

     

     

    Comment

     

    • Glenn Schwartzberg

      Why would you do it in the bat file and not MaxL. If you really needed to do it in the bat file, I think I would create a simple MaxL script with just the login statement with a cleartext ID and password then encrypt it. Then take the encrypted values and put them into your bat file then call the maxl startmaxl.bat -D xxxxxxxxxxx    encrypted userID encrypted password

      In the MaxL it would be something like login $Key $1 $key $2 on servername;