Ready to get started?

Learn more:

TSheets Connectivity Solutions

TSheets Integration Guides and Tutorials



A list of guides and tutorials for connecting to and working with live TSheets data.

CData Software's connectivity tools enable users to connect directly to live TSheets data data from widely-used BI, analytics, ETL, and custom applications, ensuring that our customers can access their data wherever they desire. Below, you'll find a collection of guides and tutorials on integrating with live TSheets data.

Integration Use-Cases

Click below to jump to articles related to specific integration use-case.

Business Intelligence & Analytics


ProductTechnologyArticle Title
Alteryx DesignerODBCPrepare, Blend, and Analyze TSheets in Alteryx Designer (ODBC)
Alteryx DesignerConnect CloudWork with Live TSheets Data in Alteryx Designer (Connect Cloud)
Amazon QuickSightConnect CloudBuild Interactive Dashboards from TSheets Data in Amazon QuickSight
Amazon SageMakerConnect CloudIntegrate Live TSheets data into Amazon SageMaker Canvas
Aqua Data StudioJDBCConnect to TSheets in Aqua Data Studio
AWS DatabricksJDBCProcess & Analyze TSheets Data in Databricks (AWS)
Azure Analysis ServicesConnect CloudModel TSheets Data Using Azure Analysis Services
BirstJDBCBuild Visualizations of TSheets in Birst
BIRTJDBCDesign BIRT Reports on TSheets
Clear AnalyticsODBCBuild Charts with TSheets in Clear Analytics
Cognos Analytics (On-Prem)Connect CloudAnalyze TSheets Data in Cognos Analytics
DBxtraODBCBuild Dashboards with TSheets in DBxtra
DomoODBCCreate Datasets from TSheets in Domo Workbench
Dundas BIODBCBuild Dashboards with TSheets in Dundas BI
Excel (on Mac OS)ODBCWork with TSheets Data in MS Excel on Mac OS X
FineReportJDBCFeed TSheets into FineReport
Google SheetsConnect CloudAccess Live TSheets Data in Google Sheets
IBM Cognos BIODBCCreate Data Visualizations in Cognos BI with TSheets
Infragistics RevealConnect CloudAnalyze TSheets Data in Infragistics Reval
JasperServerJDBCCreate TSheets Reports on JasperReports Server
Jaspersoft BI SuiteJDBCConnect to TSheets in Jaspersoft Studio
JReport DesignerJDBCIntegrate with TSheets in JReport Designer
KlipfolioConnect CloudCreate TSheets-Connected Visualizations in Klipfolio
KNIMEJDBCEnable the TSheets JDBC Driver in KNIME
LINQPadADO.NETWorking with TSheets in LINQPad
LookerConnect CloudAnalyze TSheets Data in Looker
Looker StudioConnect CloudCreate Reports from TSheets Data in Looker Studio
MetabaseConnect CloudCreate Interactive TSheets-Connected Metabase Dashboards
Microsoft ExcelConnect CloudAccess Live TSheets Data in Excel Desktop
Microsoft Excel for the WebConnect CloudAccess Live TSheets Data in Excel for the Web
Microsoft SSASADO.NETBuild an OLAP Cube in SSAS from TSheets
MicroStrategyConnect CloudConnect to Live TSheets Data in MicroStrategy through Connect Cloud
MicroStrategyJDBCUse the CData JDBC Driver for TSheets in MicroStrategy
Microstrategy DesktopJDBCUse the CData JDBC Driver for TSheets in MicroStrategy Desktop
Microstrategy WebJDBCUse the CData JDBC Driver for TSheets in MicroStrategy Web
Mode AnalyticsConnect CloudCreate TSheets-Connected Visualizations in Mode
OBIEEJDBCTSheets Reporting in OBIEE with the TSheets JDBC Driver
pandasPythonUse pandas to Visualize TSheets in Python
Pentaho Report DesignerJDBCIntegrate TSheets in the Pentaho Report Designer
Power BI DesktopPower BIAuthor Power BI Reports on Real-Time TSheets
Power BI ServiceConnect CloudVisualize Live TSheets Data in the Power BI Service
Power PivotConnect CloudAccess TSheets Data in Microsoft Power Pivot
Power QueryConnect CloudAccess TSheets Data in Microsoft Power Query
Qlik CloudConnect CloudCreate Apps from TSheets Data in Qlik Sense Cloud
QlikViewODBCConnect to and Query TSheets in QlikView over ODBC
RJDBCAnalyze TSheets in R (JDBC)
RODBCAnalyze TSheets in R (ODBC)
RapidMinerJDBCConnect to TSheets in RapidMiner
RedashConnect ServerBuild TSheets-Connected Dashboards in Redash
SAP Analytics CloudConnect CloudAnalyze TSheets Data in SAP Analytics Cloud
SAP Business ObjectsJDBCCreate an SAP BusinessObjects Universe on the CData JDBC Driver for TSheets
SAP Crystal ReportsJDBCPublish Reports with TSheets in Crystal Reports
SASODBCUse the CData ODBC Driver for TSheets in SAS for Real-Time Reporting and Analytics
SAS JMPODBCUse the CData ODBC Driver for TSheets in SAS JMP
SAS ViyaConnect CloudAnalyze Live TSheets Data in SAS Viya
SisenseJDBCVisualize Live TSheets in Sisense
Spago BIJDBCConnect to TSheets in SpagoBI
TableauTableauVisualize TSheets in Tableau Desktop
Tableau CloudConnect CloudBuild TSheets Visualizations in Tableau Cloud
Tableau ServerTableauPublish TSheets-Connected Dashboards in Tableau Server
TIBCO SpotfireADO.NETVisualize TSheets in TIBCO Spotfire through ADO.NET
TIBCO SpotfireConnect ServerVisualize TSheets Data in TIBCO Spotfire
TIBCO Spotfire ServerJDBCOperational Reporting on TSheets from Spotfire Server
Zoho AnalyticsConnect CloudCreate TSheets-Connected Dashboards in Zoho Analytics

