SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

Getting Data into SAS 9.2 from Pivotal(HAWQ)

Reply
Frequent Contributor
Posts: 148

Getting Data into SAS 9.2 from Pivotal(HAWQ)

Hi all,

Please can anyone help me how to get data which is located in Pivotal(HAWQ) into SAS.

am using SAS 9.2 on solaris 5.10.

please give me step by step process to get data using SAS/ACCESS Interface to ODBC.

am completely new to this i dont know how to do this

I would really appreciate for all your help.

Thank you

Super User
Posts: 5,260

Re: Getting Data into SAS 9.2 from Pivotal(HAWQ)

SAS Employee
Posts: 203

Re: Getting Data into SAS 9.2 from Pivotal(HAWQ)

Hi,

This paper may help you. The actual link is on the right-hand side of the page.

An Insider's Guide to SAS/ACCESS® Interface to ODBC

Best wishes,

Jeff

Frequent Contributor
Posts: 148

Re: Getting Data into SAS 9.2 from Pivotal(HAWQ)

Hi,

Am trying to get data located in HAWQ into SAS using PostgreSQL driver.

I found PostgreSQL drivers at below which is open source driver.

https://odbc.postgresql.org/

but am not sure whether these drivers support with my current environment SAS 9.2 on Unix(Solaris 5.10) Sparc or not.


If it supports can you tell whether it comes with both the driver manager and PostgreSQL drivers and also Which download I need to go is it binary or source code from the below link provided.

http://www.postgresql.org/ftp/odbc/versions/


When am clicking on Source-->v9.4.1

below are the drivers am getting to download, but not sure which once to select


Files
postgresql-9.4.1.tar.bz2 Feb. 2, 2015, 8:53 p.m. 16.7 MB
postgresql-9.4.1.tar.bz2.md5 Feb. 2, 2015, 8:53 p.m. 59 bytes
postgresql-9.4.1.tar.bz2.sha256 Feb. 2, 2015, 8:53 p.m. 91 bytes
postgresql-9.4.1.tar.gz Feb. 2, 2015, 8:53 p.m. 21.9 MB
postgresql-9.4.1.tar.gz.md5 Feb. 2, 2015, 8:53 p.m. 58 bytes
postgresql-9.4.1.tar.gz.sha256 Feb. 2, 2015, 8:53 p.m. 90 bytes


When am clicking on Binary-->Solaris-->File browser-->v9.4.1-->Solaris-->solaris10-->sparc

below are the files am getting to download, but not sure which once to select

Files
README Feb. 4, 2015, 10:12 p.m. 1.5 KB
postgresql-9.4.1-S10.sparc-32.tar.bz2 Feb. 4, 2015, 10:12 p.m. 11.5 MB
postgresql-9.4.1-S10.sparc-32.tar.bz2.md5 Feb. 4, 2015, 10:12 p.m. 77 bytes
postgresql-9.4.1-S10.sparc-64.tar.bz2 Feb. 4, 2015, 10:12 p.m. 12.0 MB
postgresql-9.4.1-S10.sparc-64.tar.bz2.md5 Feb. 4, 2015, 10:12 p.m. 77 bytes

Please help me with the exact drivers and necessary steps to download and install drivers in my environment.

I would really appreciate if you can please guide me with the steps.


Thank you


SAS Employee
Posts: 203

Re: Getting Data into SAS 9.2 from Pivotal(HAWQ)

Hi,

I don't think a PostgreSQL driver will work. When I was the product manager of SAS/ACCESS I would certainly say that it is supported. I am not sure what they would say today, but I imagine it would be the same answer.

In order to access data via the HAWQ SQL engine you need to use either a Greenplum ODBC driver or a Pivotal HAWQ ODBC driver.

Greenplum drivers will not support UPDATES, DELETES, or stored procedures. This is because HAWQ doesn't support tem.

If the underlying data is stored in something SAS can read, you may be able to use PROC HADOOP and copy the file to your Solaris machine and read it there. There is also a chance you can read it with the Hadoop FILENAME statement.

Best wishes,

Jeff

Ask a Question
Discussion stats
  • 4 replies
  • 594 views
  • 0 likes
  • 3 in conversation