TI connection parameters in TM1 for ODBO – Third Party Authentication

When you’re authenticating using an active directory server and your authentication mode is set to 5, you need to provide additional details for connection parameters in ODBO connection properties.

ODBO Provider: IBM Cognos TM1 OLE DB MD Provider

ODBO Datasource: <TM1 server name>

ODBO UserID: <user name that you use to connect to your TM1 server>

ODBO Password: <password that you use to connect to your TM1 server>

Additional Connection Parameters: Provider String=”CAMNamespace=<your active directory server name>”

Leave remaining parameters blank.

Example:

ODBO Provider: IBM Cognos TM1 OLE DB MD Provider

ODBO Datasource: emp_dev_model

ODBO UserID: admin

ODBO Password: admin123

Provider String=“CAMNamespace=ADS”