Key Features

• Familiar setup – You can configure your analytics and reports using the Live Data Connector with the tools you already use. Refer to our detailed instructions on how to use the driver to connect Smartsheet to a variety of applications so you can get started today.
• Industry standard connection – For over 20 years, ODBC has been the industry standard for accessing and translating data. The Live Data Connector provides a common integration to any ODBC-capable third party application. It is recommended by Tableau as the preferred way to integrate with Tableau products.
• Instant updates – Refreshing your dashboards and charts will always reflect the latest data stored in Smartsheet. Analyze your sheets in real-time with a single click.The Smartsheet Live Data Connector (also known as the Smartsheet ODBC Driver) provides industry-standard connectivity between Smartsheet and third-party analytics tools. 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 ODBC Driver is a powerful tool that allows you to connect with live data from Smartsheet.com, directly from any applications that support ODBC connectivity. Access Smartsheet Sheets, Contacts, Folders, Groups, Users, etc. through a standard ODBC Driver interface.

  The Smartsheet ODBC Driver is a powerful tool that allows you to connect with live data from Smartsheet, directly from any applications that support ODBC connectivity. Access Smartsheet Sheets, Contacts, Folders, Groups, Users, etc. through a standard ODBC Driver interface. Get Started

  Connect from BI, Reporting, & ETL Tools

  The Smartsheet ODBC Driver is a powerful tool that allows you to easily connect-to live Smartsheet.com data through any ODBC capable application or tool! With the Driver users can access Smartsheet.com the same way that they would connect to any other ODBC data source. The Drivers are completely self-contained; no additional software installation is required.

  Straightforward ODBC Connectivity

  • Access Smartsheet.com data through widely available tools – standard ODBC interface offering the greatest accessibility from applications and developer technologies.
  • Advanced wire-protocol SSL security for remote connectivity
  • Faster application deployment and configurationConnect to Smartsheet project direction info from reporting programs, databases, and custom programs through standards-based drivers.BI & Data Visualization

    Connect to real-time Smartsheet info from any BI or even Reporting tool.

    ETL & Replication

    Simplify ETL & Data Replication to some RDBMS or Information Warehouse.

    Data Management

    Utilize Smartsheet data straight from popular database management applications.

    Workflow & Automation

    Integrate Smartsheet through popular workflow and automation program.

    Software Development

    Easily integrate with Smartsheet from some other evolution technology.

    Data Virtualization

    Seamless integration with hot Information Virtualization technology.

    Access live Smartsheet data from the full suite of SAP applications like Lumira, Analytics Cloud, & BusinessObjects Cloud. Simply configure a data connection to Smartsheet, expose external access through the UI, and connect their SAP applications to access live Smartsheet data.

    View Pricing
    SQL – The Original Data API

    SQL is the ‘lingua franca’ of data access. If your application knows how to connect to a MySQL or SQL Database, it can integrate with Smartsheet (or any supported data source) through the Cloud Hub.

    Simplified Data Access through OData (REST)

    Create OData / OpenAPI endpoints for your Smartsheet data to ease integration with analytics, BI, reporting, and ETL tools, including SAP Analytics Cloud.

    Any Data Source to Any Cloud App

    Connect to data from any data source, in the cloud, from any data-centric app, tool or platform. Over 100+ supported data Sources, including Smartsheet and growing every day.

    Comprehensive Data Model & Dynamic Discovery

    The Smartsheet Connector in Cloud Hub gives you comprehensive access to all of the data exposed from Smartsheet, including full access to dynamic data of any type.

    Customizable Configuration

    Configure the Cloud Hub from the command line using standard DDL statements (e.g. CREATE DATABASE) or through the straightforward point-and-click interface.

    SQL – The Original Data API

    SQL is the ‘lingua franca’ of data access. If your application knows how to connect to a MySQL or SQL Database, it can integrate with Smartsheet (or any supported data source) through the CData Connect Cloud.

    Secure Data Access

    Powerful security and access management capabilities including integrated transaction monitoring, management, and data access controls. All communications channels are secured by strong SSL security.

    Highly Extensible Design

    The Cloud Hub exposes dozens of services that are easily accessible through simple standards-based interfaces like SOAP, REST, HTML, RSS, ATOM, JSON, XLS, and CSV.

    Comprehensive Data Model & Dynamic Discovery

    The Smartsheet Connector in CData Connect Cloud gives you comprehensive access to all of the data exposed from Smartsheet, including full access to dynamic data of any type.

    Less Benefits

    The SAP ODBC Driver is an extremely powerful networking tool which enables you to seamlessly connect-to live SAP NetWeaver information through any ODBC enabled program or device! The SAP ODBC Drivers are almost entirely self-contained; there is no additional software installation required. All types of Database, Reporting, ETL, Business Intelligence, and Application Service providers now provide the ability to read, write and handle data through ODBC connection. Many of today’s leading enterprise level software products for SAP provide direct support for SAPODB database servers. This means that if you are running Windows CE, Windows NT, Windows 2021, Windows XP or SQL Server, then most likely you will already have an effective and efficient driver installed on your system.In order to use the driver, the computer on which it is installed needs to be connected to a non-isolated peripheral device or network. Some of the more common ways to get an ODBC driver installed in your computer include CD-ROM, CD-RW, USB drives, network adapters, or network cables. You will also find support for this technology on the many online portal sites that specialize in server management products. Installation procedures for most drivers are very easy and straightforward. Most of these tools work by just providing a CD or DVD drive and drivers for the operating system that the computer is based on.

    There are a number of different ways to connect to and use the Microsoft Office Data Connection (ODBC) database engine from a Windows based platform. As previously mentioned, a number of different companies provide commercial support for a variety of databases, including Microsoft Dynamics GP, Microsoft SharePoint Solutions, Microsoft Access, Microsoft SQL Server, IBM Lotus Notes, MySQL, and other systems. SAP ODBC drivers can also be found and installed on websites dedicated to connectivity and software enhancement. SAP manufactures make their own databases, so many of them provide customized driver packages for specific platforms and devices. For example, SAP recommends drivers for its Workspace Optimized Navigation Architecture (SOA) driver, which is used for accessing Workspace and Project files, implementing navigation and task switching, handling database connectivity, and implementing optimization for the server. The company has published many instructional PDFs on its website that give step-by-step instructions on how to install and utilize the ODBC driver.