"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.
... View more