Tips & Tricks

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

12 SAC

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.

19 Per

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

14 Bundles

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

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

16 NDS

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

17 ODBC Config

7. Test Connection:

  • Enter Username, Password, Account ID & Role ID

18 test

→ Click Ok and save, setup is complete!

 

Learn More