Question & Answer
Question
Many TurboIntegrator processes are using the same ODBC data source. Each time the username and password is modified, all TurboIntegrator processes have to be updated one by one. How to avoid this?
Answer
ODBC connection informations can be centralized in some places like a Planning Analytics Cube or a database table. From here, there are some TurboIntegrator Local Variables that can be used to modify ODBC informations.
The list of all usable TI Local Variables is here :
https://www.ibm.com/docs/en/planning-analytics/2.0.0?topic=tv-turbointegrator-local-variables
The ones that can be used to change ODBC connection information in case of user name or password modification are the following :
DatasourceUsername
DatasourcePassword
These variables have to be set in the Prolog.
[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSD29G","label":"IBM Planning Analytics"},"ARM Category":[{"code":"a8m3p000000LQtUAAW","label":"Planning Analytics"}],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions","Type":"MASTER"}]
Was this topic helpful?
Document Information
Modified date:
22 June 2023
UID
swg21883104