NetSuite 64-bit ODBC Setup Instructions

In my article NetSuite Delivers on ODBC, discussions have helped a number of NetSuite Administrators get ODBC connected. Yet, with Windows 7 (and possibly Windows Eight) growing in popularity including 64 bit machine architectures, the setup is more complicated.  Normally, you need to go to NetSuite Support to get the instructions.  I am including them here because at the time of this writing, it is not clear how to perform the setup from their instructions.

Download DataDirect 64bit Drivers

The NetSuite ODBC driver leverages the DataDirect ODBC driver set.  Download the 7.0 drivers here and install them on the target 64 bit machine.

Add NetSuite License File

NetSuite will provide you with a oaodbc64.lic file that will replace the evaluation version located at the Program Files > DataDirect > oaodbc700 file directory.  Given this license file is proprietary, I will not post it here.  However, contact me and I can provide you the license file.

Configure the ODBC Configuration

Here is where it gets a little tricky.  You will need to define an ODBC connection manually.  Here is what you need to do.

  1. Run %windir%\system32\odbcad32.exe to start the Windows Data Sources (ODBC) manager.
  2. Select a User DSN or System DSN and then click Add.  You should be presented with a dialog  as illustrated.  Select the DataDirect driver.
  3. Include the following information parameters. The key components are the Service Host (varies if you are trying to get to the Production or Sandbox environments), the Service Port (1708) and the Service Data Source (“Netsuite.com”).   See dialog.
  4. Select the Security tab and turn on Encrypted SSL. See dialog.
  5. Finally, Test Connect and you should be prompted for a user name and password.

Related Articles

  1. Resolving ODBC 64 bit Driver References
  2. SQL Reporting on NetSuite Data Step-By-Step
  3. Connecting ODBC to Multiple NetSuite Accounts
  4. NetSuite ODBC: “You Don’t Have Permission to Use ODBC.”
  5. Extract NetSuite Data for Backup and Reporting
  6. Warning: SQL Server Linked Server to NetSuite Issues
  7. Considering Producing NetSuite Financial Statements using Third Party Tools?
Be Sociable, Share!

Marty Zigman

Marty is Southern California's NetSuite expert and leads a team of senior professionals at Prolecto Resources, Inc. He is a former Deloitte & Touche CPA and has held CTO roles. For over 25 years, Marty has produced leadership in ERP, CRM and eCommerce business systems. Contact Marty to setup a conversation.

More Posts - Website - Twitter - Facebook - LinkedIn - Google Plus - YouTube

| Tags: , , , , | Category: NetSuite, Reporting, Technical | 11 Comments

8 Comments

  1. Rich Vacacro says:

    Hi Marty:
    We deploy a complete virtualized business (VM) application for inventory planning. It includes the OS which is Linux. I noticed these instruction are for Windows, do you know if there is an Linux driver for the Oracle connection?

  2. Marty Zigman Marty Zigman says:

    Hi Rich,

    That is a great question. It looks like DataDirect offers a Linux driver. See this link:

    http://www.datadirect.com/products/odbc/unix-linux.html

    I suspect it will work. Yet the one challenge may be that NetSuite License File if it is not cross-platform. Do let me know how it goes.

    Marty

  3. Marty Zigman Marty Zigman says:

    One other consideration when working with the NetSuite 64-Bit driver. It requires that you work with the MS Office 64-Bit version. You can not use MS Office 32-Bit against the NetSuite 64 Bit ODBC Driver. You will get a “The Specified DSN contains an architecture mismatch between the Driver and Application” error message.

  4. Rich Vacacro says:

    Thnaks Marty for the resposne. We’ll take a look and let you know.

    Rich

  5. jeff drazan says:

    Hi Marty

    I am looking to hire a strong programmer to do ODBC extracts from Netsuite.

    Either a very strong consultant or someone who is looking for a career beyond just writing drivers.

    I have full time and 6-12 month contract work available.

  6. Marty Zigman Marty Zigman says:

    Hi Jeff,

    We can help. Let’s setup a conversation. I sent you a direct email.

    Marty

  7. Mike Murray says:

    Is getting data out of NetSuite – the so called “who owns the data” issue still relevant these days?

    We are considering implementating NetSuite but are concerned that we could be locking ourselves into a long-term commitment even though the contract would only be 3 years.

  8. Marty Zigman Marty Zigman says:

    Hi Mike,

    I think this may be off topic. Have you seen this article however that addresses your concern?

    http://blog.prolecto.com/2011/09/08/misconception-1-about-netsuite-cant-get-off-the-system/

3 Trackbacks

  1. [...] NetSuite 64-bit ODBC Setup Instructions Yet, most of the accounts we work with our development in nature and this is where we tripped up.    The good news is we started to work with Simon Miles at Solution 7 in the UK.  He has a wicked Excel based Financial Reporting add-in (we’ll write about it shortly) and he clued us into the recent service host changes. [...]

  2. [...] operating system.  The natural inclination is to want to use a 64 bit ODBC driver.  I offer the 64 bit NetSuite license key with instructions here for the driver.  However, I believe many do not need [...]

Post a Comment

Your email is never published nor shared. Required fields are marked *

*
*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

*