Forum Discussion
Connect to IBM Cognos/TM1/Planning Analytics
Hi everyone, What is the best way to connect PBI to Cognos/TM1/Planning Analytics cubes? I know there is no connector built into PBI at the moment for this. Instead of dumping cubes into a SQ...
Anonymous,
Please review my reply in the similar thread below. You can able to use ODBC connector or web connector in Power BI Desktop to connect to Cognos TM1 database.
https://community.powerbi.com/t5/Integrations-with-Files-and/Connection-to-IBM-Cognos-TM1-via-OData/td-p/131562
Regards,
Lydia
Hi Ben
Sorry for the late reply, thanks for trying TMVGate, glad it worked well for you.
For anyone facing similar problems, please feel free to try the free TMVGate trial. TMVGate is a purpose-built gateway and an efficient solution. It allows you to connect your data in Planning Analytics/TM1 to industry leading BI tools like PowerBI.
It has a lightweight server based architecture and does not require any software or driver on the client workstation, making it ideal for widespread deployment.
TMVGate returns Cube view (private or public) and Dimension Hierarchies data in real time streaming in either the JSON, XML, HTML or CSV (TXT or Pipe) format via a simple HTTP or HTTPS call. The various data streaming formats have been validated with the visualization tools mentioned, without the need for any additional scripting.
It has a lightweight server based architecture and does not require any software or driver on the client workstation, making it ideal for widespread deployment.
TMVGate returns Cube view (private or public) and Dimension Hierarchies data in real time streaming in either the JSON, XML, HTML or CSV (TXT or Pipe) format via a simple HTTP or HTTPS call. The various data streaming formats have been validated with the visualization tools mentioned, without the need for any additional scripting.
You can watch the demo videos on our Youtube channel here:
Please send us an email if you'd like a free TMVGate trial we'll get back to you in as soon as possible. Most of our clients don't even require half of the free trial time to get their required results.
Email: [email protected] or visit our website at https://www.itlinkbizs.com