As of version 2.0.69 of IBM Planning Analytics Workspace (PAW), you are now able to update the ODBC connection for multiple TurboIntegrator (TI) processes at once. For prior versions, you would have needed to open each process to update the connection.

To utilize this new feature, go to the Workbench in PAW. This is under the Data and Models pane on the PAW homepage.

Once there, click on the “Create” dropdown menu and select “Workbench.”

In the navigation pane on the left, expand the server in which you’d like to update and right-click on the “Processes” node. Select “ODBC settings.”

In the next window, select the processes that you’d like to update. Only processes whose data source is ODBC will appear in the list. Next, click on the “Edit” button in the top right corner of the table.

In the next window, select the change you’d like to make. 

Once a change is checked, a textbox will appear allowing you to update the value.

IBM Planning Analytics, which TM1 is the engine for, is full of new features and functionality. Not sure where to start? Our team here at Revelwood can help. Contact us for more information at info@revelwood.com. And stay tuned for more Planning Analytics Tips & Tricks weekly in our Knowledge Center and in upcoming newsletters!

Read more IBM Planning Analytics Tips & Tricks:

IBM Planning Analytics Tips & Tricks: Making Assets Accessible to Applications and Plans

IBM Planning Analytics Tips & Tricks: Converting Existing Applications

IBM Planning Analytics Tips & Tricks: Introduction to Apps and Plans