The 'AccountID' connection property serves as the distinguishing factor between NetSuite production accounts and sandbox accounts.
“AccountID”, indicates the company account your username is associated with on NetSuite.
Note: You can find your NetSuite account ID at the beginning of the NetSuite URL. For example, if the URL is https://1234567.app.netsuite.com/, your account ID is 1234567.
Sandbox account IDs are always the same as production account IDs, with ‘_SB1’, ‘_SB2’, ‘_SB3’, and so forth, added to the end:
Production Account Id | 345678 |
Sandbox Account Id (1) | 345678_SB1 |
Sandbox Account Id (2) | 345678_SB2 |
Sandbox Account Id (3) | 345678_SB3 |
When connecting to NetSuite sandbox account, make sure to configure the appropriate account ID "AccountID={productionAccountId}_SB1".
For additional details on how to establish a connection to NetSuite, please consult our driver's documentation using the following link: https://cdn.cdata.com/help/DNJ/odbc/pg_startedintroo.htm
Please reach out to [email protected] if you have any questions.