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.

Odbc driver mac excel 2013