Connect Smartsheet with Tableau (WDC) and Other Apps (ODBC)
This Help Article Appears in the Following Learning Tracks
Smartsheet for Tableau Integration
Gain valuable insight with the Smartsheet for Tableau integration. With Smartsheet for Tableau, anyone on Mac and Windows can enjoy richer features, and ease of use with the integration. Smartsheet for Tableau is built on Tableau’s Web Data Connector Technology (WDC), which requires no additional software to maintain or install.
See the Smartsheet for Tableau help article for details on working with the integration.
Integrate with Other ODBC Supported Services
The Smartsheet Live Data Connector provides industry-standard ODBC connectivity between Smartsheet and third-party tools. It enables business users to interact with and visualize data stored in Smartsheet using business analytics and data visualization software such as Tableau, QlikView / Qlik Sense, Microsoft Excel, and others.
The capability discussed here is available to licensed people on a Business or Enterprise plan only. For more information on plans and pricing, please see our Pricing page.
The Live Data Connector uses the Open Database Connectivity (ODBC) interface by Microsoft that allows applications to access data in database management systems (DBMS) using SQL as a standard for accessing the data.
Download the latest version of the ODBC Driver here.
Examples of using the Live Data Connector to interact with other tools include, but aren't limited to, the following:
- Create charts, graphs, pivot tables and other visualizations in Excel with data stored in one or more Smartsheet sheets
- Create reports in Tableau with data stored in one or more Smartsheet sheets.
Click here to review the full Smartsheet Live Data Connector documentation. The documentation includes technical requirements, instructions to install the driver and connect it to other services, FAQs and troubleshooting tips.
I use Power BI and can't configure ODBC.
With the depreciation of Internet Explorer 11, some Power BI Desktop users may not be able to configure ODBC because Power BI uses IE11 for authentication and authorization. To fix this, update your version of Power BI.
- Uninstall Power BI.
- Restart your computer.
- Download and reinstall Power BI. Verify you've installed the August 2021 version or newer
- In the Power BI security settings (File > Options > Security), enable Use my default web browser.