NetSuite Delivers on ODBC

NetSuite provides a read-only ODBC driver (common way to access a databases) to connect to its platform.  We are interested in this because we offer Secure Remote SQL Reporting Services which closes the gap for businesses that wish to fully leverage Cloud Computing but have discovered that NetSuite’s built-in report tools are not quite good enough.

Setup of the NetSuite ODBC Driver requires the following:

  1. Module Add-on Package purchased from NetSuite.
  2. Get the ODBC driver installed on client machines.  The ODBC Driver is available for download on the NetSuite Settings Dashboard. In our case, we configured this with our Remote SQL Reporting services integrated with Windows SharePoint Services.  For the purposes of this discussion, we will use Microsoft Access to illustrate connectivity.  The driver is available for download from the NetSuite dashboard Setting Portlet.
  3. Download and Install OpenSSL offered from Shining Light Productions.  Additional C++ distributables may be required.    These are clearly referenced on the site.  Be sure to donate to help further the cause to keep software costs low.
  4. Configure the Windows ODBC Driver.
  5. Provide your NetSuite user name and password.
  6. Link to interested tables and provide reference to the respective primary key(s).  Use the NetSuite “Table of ODBC Views” guide for reference within the Help system.
  7. Optionally, setup relationships to let the tools help you during the development of your queries.
  8. Retrieve data into your application.

Related Articles

  1. SQL Reporting on NetSuite Data Step-By-Step
  2. Connecting ODBC to Multiple NetSuite Accounts
  3. NetSuite ODBC: “You Don’t Have Permission to Use ODBC.”
  4. NetSuite 64-bit ODBC Setup Instructions
  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?
If you need help working with ODBC on NetSuite to drive enhanced reporting, contact us.

Screen Shots

Below are screen shots of the configuration basic steps:

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 | 22 Comments

