What is the Live Data Connector?
The Smartsheet Live Data Connector provides industry-standard connectivity via ODBC to the third-party apps you use most, like Tableau, Excel, QlikView / Qlik Sense, Tibco Spotfire, and more. This allows you to deliver powerful data visibility and insights with your Smartsheet data via the tools you already use.
Connect Smartsheet with Tableau (WDC) and Other Apps (ODBC)
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.