Fast ODBC connectivity to NetSuite ERP cloud databases Working with NetSuite objects using SQL syntax Bulk updates Support for NetSuite Field data types and NetSuite API Advanced Connection String parameters support Unicode design Compatibility with third-party analyses tools and IDEs
Cons
None
Devart ODBC Driver for NetSuite
Price: $
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.
Reviewed by Tony Hill (editor rating 4 out of 5 stars)
on
Additional info
Minimum requirements
• Only one ODBC Driver for NetSuite version can be installed on the PC • .NET Framework 4.5