21 Comments

  1. Alex Rykov says:

    Where can this driver be downloaded? I see it mentioned in the docs. Yet I cannot find it.

  2. Alex Rykov says:

    Found it: Once ODBC feature is enabled, go to the Home page, and in the Settings portlet, click the Download ODBC Driver link.

  3. marunach says:

    Hi Mr Marty,

    I have a sql server 2008 dabaase containing a Datewarehouse. the user would liket to directly conenct to netsuite CRM and join the DW tables with CRM tables.

    1. how to go about it?
    2. should the ODBC driver be installed on client machine or inthe SQL server 2008 server?
    3. can we access the nwetsduite DB from sql management studio?
    4. do we really rewuire the wind32open ssl as in your posting?
    5. any other info i need to take care of?

  4. Marty Zigman Marty Zigman says:

    Hello. Let me answer those questions:

    1. You need to get that add-on directly from NetSuite. I believe if you have a development account, they may be able to turn that on. But you are required to pay if it is on a production account.
    2. Where you install the driver depends on your integration approach. Assuming that you will be using SSIS, yes, you will want to install it on the Database Server.
    3. Yes, you will be able to connect to NetSuite and it will look like a regular database.
    4. Yes, as part of the installation, you may need to install some other “connection plumbing”. I believe the latest release, since this first post, has optimized this element.
    5. If you are nervous about the driver, I recommend installing it on a workstation and then connecting with a simple tool like MS Access. This will help you get comfortable with the installation process and the way it works before you touch a Production database.

    Let me know if this makes sense.

    Marty

  5. marunach says:

    Hi Marty, Thanks for the quick response . Much appreciated.

    1. what is the addon you r talking about ?
    i thought just installing the driver would be sufficient enough.

    BTW, Great job your posts.just to compliment on your posts. they were really clear, concise ,simple and fast to understand

  6. Marty Zigman Marty Zigman says:

    Yes, there are a number of add-ons that require NetSuite to throw switches. To determine what you have provisioned, go to: Setup, Company, View Billing Information, Add-On Modules. This will help clarify what capacities you have active and what you need to turn on.

  7. Jerome says:

    Marty,
    Thanks for the insight. Do you know where I can find more information on building a Connection String to use inside SSIS ODBC data source instead of using DSN’s? I have looked through the NetSuite help, finding nothing. I have done several web searches, and that is how I found your blog. But not really anything else on this topic. I have NS ODBC Drivers 6.0 (DataDirect) drivers installed and working using the DSN. But I would rather use a dynamic connection string in my SSIS packages.

    Thanks
    Jerome

  8. Jerome says:

    Marty,
    I did a little more digging, and found this gem:
    DataDirect – Specifying ODBC Connection Attributes

    The missing puzzle piece for me was to include the ENC=1 attribute.

    Jerome

  9. Marty Zigman Marty Zigman says:

    Thanks Jerome. Appreciate the follow up for the community.

    Marty

  10. ganesh says:

    Hi Marty,

    i got the ODBC driver from “Get the ODBC driver” when i installed it, its not showing up in the ODBC sources. I am using windows 7, 64 Bit

  11. John says:

    Just an FYI, I just spent close to 2 weeks to try to connect to Netsuite from MSSQL 2012 express using the Netsuite ODBC driver 6.0 on my Windows 7 PC…

    The Solution? Call netsuite support they have the 64 bit version of the ODBC driver… It’s Netsuite ODBC 7 created by DataDirect.

    I’ve installed it, set it up and it now works wonders. although I had some complications, I got it to work fairly quickly!

    Thanks
    JG

  12. Marty Zigman Marty Zigman says:

    Thanks John. That should help a number of people. I found studying the DataDirect driver helps to diagnose situations.

  13. Marty Zigman Marty Zigman says:

    Ganesh,

    Have a look at John’s solution. It appears that you need to get the updated 64 bit driver. If you get a public link, post it here.

    Marty

  14. John says:

    I’ve searched for a public link for over 2 weeks… as soon as I called Netsuite support they knew exactly what I needed and connected to my PC to send me the file.

    When we asked why it wasn’t public they said because DataDirect did it for them and they had some papers to finalize (or something of that matter) … I really didn’t care for the why I just wanted to get it to work after 2 weeks of banging my head on my desk!!!

    Ganesh, That’s exactly the behavior I was getting… If you run c:\windows\sysWOW64\odbcad32 you will be able to see it and edit it… not matter what you do it won’t work until you call netsuite support and get that netsuite odbc 7.00.

  15. Yukesh says:

    Hello Marty,

    Am new to Netsuite.. Trying to extract data from netsuite using SSIS… I tried using Cozy roc s/w but facing issues in it. please suggest me a way ti extract data from Netsuite using SSIS..

  16. Marty Zigman Marty Zigman says:

    Hello Yukesh,

    Here is a video on the basics of SSIS. http://www.youtube.com/watch?v=Jl0Vze2_6_o Instead of using Microsoft Access, as suggested in the video, use your NetSuite connection which was setup via your ODBC connection. Remember, you are now in the world of SSIS and there are MANY tools available to get data out of NetSuite. I recommend learning SSIS essentials.

    Marty

  17. Pravar Aseem says:

    Hi im using MS SQL Server 2008 to get data from NetSuite and the test connection is successful. However, the SCHEMA Tables are blank. Can you help?

    Thanks,
    Pravar

  18. Marty Zigman Marty Zigman says:

    Hi Pravar,

    Try clicking the options to show system tables on and off. I noticed this problem a couple of times and, by my memory only, I was able to play with the switches to eventually see everything. If you figure it out, let us know.

    Marty

  19. Manjesh says:

    Hi Marty,

    I am trying to download ODBC connection but I am not able to see “Download ODBC Driver” option in my setting. We have already paid for ODBC connection. Do I need to be Admin to download ODBC Driver?
    Any Ideas?
    Thanks in advance.

  20. Marty Zigman Marty Zigman says:

    Hello Manjesh,

    Yes, I suspect you need to be an Administrator to get to the area you can download the ODBC driver. These are good questions for NetSuite Support if you can’t find it.

    Let us know how you resolve it.

    Marty

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>

*