Difference between ODBC and Netezza engine

0
votes

I am loading SAS tables into Netezza and I am using a libname with the ODBC connection to connect to netezza like this:

libname myConnection odbc noprompt="server=xxxx; DRIVER={NetezzaSQL}; port=xxxx;database=xxxx; username=xxxx;password=xxxx;";

I do it with SAS/Access Interface to ODBC because I do not have SAS/Access Interface to Netezza.

Are there any disadvantages of using ODBC engine over the Netezza engine?

1
sasodbcnetezza
this is for oracle but will make sense for netezza too. support.sas.com/kb/31/648.html. there might be slight differences about which I will not be too oncerned – Kiran
@Kiran it states the types of things you can do such as using the bulkload option, but this option already exists with SAS/ACCESS interface to ODBC – jim
it is just as example, but i mean to say there may be minor differences about which you may not be too worried – Kiran
@Kiran in this article: ibmbigdatahub.com/blog/… where he talks about ODBC it states why SAS/ACCESS to Netezza would be best. Technically all I want to do is load data into Netezza. So would Netezza engine instead of ODBC cause for better performance in loading big data? – jim

1 Answers

1
votes

it depends. see the below link for the paper on SAS connections in relation to netezza sas.com/partners/directory/ibm/NetezzaDWAppliances-withSAS.pdf

In this paper, it describes SAS/Access for ODBC is also available, but provides lower performance as it does not ‘push down’ as much of the SAS code or PROC SQL as SQL to Netezza. SAS/Access for ODBC does not support SAS 9.3 in-database processing.

when you are writing an implicit pass through or a datastep the code is not sent to database for processing in 9.3 and about 9.4 i do not have idea.

So performance will be impacted when you are using implicit pass through and looking for in-database processing

If you are just moving your data from SAS to Netezza, impact may not be significant but I have not tested both of them separately so I cannot tell for sure