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
Greenplum
-
qml
- MVP
- Posts: 1096
- Joined: Mon Feb 01, 2010 1:01 pm
- OLAP Product: TM1 / Planning Analytics
- Version: 2.0.9 and all previous
- Excel Version: 2007 - 2016
- Location: London, UK, Europe
Re: Greenplum
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).
Kamil Arendt
-
jim wood
- Site Admin
- Posts: 3958
- Joined: Wed May 14, 2008 1:51 pm
- OLAP Product: TM1
- Version: PA 2.0.7
- Excel Version: Office 365
- Location: 37 East 18th Street New York
- Contact:
Re: Greenplum
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.
Jim.
Struggling through the quagmire of life to reach the other side of who knows where.
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7