Smartsheet - Live Data Connector (ODBC)

Integrate with other ODBC supported services

Link to full article: Smartsheet - Live Data Connector

The Smartsheet Live Data Connector provides Microsoft Open Database Connectivity (ODBC) connectivity between Smartsheet and third-party tools. It enables you 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 Live Data Connector uses ODBC interface by Microsoft that allows applications to access data in database management systems (DBMS) using SQL as a standard for accessing the data.

Before you begin, make sure you have the latest driver. Download latest ODBC Drivers

* Please Note - check you Office365 instance to make sure that you install the correct driver for your installation. There are 32 and 64 bit options.

You can verify what version of MS 365 you have installed by navigating to the File/Account menu of any of the apps...then select "About"

Examples of using the Live Data Connector to interact with other tools include the following:

      Create charts, graphs, pivot tables, and other visualizations in Excel with data stored in one or more Smartsheet sheets

      Create extracts of data for inclusion into local work documents      

Once Downloaded and Installed....

Click Here for instructions: Configure the Smartsheet Connection

• Related Articles

• Marriott Fosse Historical Data Instructions

  In the case that a Marriott property Night Audit transmission (from the Fosse PMS) wasn’t received or imported by M3. The GM would push a new file to M3 for them to interface using steps below. Fosse Historical Data Retrieval Instructions From the ...

• Marriott Brand IT Support

  Access the Marriott Service Portal (Note - Requires Marriott Profile to login) https://marriott.service-now.com/msp Live Chat Feature for general inquiries Create new case Review open cases Search Marriott Knowledge Base Articles

• ADD PCI ITEMS IN QUORE - INSTRUCTIONS

  ADD PCI ITEMS IN QUORE From the desktop Inventory app, click on the Item List page button. Find the +New Category button, under Go to Hotel button. Enter Department, Name, and Example. Then, click Add Category button. Department – Management Name – ...

• Hyatt Brand IT Support

  Access the Hyatt Service Portal (Note - Requires Hyatt Profile to login) https://hyatt.service-now.com/serviceportal?id=hssp_submit_ticket&sys_id=716b364b37aa4200a457085a43990ee1&sysparm_select_option=init Live Chat Feature for general inquiries ...

• Technology Hardware and Software Requests (for Computers, O365, Licensing, etc.)

  Link to the form to fill out Technology Requests (smartsheet.com) Instructions when filling out: 1. Requested By Enter the requestor's email address (required). Note: Please add requests for multiple locations separately 2. Hotel Entity Choose the ...