TM1 to MySQL

[Wim Gielis]

Hello all

I wonder if any of you already connected TM1 and Turbo Integrator to a MySQL database, running on Linux?
Or connected C10 to that kind of database?

I found this useful URL:
http://dev.mysql.com/downloads/mirror.php?id=405997

But I did not test it yet. Can anyone share his/her experience?

Thanks in advance for any feedback,

Wim

[tomok]

I've never connected TM1 and MySQL but I've done a good bit of development with MySQL and find it to be a robust database system. As long as you don't need SSIS then it can do most everything SQL server can. I have also connected to a MySQL instance with that ODBC driver, again with no issues. I see no reason why it wouldn't work fine with TM1.

[Michel Zijlema]

Hello all

I wonder if any of you already connected TM1 and Turbo Integrator to a MySQL database, running on Linux?
Or connected C10 to that kind of database?

I found this useful URL:
http://dev.mysql.com/downloads/mirror.php?id=405997

But I did not test it yet. Can anyone share his/her experience?

Thanks in advance for any feedback,

Wim

Hi Wim,

I have customers where I link from TI to MySQL (read/write) using the ODBC connector without problems. All on Windows though.

Michel

[Wim Gielis]

Hello,

Thank you for the feedback, I will investigate further and report if I encounter anything interesting / unforeseen / ...

Have a nice day,

Wim

[asutcliffe]

Hi Wim,

For what it's worth, I gave this a try using CX (The TM1 bit) and encountered no problems. I only pulled data from a system table rather than any serious testing though. Of course ODBC should just work irrespective of things like the underlying OS of either client or server.

I found this useful URL:
http://dev.mysql.com/downloads/mirror.php?id=405997

Note, this links to the Linux driver. I assumed (perhaps incorrectly) that you were running MySQL on Linux and needed to connect from a TM1 server running windows of some sort in which case you'd want the appropriate windows driver.

[Wim Gielis]

Hello asutcliffe and others,

Thank you for testing. A colleague of mine set it all up yesterday.
Turns out that Turbo Integrator had no problem at all to connect to the MySQL on Linux.

Wim