Hello everyone,
I wanted to share an interesting finding regarding the management of passwords in TM1 TurboIntegrator (TI) processes and see if this is a known or recommended method within the community.
Recently, I created a new TI process and defined a datasource connection. When entering the username and password, I noticed that clicking the (eye) icon allowed me to reveal the password in clear text. After saving and reopening the process, the password field displayed what appears to be an encrypted string instead of the plain text password.
I copied this encrypted string and used it in another TI process like so:
ODBCPassword = 'the password string from the test process';
ODBCOpen('Datasouce', 'user', ODBCPassword)
To my surprise, this method worked flawlessly, allowing me to open the ODBC connection without exposing the actual password in plain text in my scripts.
My questions for the community are:
I look forward to hearing your thoughts and any experiences you might have with this!
Best regards,
------------------------------
Asgeir Thorgeirsson
Financial Solutions Engineer
Icelandair
------------------------------