Back to top

ETL & Replication


ProductTechnologyArticle Title
AirbyteConnect CloudConnect to TSheets Data in Airbyte ELT Pipelines
Amazon RedshiftCData SyncAutomated Continuous TSheets Replication to Amazon Redshift
Amazon S3CData SyncAutomated Continuous TSheets Replication to Amazon S3
Apache AirflowJDBCBridge TSheets Connectivity with Apache Airflow
Apache CamelJDBCIntegrate with TSheets using Apache Camel
Apache CassandraCData SyncAutomated Continuous TSheets Replication to Apache Cassandra
Apache KafkaCData SyncAutomated Continuous TSheets Replication to Apache Kafka
Apache NiFiJDBCBridge TSheets Connectivity with Apache NiFi
AWS GlueConnect CloudBuild ETL Jobs with TSheets Data in AWS Glue Jobs
Azure Data FactoryConnect CloudImport TSheets Data Using Azure Data Factory
Azure Data LakeCData SyncAutomated Continuous TSheets Replication to Azure Data Lake
Azure SynapseCData SyncAutomated Continuous TSheets Replication to Azure Synapse
BIMLSSISUse Biml to Build SSIS Tasks to Replicate TSheets to SQL Server
CloverDXJDBCConnect to TSheets in CloverDX (formerly CloverETL)
CouchbaseCData SyncAutomated Continuous TSheets Replication to Couchbase
CSVCData SyncAutomated Continuous TSheets Replication to Local Delimited Files
DatabricksCData SyncAutomated Continuous TSheets Replication to Databricks
FoxProODBCWork with TSheets in FoxPro
Google AlloyDBCData SyncAutomated Continuous TSheets Replication to Google AlloyDB
Google BigQueryCData SyncAutomated Continuous TSheets Replication to Google BigQuery
Google Cloud SQLCData SyncAutomated Continuous TSheets Replication to Google Cloud SQL
Google Data FusionJDBCBuild TSheets-Connected ETL Processes in Google Data Fusion
Heroku / Salesforce ConnectCData SyncReplicate TSheets for Use in Salesforce Connect
HULFT IntegrateJDBCConnect to TSheets in HULFT Integrate
IBM DB2CData SyncAutomated Continuous TSheets Replication to IBM DB2
Informatica CloudJDBCIntegrate TSheets in Your Informatica Cloud Instance
Informatica PowerCenterJDBCCreate Informatica Mappings From/To a JDBC Data Source for TSheets
Jaspersoft ETLJDBCConnect to TSheets in Jaspersoft Studio
Microsoft AccessCData SyncAutomated Continuous TSheets Replication to Microsoft Access
Microsoft Azure TablesCData SyncAutomated Continuous TSheets Replication to Azure SQL
Microsoft Power AutomateConnect CloudBuild TSheets-Connected Automated Tasks with Power Automate (Desktop)
MongoDBCData SyncAutomated Continuous TSheets Replication to MongoDB
MySQLCData SyncAutomated Continuous TSheets Replication to MySQL
Oracle Data IntegratorJDBCETL TSheets in Oracle Data Integrator
Oracle DatabaseCData SyncAutomated Continuous TSheets Replication to Oracle
petlPythonExtract, Transform, and Load TSheets in Python
PostgreSQLCData SyncAutomated Continuous TSheets Replication to PostgreSQL
Replicate to MySQLPowerShellReplicate TSheets to MySQL with PowerShell
SAP HANACData SyncAutomated Continuous TSheets Replication to SAP HANA
SingleStoreCData SyncAutomated Continuous TSheets Replication to SingleStore
SnapLogicJDBCIntegrate TSheets with External Services using SnapLogic
SnowflakeCData SyncAutomated Continuous TSheets Replication to Snowflake
SQL ServerCData SyncAutomated Continuous TSheets Replication to SQL Server
SQL Server Linked ServerConnect CloudConnect to TSheets Data as a SQL Server Linked Server
SQLiteCData SyncAutomated Continuous TSheets Replication to SQLite
TalendJDBCConnect to TSheets and Transfer Data in Talend
UiPath StudioODBCCreate an RPA Flow that Connects to TSheets in UiPath Studio
VerticaCData SyncAutomated Continuous TSheets Replication to a Vertica Database

