Page 1 of 1
Greenplum
Posted: Thu Oct 25, 2012 3:53 pm
by mbeckw
Has anyone connected to Greenplum through ODBC? I am going to try and get some data out of Greenplum and I would like to know where to get an ODBC connection . I am on TM110.1fp1 using Excel 2010.
Thank you
Re: Greenplum
Posted: Thu Oct 25, 2012 4:01 pm
by qml
I believe any PostgreSQL ODBC driver should work, but I have not tried this setup personally. Be sure to get the right version for your TM1 and OS (32 or 64 bit).
Re: Greenplum
Posted: Thu Oct 25, 2012 4:03 pm
by jim wood
This is a question for Green Plum. TM1 doesn't care about the ODBC connection type as long as the driver and connection exists on the server. It's the same as Oracle I'm guessing: install the odbc driver and then make a connection. Also keep in mind that TM1 doesn't care about the SQL used either. ODBC connections are all about the database,
Jim.
Re: Greenplum
Posted: Mon Oct 29, 2012 3:19 pm
by mbeckw
Thanks for the help. I will give it a try.