TM1 Forum

I have been working on some processes to connect to and bring in information from Analysis Services. This is working fine my question comes in the setting up of the connection. After you select the ODBO adapter you have to put in the server and path to the database. Is there anyway to make this dynamic for when we move to our different environments?

Hi George,

Check the TurboIntegrator Local Variables section of the Reference guide for the DataSourceODBO* set of variables. As with other types of data sources you can set all this programatically on the prolog tab. This should be all that you need.