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.
- Run %windir%\system32\odbcad32.exe to start the Windows Data Sources (ODBC) manager.
- Select a User DSN or System DSN and then click Add. You should be presented with a dialog as illustrated. Select the DataDirect driver.
- 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.
- Select the Security tab and turn on Encrypted SSL. See dialog.
- Finally, Test Connect and you should be prompted for a user name and password.
Related Articles
- Resolving ODBC 64 bit Driver References
- SQL Reporting on NetSuite Data Step-By-Step
- Connecting ODBC to Multiple NetSuite Accounts
- NetSuite ODBC: “You Don’t Have Permission to Use ODBC.”
- Extract NetSuite Data for Backup and Reporting
- Warning: SQL Server Linked Server to NetSuite Issues
- Considering Producing NetSuite Financial Statements using Third Party Tools?
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?
Hi Rich,
That is a great question. It looks like DataDirect offers a Linux driver. See this link:
https://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
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.
Thnaks Marty for the resposne. We’ll take a look and let you know.
Rich
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.
Hi Jeff,
We can help. Let’s setup a conversation. I sent you a direct email.
Marty
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.
Hi Mike,
I think this may be off topic. Have you seen this article however that addresses your concern?
https://blog.prolecto.com/2011/09/08/misconception-1-about-netsuite-cant-get-off-the-system/
[…] 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. […]
[…] 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 […]
[…] NetSuite 64-bit ODBC Setup Instructions […]
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
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
Can I use jdbc-odbc bridge connection?
I haven’t tried it. But a Java application should be fine using it.
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?
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
Hi Marty,
Thanks for your answer however Netsuite now has a JDBC driver so we can directly consume it in our Java based programs
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.
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
I am trying to setup the connection via “ODBC Data Source Administrator” on Windows Server 2012. When I click on the Security tab, there is no place to select the “Encrypted (SSL)”. I do have the two security certificates selected. When I click the test button, instead of having the popup that asks me to enter a username and pw, i get an error message that says: [NetSuite][ODBC 64bit driver][64bit Client] TCP/IP error, connection timed out. Any ideas why this is happening?
Hi Spencer, I do not. I suspect you are not referencing the right server.
In case anyone ever gets the error I mentioned previously, this is related to a firewall setting. We had to open port 1708 (for the NetSuite URL).
I have the 32 and 64 bit ODBC connnections working. However when I try to reference them in SSIS using ADO.NET, only the 32 bit ODBC connection shows up. Any ideas why?
Hi,
We’re trying to package and deploy the ODBC driver using SCCM. It’s a real nightmare – a scripted installation referencing the setup.iss file fails to complete because, during the install, a second process is launched which finishes before the main installation – we see an error code (which I’ve matched as successful in sccm) – do you have any guidance on how we can deploy this via sccm (both install and uninstall). I’ve toiled over this for about a day!
Hi David,
I don’t have any experience trying to script the ODBC driver for deployment. My sense is that this demands traditional Windows Administration leadership. Good luck.
Marty