Planning Analytics

Planning Analytics

Get AI-infused integrated business planning

 View Only

Using Encrypted Passwords in TM1 TurboIntegrator Processes

  • 1.  Using Encrypted Passwords in TM1 TurboIntegrator Processes

    Posted 10/15/24 09:16 AM
    Edited by Asgeir Thorgeirsson 10/15/24 09:25 AM

    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:

    • Is this method a known practice in our community?

    • Are there any potential security implications I should be aware of when using this approach?

    I look forward to hearing your thoughts and any experiences you might have with this!

    Best regards,



    ------------------------------
    Asgeir Thorgeirsson
    Financial Solutions Engineer
    Icelandair
    ------------------------------