Forum Discussion
Direct connection to TM1 CUBE
Hi, I am trying to understand the best possible ways to connect to TM1 cubes to power bi without using third party connectors. If you suggest ODBC driver can you please post me a link of the driver...
nickyvv
Most Valuable Professional
Most Valuable ProfessionalIf you don't want to use third party connectors you still have a few options:
- configure TM1 for an ODBC connection
- use Odata to connect to the cube
This question on the forum has a few good pointers to these options:
https://community.powerbi.com/t5/Power-Query/Connection-to-IBM-Cognos-TM1-via-OData/td-p/131562
- configure TM1 for an ODBC connection
- use Odata to connect to the cube
This question on the forum has a few good pointers to these options:
https://community.powerbi.com/t5/Power-Query/Connection-to-IBM-Cognos-TM1-via-OData/td-p/131562
Thanks for the reply, how do we configure TM1 ODBC ? So we would get a link for every cube to which we connect from either OData/Web connector?
- nickyvvIn the other question I mentioned there's a link to a support site with more info:
http://businessintelligence.ittoolbox.com/groups/technical-functional/cognos8-l/how-to-configure-cognos-datasource-via-odbc-connection-3263273- Thanks again, I have seen the link, just confused what driver needs to be used, for example if we need to access sql server through odbc then it would be sql odbc driver so just want the name of the odbc driver which needs to be configured