RE: ODBC driver for NetSuite
SuiteAnalytics Connect is the feature we use for this purpose.
The SuiteAnalytics Connect Service lets you archive, analyze, and report on NetSuite data. You can use a third-party tool or a custom-built application on any device that uses Windows, Linux, or OS X operating system. If your company enables the Connect Service, NetSuite offers ODBC, JDBC, and ADO.NET drivers that you can download, install, and use for the Connect Service.
The SuiteAnalytics Connect Service provides a read-only method for obtaining NetSuite data. You cannot use the Connect Service to update NetSuite data.