BookmarkSubscribeRSS Feed
sasprofile
Quartz | Level 8

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

4 REPLIES 4
JBailey
Barite | Level 11

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

sasprofile
Quartz | Level 8

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


JBailey
Barite | Level 11

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

sas-innovate-2024.png

Available on demand!

Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.

 

Register now!

How to connect to databases in SAS Viya

Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 4 replies
  • 1272 views
  • 0 likes
  • 3 in conversation