topic Database Access in SAS Programming

Database Access

sg_kr — Tue, 28 May 2019 11:14:20 GMT

Hi ,

when im trying to access the Netezza database from base SAS, im getting the below error.

its clear that, Netezza drivers are missing.

but anyone let me know how can i install the drivers and connect the database

thanks in advance!!

Re: Database Access

Amir — Tue, 28 May 2019 11:05:22 GMT

Do any of the following apply to / help your situation:

http://support.sas.com/kb/20/650.html

http://support.sas.com/kb/34/207.html

http://support.sas.com/kb/35/799.html

If not, then please provide further information, such as:

What SAS product are you using (for example, Base SAS, SAS EG, etc.)?
What version of the product do you have licensed?
What platform is the product running on?
Have you successfully done this before?
Can any of your colleagues successfully connect?
What does the log show when you run proc setinit; run;?
Is there any other information you can supply that might help?

Amir.

Re: Database Access

sg_kr — Tue, 28 May 2019 11:29:49 GMT

What SAS product are you using (for example, Base SAS, SAS EG, etc.)?
sas 9.4 TS1 Level M4

What version of the product do you have licensed?
base SAS foundation

What platform is the product running on?
windows 7 pro-64

Have you successfully done this before?
no

Can any of your colleagues successfully connect?
no

What does the log show when you run proc setinit; run;?
76 proc setinit; run;

NOTE: PROCEDURE SETINIT used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds

Original site validation data
Site name: 'AXA EQUITABLE LIFE INSURANCE CO'.
Site number: 70165964.
Expiration: 29APR2019.
Grace Period: 45 days (ending 13JUN2019).
Warning Period: 45 days (ending 28JUL2019).
System birthday: 04JUL2018.
Operating System: WX64_WKS.
Product expiration dates:
---Base SAS Software
29APR2019
---SAS/STAT
29APR2019
---SAS/GRAPH
29APR2019
---SAS/ETS
29APR2019
---SAS/CONNECT
29APR2019
---SAS/Secure 168-bit
29APR2019
---SAS/Secure Windows
29APR2019
---SAS Enterprise Guide
29APR2019
---SAS/ACCESS Interface to Oracle
29APR2019
---SAS/ACCESS Interface to PC Files
29APR2019
---SAS Workspace Server for Local Access
29APR2019
---High Performance Suite
29APR2019

Is there any other information you can supply that might help?

earler im accesing the same netezza through SAS which is installed in server by remote.
now,i installed this on local machine and while trying to access the netezza i facing this.

Re: Database Access

Amir — Tue, 28 May 2019 11:51:06 GMT

Did you check any of the links that I sent, especially the first one, as it might provide a quick win?

Otherwise, I advise you check and try the following:

http://support.sas.com/kb/21/047.html

Amir.

Re: Database Access

Kurt_Bremser — Tue, 28 May 2019 12:04:02 GMT

You do not have a license for SAS/ACCESS to Netezza. Ask the people responsible for SAS administration in your company to get you the license.

Re: Database Access

sg_kr — Tue, 28 May 2019 12:09:45 GMT

do we need to buy license seperately?

Re: Database Access

Kurt_Bremser — Tue, 28 May 2019 12:35:20 GMT

@sg_kr wrote:

do we need to buy license seperately?

Yes. It is a separate module (like SAS/ACCESS to Oracle), and not included in any other.

Re: Database Access

Tom — Tue, 28 May 2019 13:40:43 GMT

Either add SAS/Access to Netezza to your local machine or since you have SAS/Connect licenses make a connection to the remote server that does have it licensed and submit the code to access the database in the remote session.