what is the steps to connect COGNOS TM1 to POWER BI desktop by using ODBC !!

[anjanikumar]

1Q   what is the steps to connect COGNOS TM1 to POWER BI desktop by using ODBC !!

        could you please explain clearly anyone asap.

2Q    which way is the best way to get the reports from cognos TM1 to power bi?

         ODBC or TM1py

         is these(ODBC or TM1py) convert multidimensional model to realtional databse ?

[algie-buca]

Hi!

You can give TMVGate a go! TMVGate is a TM1 data connector developed by ITLink which offers a swift, accurate, and independent way to transfer data from IBM Planning Analytics to your chosen BI tools. It integrates seamlessly with TM1 On-Prem or on Cloud, and with its flexible licensing options and a setup process that takes just 15 minutes, TMVGate is a cost-effective, efficient, and trusted solution for all your data management needs.

This innovative solution has already proven its value to our global customer base, spanning from Australia to the UK, impressing them with its ease of implementation and out-of-the-box functionality. 

To witness TMVGate in action, check out our demonstration video on YouTube: https://www.youtube.com/watch?v=LpK4TLz1fGE 

Visit our comprehensive YouTube Channel: https://youtube.com/@itlinksupport1657 

For more insights into TMVGate, feel free to reach us at: info@itlink.com.sg

Ready to take the first step? Visit our website at https://www.tmvgate.com/ for more information and unlock the true potential of your data with TMVGate.

[anjanikumar]

Hi @Anonymous 

if we will connect by using ODBC which will import only Data? not report. Give me Clarity.

Do we have any other way to connect with TM1 from Power Bi desktop ?

Directly i want reports  from TM1 to Power BI. do we have any other open source option? Please help me asap.

[Anonymous]

Hi @anjanikumar ,

ODBC is often used to connect to database, and according to your question, I know you want to realize this function.

So for your question , you should learn how we can connect to database with ODBC. Firstly, you can create a ODBC connection for Cognos TM1 database. You can refer to this document : Administer ODBC data sources (microsoft.com)

Then connect to the ODBC data source in Power BI Desktop. This docs shows you detailed process: Power Query ODBC connector - Power Query | Microsoft Docs

For your second question, you can able to use ODBC connector or web connector in Power BI Desktop to connect to Cognos TM1 database. For ODBC ,it is a protocol that you can use to connect a Microsoft Access database to an external data source, so that you can create report in power bi desktop with these data,  it can’t  get report directly. For TM1py, what type of connector is this? Is it a custom connector? Could you please briefly introduce it to me?

Best regards,

Community Support Team Selina zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[anjanikumar]

Hi @Anonymous 

if we will connect by using ODBC which will import only Data? not report. Give me Clarity.

Do we have any other way to connect with TM1 from Power Bi desktop ?

Directly i want reports  from TM1 to Power BI. do we have any other open source option? Please help me asap.

[Anonymous · Accepted solution]

Hi @anjanikumar ,

Yes, if you connect using ODBC, it will only import data. In fact, no matter what data source, power bi desktop provides the function to connect to its data and get the data model (that is, the relationship between table), it can't do to import the reports you have successfully created , and in power bi desktop, you can recreate new reports based on the connected data.

So if you want to realize import report ,may be power bi can't support.

Best regards,

Community Support Team Selina zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly