Ready to get started?

Learn more:

Teradata Connectivity Solutions

Teradata Integration Guides and Tutorials



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

CData Software's connectivity tools enable users to connect directly to live Teradata 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 Teradata 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 Teradata in Alteryx Designer (ODBC)
Amazon QuickSightConnect ServerBuild Interactive Dashboards from Teradata Data in Amazon QuickSight
Aqua Data StudioJDBCConnect to Teradata in Aqua Data Studio
AWS DatabricksJDBCProcess & Analyze Teradata Data in Databricks (AWS)
BirstJDBCBuild Visualizations of Teradata in Birst
BIRTJDBCDesign BIRT Reports on Teradata
Clear AnalyticsODBCBuild Charts with Teradata in Clear Analytics
DBxtraODBCBuild Dashboards with Teradata in DBxtra
DomoODBCCreate Datasets from Teradata in Domo Workbench
Dundas BIODBCBuild Dashboards with Teradata in Dundas BI
Excel (on Mac OS)ODBCWork with Teradata Data in MS Excel on Mac OS X
FineReportJDBCFeed Teradata into FineReport
IBM Cognos BIODBCCreate Data Visualizations in Cognos BI with Teradata
Infragistics RevealConnect ServerAnalyze Teradata Data in Infragistics Reval
JasperServerJDBCCreate Teradata Reports on JasperReports Server
Jaspersoft BI SuiteJDBCConnect to Teradata in Jaspersoft Studio
JReport DesignerJDBCIntegrate with Teradata in JReport Designer
KlipfolioConnect ServerCreate Teradata-Connected Visualizations in Klipfolio
KNIMEJDBCEnable the Teradata JDBC Driver in KNIME
LINQPadADO.NETWorking with Teradata in LINQPad
Microsoft SSASADO.NETBuild an OLAP Cube in SSAS from Teradata
MicroStrategyConnect ServerConnect to Live Teradata Data in MicroStrategy through Connect Server
MicroStrategyJDBCUse the CData JDBC Driver for Teradata in MicroStrategy
Microstrategy DesktopJDBCUse the CData JDBC Driver for Teradata in MicroStrategy Desktop
Microstrategy WebJDBCUse the CData JDBC Driver for Teradata in MicroStrategy Web
OBIEEJDBCTeradata Reporting in OBIEE with the Teradata JDBC Driver
pandasPythonUse pandas to Visualize Teradata in Python
Pentaho Report DesignerJDBCIntegrate Teradata in the Pentaho Report Designer
Power BI DesktopPower BIAuthor Power BI Reports on Real-Time Teradata
Power BI ServiceConnect ServerVisualize Live Teradata Data in the Power BI Service
Power PivotConnect ServerAccess Teradata Data in Microsoft Power Pivot
Power QueryConnect ServerAccess Teradata Data in Microsoft Power Query
Qlik CloudConnect ServerCreate Apps from Teradata Data in Qlik Sense Cloud
QlikViewODBCConnect to and Query Teradata in QlikView over ODBC
RJDBCAnalyze Teradata in R (JDBC)
RODBCAnalyze Teradata in R (ODBC)
RapidMinerJDBCConnect to Teradata in RapidMiner
RedashConnect ServerBuild Teradata-Connected Dashboards in Redash
SAP Analytics CloudConnect ServerAnalyze Teradata Data in SAP Analytics Cloud
SAP Business ObjectsJDBCCreate an SAP BusinessObjects Universe on the CData JDBC Driver for Teradata
SAP Crystal ReportsJDBCPublish Reports with Teradata in Crystal Reports
SASODBCUse the CData ODBC Driver for Teradata in SAS for Real-Time Reporting and Analytics
SAS JMPODBCUse the CData ODBC Driver for Teradata in SAS JMP
SisenseJDBCVisualize Live Teradata in Sisense
Spago BIJDBCConnect to Teradata in SpagoBI
TableauTableauVisualize Teradata in Tableau Desktop
Tableau CloudConnect ServerBuild Teradata Visualizations in Tableau Cloud
Tableau ServerTableauPublish Teradata-Connected Dashboards in Tableau Server
TIBCO SpotfireADO.NETVisualize Teradata in TIBCO Spotfire through ADO.NET
TIBCO SpotfireConnect ServerVisualize Teradata Data in TIBCO Spotfire
TIBCO Spotfire ServerJDBCOperational Reporting on Teradata from Spotfire Server
VisioODBCLink Visio Shapes to Teradata

Back to top

ETL & Replication


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

Back to top

Data Virtualization



Back to top

Software Development


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

Back to top

Data Management



Back to top

Workflow Automation



Back to top