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

Holding all three official certifications, 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 | 20 Comments

17 Comments

  1. Posted September 7, 2012 at 4:29 am | Permalink

    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. Posted September 10, 2012 at 1:51 pm | Permalink

    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. Posted September 10, 2012 at 3:20 pm | Permalink

    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. Posted September 19, 2012 at 6:05 am | Permalink

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

    Rich

  5. jeff drazan
    Posted March 11, 2013 at 12:45 pm | Permalink

    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. Posted March 15, 2013 at 7:35 am | Permalink

    Hi Jeff,

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

    Marty

  7. Mike Murray
    Posted May 2, 2013 at 7:47 am | Permalink

    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. Posted May 6, 2013 at 7:40 am | Permalink

    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/

  9. Abe
    Posted July 23, 2015 at 1:44 pm | Permalink

    I have installed license version of data direct odbc driver and created user DSN. I am trying to connect to Netsuite sandbox through SSIS and read the data to load into my SQL server table?
    Getting the error message The specified DSN contains an architecture mismatch between the driver and application.

    Any help is highly appreciated.

    Thanks
    Abe

  10. Posted July 24, 2015 at 6:32 pm | Permalink

    Hi Abe,

    I suspect you are using or referencing the wrong ODBC driver. Meaning, you may be using the 32 bit driver on a 64 bit workstation. It’s easy to be confused. You may want to reach out to NetSuite Support.

    Marty

  11. Kelvin
    Posted September 9, 2015 at 12:36 pm | Permalink

    Can I use jdbc-odbc bridge connection?

  12. Posted September 10, 2015 at 8:08 am | Permalink

    I haven’t tried it. But a Java application should be fine using it.

  13. Anshul Gupta
    Posted January 26, 2017 at 4:55 pm | Permalink

    Hi Marty,
    We are trying to connect to netsuite using JDBC ODBC driver.
    There are no inherent drivers from netsuite to accomplish this.
    Do you have any suggestions or drivers and how can we achieve this?

  14. Posted February 5, 2017 at 10:59 am | Permalink

    Hi Anshul,

    Are you using NetSuite’s ODBC? From a Windows Perspective, from Java, you can connect to generic ODBC resources. Have you tried that manner?

    Marty

  15. Anshul
    Posted February 5, 2017 at 11:16 am | Permalink

    Hi Marty,
    Thanks for your answer however Netsuite now has a JDBC driver so we can directly consume it in our Java based programs

  16. Scott Bennion
    Posted May 2, 2017 at 3:29 am | Permalink

    Hi Marty
    I’ve exhausted all avenues of support & am hoping you can help? We have tried all manner of ODBC connectors from out of the box suiteconnect, cdata’s RSSbus etc to try to connect Tableau reporting to Netsuite which should be fairly easy in theory. The problem we have is not the connection which, we have done, & looking at the log files the basic queries we are using are served in milliseconds but, tii get the result set back from the servers is taking literally hours & is completely unworkable. Being new to Netsuite, I come from a SAP background where Business Objects & Crystal Reports make this so easy, I have no idea where to start with this & am caught between our Netsuite partner who want to charge us thousands to look at it & Netsuite Account Manager who just wants to refer me back to the Netsuite Partner!! Would you be able to offer any form of advice as to how we can get up & running with this as, I’m struggling to believe that a system with a Customer Base the size of Netsuite’s cannot do the most basic 3 dimensional reporting that any BI/MI tool out there can do 7 feel we must be missing something??

    Any help or guidance appreciated

    Yours exasperated

    Scott.

  17. Posted May 3, 2017 at 4:05 am | Permalink

    Scott,

    When you make simple queries on a small set of data, is the information coming back in a reasonable amount of time? If you query using a key, do you get data back quickly? Ultimately, create NetSuite Support cases to ask for help; they may be able to see what is going on behind the scenes to off guidance.

    Marty

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=""> <s> <strike> <strong>