Re: PostgreSQL drivers support for Accessing HAWQ Data.

On 04/06/2015 12:44 PM, Pasupunooti, Kiran Kumar (GE, Appl & Light,
consultant) wrote:
> 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.

Not without paying for, I am sure.

According to here you should be able to use the standard ODBC drivers:

http://hawq.docs.pivotal.io/docs-gpdb/admin_guide/access_db/topics/g-supported-client-applications.html

using these parameters:

http://hawq.docs.pivotal.io/docs-gpdb/admin_guide/access_db/topics/g-establishing-a-database-session.html

In fact you are supposed to be able to connect using psql, so I would
try that first as a test.

> And also can you tell me whether Pivotal HAWQ ODBC drivers supports to pull data from HAWQ into SAS.

Pivotal says yes:

http://hawq.docs.pivotal.io/docs-gpdb/admin_guide/access_db/topics/g-third-party-client-tools.html#topic13

>
>
>
> -----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
>

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