Connection to Netsuite how to use connection string

1

I want to connect to Netsuite but the ODBC connection does not work properly.

AI suggest to use a connection string. How can I do that?

For NetSuite ODBC, a DSN-less connection string is the most reliable, portable, and transparent method for TBA. You input this string directly into the application (like Power BI, Tableau, SQL Server Linked Server, etc.) instead of creating a DSN in the ODBC Administrator.

This completely bypasses the limitations of the DSN configuration wizard.

DSN-less Connection String Template

The key is to include all the NetSuite-specific parameters, including the four TBA keys, separated by semicolons:

DRIVER={NetSuite ODBC Drivers 64bit};
Host=<Service Host>;
Port=1708;
Encrypted=1;
ServerDataSource=NetSuite2.com;
AccountID=<Your Account ID>;
RoleID=<Your Role ID>;
ConsumerKey=<Your Consumer Key>;
ConsumerSecret=<Your Consumer Secret>;
TokenID=<Your Token ID>;
TokenSecret=<Your Token Secret>;
2

EasyMorph doesn't support DSN-less ODBC connections, but you can try to:

  • Create a DSN with the required driver and specify as few options as possible.
  • Create an ODBC connector in EasyMorph.
  • In the created connector, choose the created DSN and set Authorization to "Credentials from ODBC DSN"
  • Add all parameters, listed above, to the created connector as Custom properties.