cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper II
Helper II

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 SQL DB and connecting PBI that way, i want to go direct from the IBM environment to PBI.

Any help is appreciated!

Thanks

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Microsoft
Microsoft

Re: Connect to IBM Cognos/TM1/Planning Analytics

@BenActionKPI,

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/...

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

6 REPLIES 6
Highlighted
Microsoft
Microsoft

Re: Connect to IBM Cognos/TM1/Planning Analytics

@BenActionKPI,

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/...

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Highlighted
New Member

Re: Connect to IBM Cognos/TM1/Planning Analytics

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.
 
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: info@itlinkbiz.com or visit our website at https://www.itlinkbizs.com
Highlighted
Kudo Commander
Kudo Commander

Re: Connect to IBM Cognos/TM1/Planning Analytics

Hi Ben,

 

As an alternative you could consider https://www.acterys.com a solution that we have developed as a "TM1 for SQL Server". It offers similar modelling, write-back / planning features with the advantage that all data is stored in a single SQL database (cloud or on premise)

 

Martin

Highlighted
New Member

Re: Connect to IBM Cognos/TM1/Planning Analytics

Introducing DataFusion

 

Based on open-source web-technologies, Octane's DataFusion bridges the integration voids between IBM Planning Analytics and various Analytics & Business Intelligence platforms like Microsoft Power BI, Qlik and Tableau.

 

All connections formed through DataFusion are web-based and integrate entirely without the need of a centralised database. The user-interface and navigation, built keeping in mind a user friendly design and dynamic page layout, makes working with DataFusion fast and easy.

 

DataFusion blends into your business applications environment using existing views with native IBM Planning Analytics security. It can also be customised to dynamically create views and get data that you are looking for. DataFusion is attuned to address your specific business needs and can be augmented further using industry standard tools and APIs. All you need do is let Octane know and we'll get right to them.

 

DataFusion helps you deliver a true version of the truth across your enterprise ""real-time"", thereby accelerating business decision making and enhancing performance.

 

http://www.octanesolutions.com.au/datafusion/

Highlighted
Anonymous
Not applicable

Re: Connect to IBM Cognos/TM1/Planning Analytics

Hi @BenActionKPI  were you able to implement any thing?

Highlighted
Frequent Visitor

TYRe: Connect to IBM Cognos/TM1/Planning Analytics

Hi All,

 

There is now an TM1 Custom Data Connector which you can use in Power BI to access Views and execute raw MDX. 

 

Its available from https://micatio.com/products-and-services/tm1-power-bi-custom-connector/

 

Kind Regards,

Ron

 

Helpful resources

Announcements
Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Top Solution Authors
Top Kudoed Authors