NetSuite ODBC Driver provides fast ODBC connectivity to NetSuite ERP cloud databases. It can be used from your own ODBC-based applications (32 and 64 bit).
After a successful installation, driver can be configured from the ODBC Data Source Administrator (Control Panel > Administrative Tools), where you can add a new data source that uses this driver for a connection. Connection is made via HTTPS protocol, and if connection via HTTPS is not possible, there is also a possibility to connect via proxy server.
Driver provides the ability to work with NetSuite objects, just like with SQL tables, supporting JOIN, WHERE and other SQL operators. In addition, there is also support for using SQL statements to add, update and delete data from NetSuite. For updating larger quantities of data, you can use bulk updates, where you can combine multiple SQL statements, and in this way speed up the update process.
It is also worth mentioning that NetSuite Field data types are supported, and NetSuite API as well. And, because of its Advanced Connection String parameters support, there is also a possibility to connect to NetSuite database from different platforms and environments.
Because of the drivers Unicode design, it is possible to work with multi-lingual NetSuite databases. Driver also provides compatibility with different third-party analyses tools and IDEs, such as Microsoft Excel, Microsoft Visual Studio, Open Office, Delphi & C++Builder, Crystal Reports and others.
