Discover how a bimodal integration strategy can address the major data management challenges facing your organization today.
Get the Report →
Smartsheet Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Smartsheet data through CData Connect Cloud using different applications and tools.
CData Connect Cloud provides access to Smartsheet data from popular BI, analytics, ETL, and custom applications. In addition to pre-built client tools, CData Connect Cloud enables direct real-time bi-directional integration from a wide range of cloud applications. Below you will find a list of guides and tutorials for integrating with live Smartsheet data.
Connect Cloud Integrations
Click below to jump to articles related to specific integration use-case.
- Business Intelligence & Analytics - charting, reports, and more (Tableau, Power BI, Amazon QuickSight, etc.)
- ETL & Replication - moving and replicating data (AWS Glue, Oracle Data Integrator, etc.)
- Data Virtualization - retrieving and manipulating data (DbVisualizer, SQL Server PolyBase, etc.)
- Software Development - developing custom applications (.NET, AngularJS, Ruby, Python, etc.)
- Data Management - managing data (DBArtisan, RazorSQL, SQuirreL, etc.)
- Workflow Automation - building automated workflows (SSIS, Power Automate, etc.)
Business Intelligence & Analytics
ETL & Replication
| Product | Article Title |
|---|---|
| Airbyte | Connect to Smartsheet Data in Airbyte ELT Pipelines |
| AWS Glue | Build ETL Jobs with Smartsheet Data in AWS Glue Jobs |
| Azure Data Factory | Import Smartsheet Data Using Azure Data Factory |
| Microsoft Power Automate | Build Smartsheet-Connected Automated Tasks with Power Automate (Desktop) |
| SQL Server Linked Server | Connect to Smartsheet Data as a SQL Server Linked Server |
Data Virtualization
| Product | Article Title |
|---|---|
| APOS Live Data Gateway | Build Semantic Layer Views for Smartsheet Data (Connect Cloud) |
| Salesforce Connect | Edit and Search Smartsheet External Objects in Salesforce Connect |
| SQL Server PolyBase | Connect to Smartsheet Data using PolyBase with Connect Cloud |
Software Development
| Product | Article Title |
|---|---|
| AppSheet | Create Smartsheet-Connected Business Apps in AppSheet |
| Bubble.io | Build Smartsheet-Connected Apps in Bubble |
| Choreo | Build Custom Apps on Smartsheet Data in Choreo |
| Google Apps Script | Connect to Smartsheet Data in Google Apps Script |
| Mendix | Build Smartsheet-Connected Apps in Mendix |
| Microsoft Power Apps | Integrate Live Smartsheet Data into Custom Business Apps Built in Power Apps |
| NodeJS | Query Smartsheet Data in Node.js (via Connect Cloud) |
| OutSystems | Create Smartsheet-Connected Enterprise Applications in OutSystems |
| RunMyProcess | Connect to Smartsheet Data in RunMyProcess |
| Unqork | Create Smartsheet-Connected Applications in Unqork |
Data Management
| Product | Article Title |
|---|
Workflow Automation
| Product | Article Title |
|---|---|
| Nintex Workflow Cloud | Build Smartsheet-Connected Workflows in Nintex |
| Power Automate | Integrate Smartsheet Data into Power Automate Automated Tasks |
Data Connectors
ETL/ ELT Solutions
Cloud & API Connectivity
OEM & Custom Drivers