If you have a technical issue, please provide detailed information on the issue to our Support team at our Support Contact page. If you experience any difficulties, have questions or feature requests, please visit the Smartsheet Help Center. Microsoft Excel 2010, 2013, 2016 - Data Connection Wizard, MSFT Query, Power Query.Tibco Spotfire Desktop, Server, Web Player 7.0.1+.Tableau Desktop Professional Edition 8.2/8.3/9.x or Tableau Server 8.3.3/9.x.Microsoft Windows 7, Windows 8, or Windows Server 2012Īdditionally, to use the driver you will need access to at least one of these products:.Live Data Connector license (included in some plans - see pricing).In order to use the Live Data Connector you will need:

This section provides a fast track to getting you up and running with the Smartsheet Live Data Connector as quickly as possible.Īfter you’ve completed setup and configured the Live Data Connector with the software of your choice, we recommend reading through the Configuration section. Create charts, graphs and other visualizations with data stored in one or more Smartsheet sheets or reports.Interact with Smartsheet data dynamically, using Smartsheet as a live data source.Smartsheet-wide access control (ACL) is enforced and data access and retrieval via ODBC is subject to all Smartsheet’s existing security mechanisms.

The Connector is compatible with version 3.8 of the ODBC specification.

Industry-standard ODBC-based connectivity to Smartsheet.

Note: The Smartsheet Live Data Connector now supports Microsoft Access 20, Spotfire Server 7.0.1, and Spotfire Web Player as of version 1.2 Note: The Smartsheet Live Data Connector provides a read-only experience and is not able to write data into Smartsheet.īenefits of using the Live Data Connector include, but not limited to, the following: It enables business users to interact with and visualize data stored in Smartsheet using business analytics and data visualization software such as Tableau, Spotfire, QlikView / Qlik Sense, Excel and others. The Smartsheet Live Data Connector (also known as the Smartsheet ODBC Driver) provides industry-standard connectivity between Smartsheet and third-party analytics tools.

Sqlite driver for tableau on mac