TM1 Migration between different environments
Posted: Thu Aug 10, 2017 7:07 am
Hi Everyone,
I am trying to migrate all TM1 contents (TI Processes) from Teradata(TD) database to SnowFlake(SF) database. In order to make existing TI processes run on SF database, I am trying to programmatically change the ODBC "Data Source Name" under Data SOurce tab of the TI process. There are many TI processes which are having ODBC of teradata, that is why I cannot modify each one manually. I am trying to achieve this by a python code.
What my Python script is doing? Here is the answer => I have developed a Python script which will change the ODBC Data Source Name from the backend; that is, the ODBC name in the ".PRO" file which is generated after creating a TI process. The script is running as expected. But, the problem here is, when the ODBC Data Source Name is changed from TD database to SF database, this change is not being reflected at the front end of the TM1 application; meaning => the .PRO file of TI process is having ODBC name for SF database but the "Data Source Name" under Data Source tab in the TM1 is still showing ODBC name of TD database.
Is there any other way to make these changes programmatically? I need to carry out this activity as a part of automation, to avoid manual user interference.
Attachments:
1. Attachment named "Current Design" shows ODBC TD database structure.
2. Attachment named "New Design" shows changes after Python script has been executed.
I am trying to migrate all TM1 contents (TI Processes) from Teradata(TD) database to SnowFlake(SF) database. In order to make existing TI processes run on SF database, I am trying to programmatically change the ODBC "Data Source Name" under Data SOurce tab of the TI process. There are many TI processes which are having ODBC of teradata, that is why I cannot modify each one manually. I am trying to achieve this by a python code.
What my Python script is doing? Here is the answer => I have developed a Python script which will change the ODBC Data Source Name from the backend; that is, the ODBC name in the ".PRO" file which is generated after creating a TI process. The script is running as expected. But, the problem here is, when the ODBC Data Source Name is changed from TD database to SF database, this change is not being reflected at the front end of the TM1 application; meaning => the .PRO file of TI process is having ODBC name for SF database but the "Data Source Name" under Data Source tab in the TM1 is still showing ODBC name of TD database.
Is there any other way to make these changes programmatically? I need to carry out this activity as a part of automation, to avoid manual user interference.
Attachments:
1. Attachment named "Current Design" shows ODBC TD database structure.
2. Attachment named "New Design" shows changes after Python script has been executed.