topic Re: We have both SAS/Access interface to Netezza and SAS/Access interface to ODBC. I would like to k in Administration and Deployment

SAS/Access to Netezza and SAS/Access to ODBC - are both necessary?

Amar_athuri — Fri, 09 Nov 2018 20:30:13 GMT

We have both SAS/Access interface to Netezza and SAS/Access interface to ODBC licences in our organization.

I would like to know whether we really need both the licences to connect to Netezza database ?

Is it possible to connect to Netezza through SAS/Access to ODBC interface without SAS/Access interface to Netezza licence ?

If yes, does ODBC interface provide all the functionality as such SAS/Access interface to Netezza do ?

Thanks.

Amar

Re: We have both SAS/Access interface to Netezza and SAS/Access interface to ODBC. I would like to k

SASwork — Wed, 02 Mar 2016 20:44:10 GMT

"Is it possible to connect to Netezza without SAS/Access interface to Netezza ? " Yes, we used to do that.

"If yes, does ODBC interface provide all the functionality as such SAS/Access interface to Netezza do ?" Not in 9.4 M2, you cannot do any of the in database processing procedures and you cannot update the metadata using SMC. It locks SMC and you to kill SMC. In order to update the metadata for a table you have to delete it and re-register the table. Obviously, not what you want to do.

Re: We have both SAS/Access interface to Netezza and SAS/Access interface to ODBC. I would like to k

LinusH — Wed, 02 Mar 2016 21:45:46 GMT

The last statement sounds like a problem that SAS tech support should be involved. That is something that naturally should work.

Re: We have both SAS/Access interface to Netezza and SAS/Access interface to ODBC. I would like to k

SASwork — Wed, 02 Mar 2016 22:24:14 GMT

LinusH,

Contacting SAS tech support is how I got to switching to the interface, still have to upgrade to M3 to elminate a different error message that occures in E.G. when using the data for reports. The error doesn't stop the process just pops into the log.

Re: We have both SAS/Access interface to Netezza and SAS/Access interface to ODBC. I would like to k

jim_toby — Fri, 09 Nov 2018 15:27:05 GMT

@SASwork I have SAS 9.4.01 M3. Would the ODBC interface provide all of the functionality that SAS/Access interface to Netezza would?

Re: We have both SAS/Access interface to Netezza and SAS/Access interface to ODBC. I would like to k

LinusH — Fri, 09 Nov 2018 20:12:30 GMT

Of course it won't. Otherwise there shouldn't be a need for a separate module.
Check the documentation and compare. Decide what features that are important to you and decide accordingly.