cubewise-code / tm1py

TM1py is a Python package that wraps the TM1 REST API in a simple to use library.
http://tm1py.readthedocs.io/en/latest/
MIT License
190 stars 109 forks source link

get/ set _datasource_password #158

Closed marfrit closed 5 years ago

marfrit commented 5 years ago

If I get a _datasource_password from a process (entered in TI before, working), and then proceed to set the string I got (which is different from the actual password), the TI process cannot connect to the database. Any idea how the password is encrypted before it is saved to the .pro file?

I think this is not an TM1py issue, but maybe someone came accross the same hurdle.

MariusWirtz commented 5 years ago

Hi @marfrit ,

I suppose IBM is not going to tell anyone what their encryption algorithm is. I would say the way to manage it is to use single sign on and have a DB account for whatever system user is running the TM1 service. Or store the password in a TM1 cube and retrieve it on the prolog.

Cheers,

Marius

marfrit commented 5 years ago

Yes. For the time being, I just put the plain text password in _datasouce_password on setting and it then works fine.