Reading data from TM1

[elugan]

Hi,
We are planning a dashboard in Tableau and the source would be TM1. Question is how to get it.
I have few thoughts:
a. Connect to TM1 and read data using Tableau: Not sure how to connect Tableau to TM1. Are there any ODBC drivers for the same.
b. Connect to TM1 and read data using ETL tool like Informatica and dump into some staging tables in some Database and read it using tableau : Not sure how to connect. Are there any ODBC drivers in place.
c. Push data from TM1 to any of the data base and read from there: I am sure of this approach will work, as we have some existing tables which get loaded using TM1.

I am new to Tableau/TM1 and like to know from experts if above mentioned once are feasible options or not.

Reply will be appreciated.

Thanks!

[chonlanotr]

Hi
I use SSRS with OLE DB driver for TM1 but u need to create MDX manual because query designer doesn't work for TM1 data sources. Good luck

[lotsaram]

The folks at Tableau currently support SSAS and Essbase but not TM1 which is something that I really hope changes soon as I see a lot of potential in Tableau as they "get" data presentation, visualisation and exploration in a way that the established BI vendors truly don't.

I think the best option at this point in time is to export into SQLServer and then link Tableau to that. That's what I would do in your position.

[elugan]

Thanks a lot for your replies. Appreciated!

I will go with 3rd approach.

[Plunge pool]

Hi There elugan or Anyone else.

I have this exact same problem, and I was wondering how you did this.

What database are you using? How did you push the data there?

I am a newbie for both TM1 and Tableau, so please bare with me.....

Thanks!

[Martin Ryan]

Hi Plunge pool,

The database is largely irrelevant - Oracle, SQL, MySQL, whatever, there are two approaches for getting data out from TM1 to a relational database (or into TM1 from a database, for that matter).

ODBC - if you can setup an ODBC connection to the database then you can write a TI process to output the data directly into database tables. I.e. TM1 pushes the data into the database. Search the help for "ODBCOpen" and go from there.

Flat files - you can use asciioutput to export the data from TM1 (again using TI) to a csv file, then write import routines in the database to load the data up.

Personally I prefer the second approach because I tend to think that whatever system is receiving the data should be in control of the receiving.

HTH