Setting Up ODBC Connector for Windows in 7 Easy Steps!

Prerequisites:

  • Active SuiteAnalytics Connect Cloud Service license from NetSuite
  • SuiteAnalytics Connect setting enabled

Check Windows Settings  

1. Check your windows version, either 32 or 64 bit. Start > Settings > System > About > System Type

  • If you have a 64 bit PC & 64 bit Microsoft Excel, it is advised to download 64 bit driver. If you only have 32 bit Excel or 32 bit processor, you will need to download the 32 bit ODBC driver. – check with your IT administrator

NetSuite ODBC Download

2. From NetSuite home page, navigate to settings > Set Up SuiteAnalytics Connect

2.1 If you do not have the settings portlet, follow the below steps.

  • This will add the settings portlet to your home page. Click Personalize then Settings.

3. Download the correct bundle or driver to your desktop. Either 32 or 64 bit.

Installing the ODBC Driver – May need IT resource to install depending on IT policy for installing software

4. Configure ODBC connector – Search your windows programs for ODBC, and open the program. – you’ll see a 32- or 64-bit option

5. Navigate to System DSN tab, > then Add > then Finish

6. Enter the below information – check with your administrator for static Account & Role ID values

  • Name > NetSuite
  • Description – Data Feed
  • Account ID – will be a static value – Check with your administrator
  • Role ID – will be a static value – Check with your administrator
  • Service Host – accountID.connect.api.netsuite.com
  • Service Port – 1708
  • Click Test Connection

7. Test Connection:

  • Enter Username, Password, Account ID & Role ID

→ Click Ok and save, setup is complete!

Learn More

Contact Us and let’s make NetSuite easier today!