02-11-2015 08:21 PM
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.
03-30-2015 04:38 PM
Am trying to get data located in HAWQ into SAS using PostgreSQL driver.
I found PostgreSQL drivers at below which is open source driver.
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.
When am clicking on Source-->v9.4.1
below are the drivers am getting to download, but not sure which once to select
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
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.
03-30-2015 04:53 PM
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.