ODBO Adapter to Analysis Services
- George Regateiro
- MVP
- Posts: 326
- Joined: Fri May 16, 2008 3:35 pm
- OLAP Product: TM1
- Version: 10.1.1
- Excel Version: 2007 SP3
- Location: Tampa FL USA
ODBO Adapter to Analysis Services
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?
-
- MVP
- Posts: 3657
- Joined: Fri Mar 13, 2009 11:14 am
- OLAP Product: TableManager1
- Version: PA 2.0.x
- Excel Version: Office 365
- Location: Switzerland
Re: ODBO Adapter to Analysis Services
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.
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.