---
title: How to Connect Tableau to NetSuite using the ODBC Driver
description: How to connect Tableau to NetSuite as an ODBC data source using the ODBC driver.
image: https://blog.ennvee.com/hubfs/hero-connecting-netsuite-odbc.jpg
---

<https://www.ennvee.com/>

- Services & Technologies 
    - Services 
          - [Data & AI](https://ennvee.com/data-and-ai/)
          - [Digital Transformation](https://ennvee.com/digital-transformation/)
          - [Data Intelligence](https://ennvee.com/data-intelligence/)
    - [Technologies](https://ennvee.com/technologies/) 
          - [Oracle Fusion Cloud](https://ennvee.com/oracle-fusion/)
          - [Oracle E-Business Suite](https://ennvee.com/oracle-ebs/)
          - [Oracle JD Edwards](https://ennvee.com/oracle-jde/)
          - [Oracle NetSuite](https://ennvee.com/oracle-netsuite/)
          - [Cloud Infrastructure (IaaS)](https://ennvee.com/oracle-cloud-infrastructure/)
          - [Microsoft Dynamics](https://ennvee.com/microsoft-dynamics-365/)
          - [Salesforce](https://ennvee.com/salesforce-cloud-services/)
          - [Application Development & Integration](https://ennvee.com/application-integration-services/)
          - [SAP](https://ennvee.com/sap/)
    - [Tools & Accelerators](https://ennvee.com/accelerators/) 
          - [ennABLE](https://ennvee.com/accelerators/oracle-ebs-r12-2-upgrade-automation/)
          - [ennAccess](https://info.ennvee.com/jde-user-access-record-tool)
          - [TrendZ](https://ennvee.com/accelerators/oracle-proactive-system-monitoring/)
          - [EDI](https://ennvee.com/accelerators/oracle-edi-automation-tool/)
- Products & Solutions 
    - [ennSCM](https://ennvee.com/products/ennscm/)
    - [ennData 360](https://ennvee.com/products/enndata360/)
    - [AI ILMS](https://ennvee.com/products/ai-ilms/)
    - [AI in Finance Operations](https://ennvee.com/products/ai-in-finance-operations/)
    - [Expense Application](https://ennvee.com/products/expense-application/)
    - [Chatbot](https://ennvee.com/products/chatbot/)
    - [Field Sales Pro](https://ennvee.com/products/field-sales-pro/)
    - [AI - Powered Ticketing Tool](https://ennvee.com/products/ai-powered-ticketing-tool/)
    - [AI - Powered PO to SO](https://ennvee.com/products/ai-powered-po-so/)
    - [AI - Resume Grader](https://ennvee.com/products/ai-resume-grader/)
- Insights 
    - [Blogs](https://blog.ennvee.com/blog)
    - [Datasheets](https://ennvee.com/data-sheets/)
    - [Case Studies](https://ennvee.com/case-studies/)
    - [Whitepapers](https://ennvee.com/white-papers/)
- Company 
    - [About](https://ennvee.com/about-us/)
    - [Careers](https://ennvee.com/careers/)
    - [News and Events](https://ennvee.com/news-and-events/)
- [Contact Us](https://ennvee.com/contact-us/)

×

Search

- Services & Technologies 
    - Services 
          - [Data & AI](https://ennvee.com/data-and-ai/)
          - [Digital Transformation](https://ennvee.com/digital-transformation/)
          - [Data Intelligence](https://ennvee.com/data-intelligence/)
    - [Technologies](https://ennvee.com/technologies/) 
          - [Oracle Fusion Cloud](https://ennvee.com/oracle-fusion/)
          - [Oracle E-Business Suite](https://ennvee.com/oracle-ebs/)
          - [Oracle JD Edwards](https://ennvee.com/oracle-jde/)
          - [Oracle NetSuite](https://ennvee.com/oracle-netsuite/)
          - [Cloud Infrastructure (IaaS)](https://ennvee.com/oracle-cloud-infrastructure/)
          - [Microsoft Dynamics](https://ennvee.com/microsoft-dynamics-365/)
          - [Salesforce](https://ennvee.com/salesforce-cloud-services/)
          - [Application Development & Integration](https://ennvee.com/application-integration-services/)
          - [SAP](https://ennvee.com/sap/)
    - [Tools & Accelerators](https://ennvee.com/accelerators/) 
          - [ennABLE](https://ennvee.com/accelerators/oracle-ebs-r12-2-upgrade-automation/)
          - [ennAccess](https://info.ennvee.com/jde-user-access-record-tool)
          - [TrendZ](https://ennvee.com/accelerators/oracle-proactive-system-monitoring/)
          - [EDI](https://ennvee.com/accelerators/oracle-edi-automation-tool/)
- Products & Solutions 
    - [ennSCM](https://ennvee.com/products/ennscm/)
    - [ennData 360](https://ennvee.com/products/enndata360/)
    - [AI ILMS](https://ennvee.com/products/ai-ilms/)
    - [AI in Finance Operations](https://ennvee.com/products/ai-in-finance-operations/)
    - [Expense Application](https://ennvee.com/products/expense-application/)
    - [Chatbot](https://ennvee.com/products/chatbot/)
    - [Field Sales Pro](https://ennvee.com/products/field-sales-pro/)
    - [AI - Powered Ticketing Tool](https://ennvee.com/products/ai-powered-ticketing-tool/)
    - [AI - Powered PO to SO](https://ennvee.com/products/ai-powered-po-so/)
    - [AI - Resume Grader](https://ennvee.com/products/ai-resume-grader/)
- Insights 
    - [Blogs](https://blog.ennvee.com/blog)
    - [Datasheets](https://ennvee.com/data-sheets/)
    - [Case Studies](https://ennvee.com/case-studies/)
    - [Whitepapers](https://ennvee.com/white-papers/)
- Company 
    - [About](https://ennvee.com/about-us/)
    - [Careers](https://ennvee.com/careers/)
    - [News and Events](https://ennvee.com/news-and-events/)
- [Contact Us](https://ennvee.com/contact-us/)

# How to Connect Tableau to NetSuite using the ODBC Driver

[← All posts](https://blog.ennvee.com/blog) <https://blog.ennvee.com/blog/connecting-netsuite-to-tableau-odbc>

 4 MIN READ

Follow these steps to connect Tableau to NetSuite as an ODBC data source.

**Important**: Before you can connect NetSuite to Tableau, you need to download and install the latest version of the [CData ODBC Driver for NetSuite](https://www.cdata.com/drivers/netsuite/download/odbc/). This article uses the 2016 CData ODBC Driver for NetSuite. [Click here](https://blog.ennvee.com/blog/connecting-netsuite-to-odbc-data-source) for the steps to set up the ODBC Driver.

## Installing and Configuring Tableau

Download Tableau: [https://www.tableau.com/products/trial](https://www.tableau.com/products/trial) 

## Running Server Setup

After you download the Tableau Server installation file, follow the instructions below to install the server.

Double-click the installation file. Follow the on-screen instructions to complete Setup and install the application.

![64-bit Tableau Server Setup Screen](https://blog.ennvee.com/hs-fs/hubfs/NetSuite/NetSuite%20Tableau%20ODBC%20Setup/image004.png?width=424&name=image004.png)

After installation is complete, select the Trial version:

![Activate Tableau Trial Version Screen](https://blog.ennvee.com/hs-fs/hubfs/NetSuite/NetSuite%20Tableau%20ODBC%20Setup/image005.png?width=422&name=image005.png)

## **Publish the NetSuite Data Source to Tableau Server**

Provide connectivity to NetSuite data across the enterprise by creating a data source for NetSuite on Tableau Server. Users in your organization can create workbooks connected to the published data source.

### Step 1

Click Connect to Data > More Servers > Other Databases (ODBC). Select CData NetSuite Source Sys, the system DSN.

The driver installation automatically creates a matching user and system DSNs: The system DSN is needed to connect from the Tableau Server.

![Connecting Tableau to CData NetSuite Source Sys](https://blog.ennvee.com/hs-fs/hubfs/NetSuite/NetSuite%20Tableau%20ODBC%20Setup/image006.png?width=1366&name=image006.png)

### Step 2

In the Database menu, select CData.

### Step 3

In the Table box, enter a table name or click New Custom SQL to enter an SQL query. This article retrieves the Sales order table.

![Entering Custom SQL in Tableau](https://blog.ennvee.com/hs-fs/hubfs/NetSuite/NetSuite%20Tableau%20ODBC%20Setup/image007.png?width=1366&name=image007.png)

### Step 4

Drag the table onto the join area.

### Step 5

In the Connection menu, select the Extract option.

After executing the query and based on the table, the records are displayed.

![Records displayed in Tableau after executing custom SQL query](https://blog.ennvee.com/hs-fs/hubfs/NetSuite/NetSuite%20Tableau%20ODBC%20Setup/image008.png?width=1366&name=image008.png)

To generate a report, go through the sheets at the bottom of the page. The page opens with two sections:

1. **Dimensions**: The record fields are displayed with their particular field internal IDs.
2. **Measures**: Displays the summary fields with their particular field internal IDs.

The fields can be segregated based on the rows and columns.

![Segregating Fields in Tableau](https://blog.ennvee.com/hs-fs/hubfs/NetSuite/NetSuite%20Tableau%20ODBC%20Setup/image009.png?width=1366&name=image009.png)

An example Purchase Order report that we can generate based on the fields:

![Example of a Purchase Order Report created in Tableau](https://blog.ennvee.com/hs-fs/hubfs/NetSuite/NetSuite%20Tableau%20ODBC%20Setup/image010.png?width=1366&name=image010.png)

To view the NetSuite data, right-click under the table name in the Data section of the dashboard and select the View Data option. The NetSuite data will appear in Tableau.

[![New call-to-action](https://no-cache.hubspot.com/cta/default/5314978/c22c68ed-6bc3-4eff-9225-b4e99fa38be3.png)](https://cta-redirect.hubspot.com/cta/redirect/5314978/c22c68ed-6bc3-4eff-9225-b4e99fa38be3)

Check out our other [NetSuite blogs](https://blog.ennvee.com/blog/tag/netsuite) for how-to guides, tips and other [NetSuite solutions](https://ennvee.com/oracle-netsuite/). [Contact us](https://ennvee.com/contact-us/) to discuss your challenges.

### Tags

[NetSuite](https://blog.ennvee.com/blog/tag/netsuite) [Tableau](https://blog.ennvee.com/blog/tag/tableau) [How To Guide](https://blog.ennvee.com/blog/tag/how-to-guide) [Step-by-Step](https://blog.ennvee.com/blog/tag/step-by-step) [ODBC Driver](https://blog.ennvee.com/blog/tag/odbc-driver) [NetSuite Connection Guide](https://blog.ennvee.com/blog/tag/netsuite-connection-guide)

### Recent Posts

- [NetSuite Revenue Recognition Automation for Enterprise Finance](https://blog.ennvee.com/blog/netsuite-revenue-recognition-automation)
- [NetSuite Advanced Revenue Management for SaaS](https://blog.ennvee.com/blog/netsuite-advanced-revenue-management-saas)
- [Oracle NetSuite Features with Artificial Intelligence: The Complete Guide for Enterprise and Accounting Leaders](https://blog.ennvee.com/blog/netsuite-ai-features-enterprise-guide)
- [Oracle NetSuite Procure-to-Pay Optimization: Automation, Compliance, Analytics, and Continuous Improvement](https://blog.ennvee.com/blog/netsuite-procure-to-pay-automation-compliance-analytics)
- [NetSuite Procure-to-Pay: Business Value, Core Components, and Process Foundation](https://blog.ennvee.com/blog/netsuite-procure-to-pay-business-value-core-components)

## You Might Also Like...

[BLOG Using ODBC Driver for NetSuite Integration](https://blog.ennvee.com/blog/connecting-netsuite-to-odbc-data-source)

[BLOG Connecting Power BI to NetSuite with ODBC Driver](https://blog.ennvee.com/blog/connecting-netsuite-to-power-bi)

[BLOG NetSuite ERP Extensions vs Third-Party Integration: Which Path Delivers Better ROI?](https://blog.ennvee.com/blog/netsuite-extensions-vs-third-party-integration-roi-comparison)

- [SERVICES](https://ennvee.com/services/) 
    - [Oracle Fusion Cloud](https://ennvee.com/oracle-fusion/)
    - [Oracle E-Business Suite](https://ennvee.com/oracle-ebs/)
    - [Oracle JD Edwards](https://ennvee.com/oracle-jde/)
    - [Oracle NetSuite](https://ennvee.com/netsuite/)
    - [Cloud Infrastructure (laaS)](https://ennvee.com/infrastructure-iaas/)
    - [Robotic Process Automation (RPA)](https://ennvee.com/robotic-process-automation/)

- [INNOVATIONS](https://ennvee.com/accelerators/) 
    - [Accelerators](https://ennvee.com/accelerators/#ProprietaryAccelerators)
    - [Products](https://ennvee.com/accelerators/#Products)

- [INSIGHTS](https://ennvee.com/resources/) 
    - [Blog](https://blog.ennvee.com/blog)
    - [Data Sheets](https://ennvee.com/data-sheets/)
    - [Case Studies](https://ennvee.com/case-studies/)
    - [White Papers](https://ennvee.com/white-papers/)

- CONTACT INFORMATION 
    - US: +1-630-364-1911
    - India: +91-93848 42661
    - mail: corp@ennvee.net
    - <https://www.linkedin.com/company/ennvee/> <https://twitter.com/ennVeeTech> <https://www.facebook.com/ennveetechnogroupinc> <https://www.instagram.com/ennvee_india/>

[© ennVee. All Rights Reserved.](https://ennvee.com/legal-notice/)

- [privacy policy](https://ennvee.com/privacy-policy/)
- [site map](https://ennvee.com/page-sitemap.xml)

![ennVee logo with caption](https://ennvee.com/wp-content/uploads/elementor/thumbs/ennVee-Logo-with-caption-qiqarok1svjxpl51nz0rwx674xtqlg0ar9c14r3d34.png "ennVee logo with caption")

- Services 
    - [Oracle Fusion Applications](https://ennvee.com/oracle-saas-applications/)
    - [NetSuite](https://ennvee.com/netsuite/)
    - [Microsoft Dynamics](https://ennvee.com/microsoft-dynamics-365/)
    - [Salesforce](https://ennvee.com/salesforce/)
    - [Infrastructure (IaaS)](https://ennvee.com/infrastructure-iaas/)
    - [Application Managed Services](https://ennvee.com/application-managed-services/)
    - [Robotic Process Automation (RPA)](https://ennvee.com/robotic-process-automation/)
    - [Application Integration Services](https://ennvee.com/application-integration-services/)
- [Accelerators](https://ennvee.com/accelerators/) 
    - [Oracle EBS Upgrade Automation](https://ennvee.com/accelerators/oracle-ebs-r12-2-upgrade-automation/)
    - [Oracle Proactive System Monitoring](https://ennvee.com/accelerators/oracle-proactive-system-monitoring/)
    - [Oracle Discoverer Migration Tool](https://ennvee.com/accelerators/oracle-discoverer-migration-tool/)
    - [Oracle EDI Automation Tool](https://ennvee.com/accelerators/oracle-edi-automation-tool/)
- Resources 
    - [Blog](https://blog.ennvee.com/blog)
    - [Data Sheets](https://ennvee.com/data-sheets/)
    - [Case Studies](https://ennvee.com/case-studies/)
    - [Webinars](https://ennvee.com/webinars/)
    - [White Papers](https://ennvee.com/white-papers/)
    - [Careers](https://ennvee.com/careers/)

[![LinkedIn](https://blog.ennvee.com/hubfs/Socialmedia_Icons/linkedin.svg "LinkedIn")](https://www.linkedin.com/company/ennvee/) [![Facebook](https://blog.ennvee.com/hubfs/Socialmedia_Icons/facebook.svg "Facebook")](https://www.facebook.com/ennveetechnogroup/) [![Twitter](https://blog.ennvee.com/hubfs/Socialmedia_Icons/twitter.svg "Twitter")](https://twitter.com/ennVeeTech) [![Instagram](https://blog.ennvee.com/hubfs/Socialmedia_Icons/instagram.svg "Instagram")](https://www.instagram.com/ennvee_india/)

[© ennVee. All Rights Reserved.](https://ennvee.com/legal-notice/)

[Privacy Policy](https://ennvee.com/privacy-policy/)    [Site Map](https://ennvee.com/page-sitemap.xml)

![ennVee logo with caption](https://ennvee.com/wp-content/uploads/elementor/thumbs/ennVee-Logo-with-caption-qiqarok1svjxpl51nz0rwx674xtqlg0ar9c14r3d34.png "ennVee logo with caption")