Re: PostgreSQL drivers support for Accessing HAWQ Data.

Hi Adrian Klaver,

I don't have clarity exactly on HAWQ, you should know since its Pivotal product.
We have our data located in HAWQ, some of our users want to pull the tables from HAWQ into SAS.
SAS does not have its HAWQ drivers to pull data from HAWQ into SAS,
I heard Pivotal HAWQ supports drivers Green plum and PostgreSQL drivers to pull the data.
I have already tested the Greenplum ODBC drivers, and I was able to pull data from HAWQ into SAS.
But while testing I have used EVAL the evaluation copy when it asked Serial Number and key fields.
By any chance can I get the serial number and key fields for the licensed copy for Green plum drivers.
And also can you tell me whether Pivotal HAWQ ODBC drivers supports to pull data from HAWQ into SAS.

-----Original Message-----
From: Adrian Klaver [mailto:adrian(dot)klaver(at)aklaver(dot)com]
Sent: Monday, April 06, 2015 3:29 PM
To: Pasupunooti, Kiran Kumar (GE, Appl & Light, consultant); pgsql-odbc(at)postgresql(dot)org
Subject: Re: [ODBC] PostgreSQL drivers support for Accessing HAWQ Data.

On 04/02/2015 07:46 AM, Pasupunooti, Kiran Kumar (GE, Appl & Light,
consultant) wrote:
> Hello,
>
> Am trying to access Data located in HAWQ into SAS 9.2 on Solaris 10
> environment.
>
> Does these drivers support to get the data from HAWQ into SAS.

I know what SAS is, I am not sure I fully understand what HAWQ is?

I starting with the assumption you are talking about this:

http://pivotal.io/big-data/white-paper/a-true-sql-engine-for-hadoop-pivotal-hd-hawq

From a quick read it seems to interface with Hadoop. I see references to Greenplum, but am not sure how they apply. I think we will need a more detailed explanation of what you are doing, in particular where Postgres fits into this.

>
> Please advice
>
> I have installed the drivers from below link
>
> http://www.postgresql.org/ftp/odbc/versions/src/
>
> Thank you
>
> Kiran
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com