Back to top

Data Virtualization



Back to top

Software Development


ProductTechnologyArticle Title
.NET ChartsADO.NETDataBind Charts to TSheets
.NET QueryBuilderODBCRapidly Develop TSheets-Driven Apps with Active Query Builder
Angular JSConnect ServerUsing AngularJS to Build Dynamic Web Pages with TSheets
Apache SparkJDBCWork with TSheets in Apache Spark Using SQL
AppSheetConnect CloudCreate TSheets-Connected Business Apps in AppSheet
Bubble.ioConnect CloudBuild TSheets-Connected Apps in Bubble
C++BuilderODBCDataBind Controls to TSheets Data in C++Builder
ChoreoConnect CloudBuild Custom Apps on TSheets Data in Choreo
ColdFusionJDBCQuery TSheets in ColdFusion Using JDBC
ColdFusionODBCQuery TSheets in ColdFusion Using ODBC
DashPythonUse Dash & Python to Build Web Apps on TSheets
DelphiODBCDataBind Controls to TSheets Data in Delphi
DevExpressADO.NETDataBind TSheets to the DevExpress Data Grid
EF - Code FirstADO.NETAccess TSheets with Entity Framework 6
EF - LINQADO.NETLINQ to TSheets
EF - MVCADO.NETBuild MVC Applications with Connectivity to TSheets
Filemaker ProODBCBidirectional Access to TSheets from FileMaker Pro
Filemaker Pro (on Mac)JDBCBidirectional Access to TSheets from FileMaker Pro (on Mac)
GoODBCWrite a Simple Go Application to work with TSheets on Linux
Google Apps ScriptConnect CloudConnect to TSheets Data in Google Apps Script
HibernateJDBCObject-Relational Mapping (ORM) with TSheets Entities in Java
IntelliJJDBCConnect to TSheets in IntelliJ
JBossJDBCConnect to TSheets from a Connection Pool in JBoss
JDBIJDBCCreate a Data Access Object for TSheets using JDBI
JRubyJDBCConnect to TSheets in JRuby
MendixConnect CloudBuild TSheets-Connected Apps in Mendix
Microsoft Power AppsConnect CloudIntegrate Live TSheets Data into Custom Business Apps Built in Power Apps
NodeJSConnect CloudQuery TSheets Data in Node.js (via Connect Cloud)
NodeJSODBCQuery TSheets through ODBC in Node.js
OutSystemsConnect CloudCreate TSheets-Connected Enterprise Applications in OutSystems
PHPConnect ServerAccess TSheets in PHP through Connect Server
PHPODBCNatively Connect to TSheets in PHP
PowerBuilderADO.NETConnect to TSheets from PowerBuilder
PowerShellPowerShellPipe TSheets to CSV in PowerShell
PyCharmODBCUsing the CData ODBC Driver for TSheets in PyCharm
PythonODBCConnect to TSheets in Python on Linux/UNIX
ReactConnect ServerBuild Dynamic React Apps with TSheets Data
RubyODBCConnect to TSheets in Ruby
RunMyProcessConnect CloudConnect to TSheets Data in RunMyProcess
RunMyProcess DSECJDBCConnect to TSheets in DigitalSuite Studio through RunMyProcess DSEC
SAP UI5Connect ServerIntegrate Real-Time Access to TSheets in SAPUI5 MVC Apps
ServoyJDBCBuild TSheets-Connected Apps in Servoy
Spring BootJDBCAccess Live TSheets Data in Spring Boot Apps
SQLAlchemyPythonUse SQLAlchemy ORMs to Access TSheets in Python
TomcatJDBCConfigure the CData JDBC Driver for TSheets in a Connection Pool in Tomcat
UnqorkConnect CloudCreate TSheets-Connected Applications in Unqork
VCL App (RAD Studio)ODBCBuild a Simple VCL Application for TSheets
WebLogicJDBCConnect to TSheets from a Connection Pool in WebLogic

Back to top

Data Management



Back to top

Workflow Automation



Back to top