Encrypted credentials for session creation

[cino189]

Hi, I'm wondering if there is any way to pass encrypted credentials to the Essbase server when using the connect command. When using the essbase client it is possible to connect to essbase using encrypted credentials and a private key that can be generated by the MaxL client itself. I would assume the functionality is available via the dll, since the client is using it as well.

Is this possible already or is it an enhancement?

Thanks

[nurzen]

Hello, i never tried it, but essbasepy uses MaxLSessionCreate to connect to the server and in the essmaxl.h the is no hint for a private key to pass to that function. Also there is not one occurence of the word key in essmaxl.h so i think it wont work out of the box.

I also found no hint in the java API for encrypted connections, maybe Oracle does not provide that functionality via API.

Greets Kevin

[cino189]

Hi Kevin, thank you for the answer. I assume then that the decryption happens before the credentials are passed to essbase in the client.

I looked a bit in the dlls in the client folder and i found one that looks appropriate: esssecu.dll

Inside a found a function called: Essdecrypt.

See the attached screen.

However I agree this is not a quick fix, since it would require an additional step to decrypt the credentials before logging in. Given the circumstances it might be even quicker to use a custom encryption/decryption algorithm directly in python.