ODBC Driver for NetSuite

Using in Microsoft SQL Server Management Studio (SSMS)


In order to avoid incorrect integration with MS SSMS, the working environment must meet the following conditions:

Retrieving Data From NetSuite

Disable the Allow inprocess option of MSDASQL OLE DB Provider for ODBC Drivers. For this, find the MSDASQL provider in the list of Linked Servers and double-click on it


In the appeared Provider Options window, clear the Allow inprocess checkbox


Create a new Linked Server


Make sure to select Microsoft OLE DB Provider for ODBC Drivers and specify the following parameters


The NetSuite tables are already available to be fetched. To get the Account table data, click on the New Query button at the pivot


Edit the SQL query for your needs


As a result, you can see the contents of the selected table retrieved directly from the NetSuite account you are connected to.


If the Linked Server was created with the Allow inprocess option enabled, then you should delete this Linked Server and create it again with the Allow inprocess option disabled.

See also

© 2016-2019 Devart. All Rights Reserved. Request Support ODBC Forum Provide Feedback