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....
Related 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 – ...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 ...Add, remove, or change a trusted location in Microsoft Office
A trusted location in Microsoft Office is a folder that contains files you trust to be safe. You should use a trusted location to store a file when you don't want that file to be checked by the Trust Center, or if you don't want it to open in ...Office365- POP, IMAP, and SMTP settings
The following is taken from the MS Support Site.....Link Below: https://support.microsoft.com/en-us/office/pop-imap-and-smtp-settings-8361e398-8af4-4e97-b147-6c6c4ac95353 You can use Outlook to read and send mail from Yahoo, Gmail, Hotmail, and other ...Island Enterprise Browser - Installation Guide
Installation Guide If your device is Managed by Marriott, Island Enterprise Browser will be installed for you. How do I know if my device is Managed by Marriott? On Windows, follow Microsoft's guidance to see installed apps and search for Bigfix. If ...