Learn more
 
Teradata Integration
 

Teradata Drivers & Connectors
for Data Integration

Easy-to-use Drivers for accessing Teradata databases. Easily integrate Teradata data with BI, Reporting, Analytics, ETL Tools, and Custom Solutions.


Decorative Icon Teradata Logo

Other Database Technologies

Other Database Drivers



Connect to Teradata Data from Anywhere!

Easily access live Teradata data from BI, Analytics, Reporting, ETL, & Custom Apps.







Teradata Integration Guides and Tutorials

BI & Analytics


Our drivers offer the fastest and easiest way to connect real-time Teradata data with BI, analytics, reporting and data visualization technologies. They provide unmatched query performance, comprehensive access to Teradata data and metadata, and seamlessly integrate with your favorite analytics tools.

LEARN MORE: Connectivity for BI & Analytics

Popular BI & Analytics Integrations


Alteryx Designer: Prepare, Blend, and Analyze Teradata in Alteryx Designer (ODBC) Amazon QuickSight: Build Interactive Dashboards from Teradata Data in Amazon QuickSight Aqua Data Studio: Connect to Teradata in Aqua Data Studio AWS Databricks: Process & Analyze Teradata Data in Databricks (AWS) Birst: Build Visualizations of Teradata in Birst BIRT: Design BIRT Reports on Teradata Clear Analytics: Build Charts with Teradata in Clear Analytics DBxtra: Build Dashboards with Teradata in DBxtra Domo: Create Datasets from Teradata in Domo Workbench Dundas BI: Build Dashboards with Teradata in Dundas BI Excel (on Mac OS): Work with Teradata Data in MS Excel on Mac OS X FineReport: Feed Teradata into FineReport IBM Cognos BI: Create Data Visualizations in Cognos BI with Teradata Infragistics Reveal: Analyze Teradata Data in Infragistics Reval JasperServer: Create Teradata Reports on JasperReports Server Jaspersoft BI Suite: Connect to Teradata in Jaspersoft Studio JReport Designer: Integrate with Teradata in JReport Designer Klipfolio: Create Teradata-Connected Visualizations in Klipfolio KNIME: Enable the Teradata JDBC Driver in KNIME LINQPad: Working with Teradata in LINQPad Microsoft SSAS: Build an OLAP Cube in SSAS from Teradata MicroStrategy: Connect to Live Teradata Data in MicroStrategy through Connect Server MicroStrategy: Use the CData JDBC Driver for Teradata in MicroStrategy Microstrategy Desktop: Use the CData JDBC Driver for Teradata in MicroStrategy Desktop Microstrategy Web: Use the CData JDBC Driver for Teradata in MicroStrategy Web OBIEE: Teradata Reporting in OBIEE with the Teradata JDBC Driver pandas: Use pandas to Visualize Teradata in Python Pentaho Report Designer: Integrate Teradata in the Pentaho Report Designer Power BI Desktop: Author Power BI Reports on Real-Time Teradata Power BI Service: Visualize Live Teradata Data in the Power BI Service Power Pivot: Access Teradata Data in Microsoft Power Pivot Power Query: Access Teradata Data in Microsoft Power Query Qlik Cloud: Create Apps from Teradata Data in Qlik Sense Cloud QlikView: Connect to and Query Teradata in QlikView over ODBC R: Analyze Teradata in R (JDBC) R: Analyze Teradata in R (ODBC) RapidMiner: Connect to Teradata in RapidMiner Redash: Query, Visualize, and Share live Teradata Data in Redash SAP Analytics Cloud: Analyze Teradata Data in SAP Analytics Cloud SAP Business Objects: Create an SAP BusinessObjects Universe on the CData JDBC Driver for Teradata SAP Crystal Reports: Publish Reports with Teradata in Crystal Reports (JDBC) SAS: Use the CData ODBC Driver for Teradata in SAS for Real-Time Reporting and Analytics SAS JMP: Use the CData ODBC Driver for Teradata in SAS JMP Sisense: Visualize Live Teradata in Sisense Spago BI: Connect to Teradata in SpagoBI Tableau: Visualize Teradata in Tableau Desktop Tableau: Visualize Teradata in Tableau Desktop (Connect Server) Tableau Cloud: Build Teradata Visualizations in Tableau Cloud Tableau Server: Publish Teradata-Connected Dashboards in Tableau Server TIBCO Spotfire: Visualize Teradata in TIBCO Spotfire through ADO.NET TIBCO Spotfire: Visualize Teradata Data in TIBCO Spotfire TIBCO Spotfire Server: Operational Reporting on Teradata from Spotfire Server Visio: Link Visio Shapes to Teradata

ETL, Replication, & Warehousing


From drivers and adapters that extend your favorite ETL tools with Teradata connectivity to ETL/ELT tools for Teradata data integration — our Teradata integration solutions provide robust, reliable, and secure data movement.

Connect your RDBMS or data warehouse with Teradata to facilitate operational reporting, offload queries and increase performance, support data governance initiatives, archive data for disaster recovery, and more.


Popular Data Warehousing Integrations


Amazon Redshift: Automated Continuous Teradata Replication to Amazon Redshift Amazon S3: Automated Continuous Teradata Replication to Amazon S3 Apache Airflow: Bridge Teradata Connectivity with Apache Airflow Apache Camel: Integrate with Teradata using Apache Camel Apache Cassandra: Automated Continuous Teradata Replication to Apache Cassandra Apache Kafka: Automated Continuous Teradata Replication to Apache Kafka Apache NiFi: Bridge Teradata Connectivity with Apache NiFi Apache NiFi Batch Operations: Perform Batch Operations with Teradata Data in Apache NiFi Azure Data Lake: Automated Continuous Teradata Replication to Azure Data Lake Azure Synapse: Automated Continuous Teradata Replication to Azure Synapse BIML: Use Biml to Build SSIS Tasks to Replicate Teradata to SQL Server CloverDX: Connect to Teradata in CloverDX (formerly CloverETL) Couchbase: Automated Continuous Teradata Replication to Couchbase CSV: Automated Continuous Teradata Replication to Local Delimited Files Databricks: Automated Continuous Teradata Replication to Databricks ETL Validator: How to Work with Teradata in ETL Validator FoxPro: Work with Teradata in FoxPro Google AlloyDB: Automated Continuous Teradata Replication to Google AlloyDB Google BigQuery: Automated Continuous Teradata Replication to Google BigQuery Google Cloud SQL: Automated Continuous Teradata Replication to Google Cloud SQL Google Data Fusion: Build Teradata-Connected ETL Processes in Google Data Fusion Heroku / Salesforce Connect: Replicate Teradata for Use in Salesforce Connect HULFT Integrate: Connect to Teradata in HULFT Integrate IBM DB2: Automated Continuous Teradata Replication to IBM DB2 Informatica Cloud: Integrate Teradata in Your Informatica Cloud Instance Informatica PowerCenter: Create Informatica Mappings From/To a JDBC Data Source for Teradata Jaspersoft ETL: Connect to Teradata in Jaspersoft Studio Microsoft Access: Automated Continuous Teradata Replication to Microsoft Access Microsoft Azure Tables: Automated Continuous Teradata Replication to Azure SQL Microsoft Excel: Transfer Data from Excel to Teradata Microsoft Power Automate: Build Teradata-Connected Automated Tasks with Power Automate (Desktop) MongoDB: Automated Continuous Teradata Replication to MongoDB MySQL: Automated Continuous Teradata Replication to MySQL Oracle Data Integrator: ETL Teradata in Oracle Data Integrator Oracle Database: Automated Continuous Teradata Replication to Oracle petl: Extract, Transform, and Load Teradata in Python PostgreSQL: Automated Continuous Teradata Replication to PostgreSQL Replicate to MySQL: Replicate Teradata to MySQL with PowerShell SAP HANA: Automated Continuous Teradata Replication to SAP HANA SingleStore: Automated Continuous Teradata Replication to SingleStore SnapLogic: Integrate Teradata with External Services using SnapLogic (JDBC) Snowflake: Automated Continuous Teradata Replication to Snowflake SQL Server: Automated Continuous Teradata Replication to SQL Server SQL Server Linked Server: Connect to Teradata Data as a SQL Server Linked Server SQLite: Automated Continuous Teradata Replication to SQLite Talend: Connect to Teradata and Transfer Data in Talend UiPath Studio: Create an RPA Flow that Connects to Teradata in UiPath Studio Vertica: Automated Continuous Teradata Replication to a Vertica Database

Workflow & Automation Tools


Connect to Teradata from popular data migration, ESB, iPaaS, and BPM tools.

Our drivers and adapters provide straightforward access to Teradata data from popular applications like BizTalk, MuleSoft, SQL SSIS, Microsoft Flow, Power Apps, Talend, and many more.

Popular Workflow & Automation Tool Integrations


MuleSoft Anypoint: Access Teradata in Anypoint Using SQL Nintex Workflow Cloud: Build Teradata-Connected Workflows in Nintex Power Automate: Integrate Teradata Data into Power Automate Automated Tasks SSIS Export: Export Data from SQL Server to Teradata through SSIS SSIS Import: Import Teradata Data into SQL Server using SSIS SSIS Lookup: Insert New or Update Existing Teradata Records from SQL Server

Developer Tools & Technologies


The easiest way to integrate with Teradata from anywhere. Our Teradata drivers offer a data-centric model for Teradata that dramatically simplifies integration — allowing developers to build higher quality applications, faster than ever before. Learn more about the benefits for developers:



Popular Developer Integrations


AWS Lambda: Access Live Teradata Data in AWS Lambda .NET Charts: DataBind Charts to Teradata .NET QueryBuilder: Rapidly Develop Teradata-Driven Apps with Active Query Builder Angular JS: Using AngularJS to Build Dynamic Web Pages with Teradata Apache Spark: Work with Teradata in Apache Spark Using SQL AppSheet: Create Teradata-Connected Business Apps in AppSheet C++Builder: DataBind Controls to Teradata Data in C++Builder ColdFusion: Query Teradata in ColdFusion Using JDBC ColdFusion: Query Teradata in ColdFusion Using ODBC Dash: Use Dash & Python to Build Web Apps on Teradata Delphi: DataBind Controls to Teradata Data in Delphi DevExpress: DataBind Teradata to the DevExpress Data Grid EF - Code First: Access Teradata with Entity Framework 6 EF - LINQ: LINQ to Teradata EF - MVC: Build MVC Applications with Connectivity to Teradata Filemaker Pro: Bidirectional Access to Teradata from FileMaker Pro Filemaker Pro (on Mac): Bidirectional Access to Teradata from FileMaker Pro (on Mac) Go: Write a Simple Go Application to work with Teradata on Linux Google Apps Script: Connect to Teradata Data in Google Apps Script Hibernate: Object-Relational Mapping (ORM) with Teradata Entities in Java IntelliJ: Connect to Teradata in IntelliJ JBoss: Connect to Teradata from a Connection Pool in JBoss JDBI: Create a Data Access Object for Teradata using JDBI JRuby: Connect to Teradata in JRuby Mendix: Build Teradata-Connected Apps in Mendix (JDBC) Microsoft Power Apps: Integrate Live Teradata Data into Custom Business Apps Built in Power Apps NodeJS: Query Teradata Data in Node.js (via Connect Server) NodeJS: Query Teradata through ODBC in Node.js PHP: Access Teradata in PHP through Connect Server PHP: Natively Connect to Teradata in PHP PowerBuilder: Connect to Teradata from PowerBuilder PowerShell: Pipe Teradata to CSV in PowerShell PyCharm: Using the CData ODBC Driver for Teradata in PyCharm Python: Connect to Teradata in Python on Linux/UNIX React: Build Dynamic React Apps with Teradata Data Ruby: Connect to Teradata in Ruby RunMyProcess: Connect to Teradata Data in RunMyProcess RunMyProcess DSEC: Connect to Teradata in DigitalSuite Studio through RunMyProcess DSEC SAP UI5: Integrate Real-Time Access to Teradata in SAPUI5 MVC Apps Servoy: Build Teradata-Connected Apps in Servoy Spring Boot: Access Live Teradata Data in Spring Boot Apps SQLAlchemy: Use SQLAlchemy ORMs to Access Teradata in Python Tomcat: Configure the CData JDBC Driver for Teradata in a Connection Pool in Tomcat Unqork: Create Teradata-Connected Applications in Unqork VCL App (RAD Studio): Build a Simple VCL Application for Teradata WebLogic: Connect to Teradata from a Connection Pool in WebLogic


When Only the Best Teradata Drivers Will Do

See what customers have to say about our products and support.



Frequently Asked Teradata Driver Questions

Learn more about Teradata drivers & connectors for data and analytics integration


Many organizations draw attention to their library of connectors. After all, data connectivity is a core capability needed for applications to maximize their business value. However, it is essential to understand exactly what you are getting when evaluating connectivity. Some vendors are happy to offer connectors that implement basic proof-of-concept level connectivity. These connectors may highlight the possibilities of working with Teradata, but often only provide a fraction of capability. Finding real value from these connectors usually requires additional IT or development resources.

Unlike these POC-quality connectors, every CData Teradata driver offers full-featured Teradata data connectivity. The CData Teradata drivers support extensive Teradata integration, providing access to all of the Teradata data and meta-data needed by enterprise integration or analytics projects. Each driver contains a powerful embedded SQL engine that offers applications easy and high-performance access to all Teradata data. In addition, our drivers offer robust authentication and security capabilities, allowing users to connect securely across a wide range of enterprise configurations. Compare drivers and connectors to read more about some of the benefits of CData's driver connectivity.

The Teradata drivers and connectors offer comprehensive access to Teradata data. Our Teradata driver exposes static and dynamic data and metadata, providing universal access to Teradata data for any enterprise analytics or data mangement use. To explore the Teradata driver data model, please review the edition-specific Teradata driver documentation.

Using the CData Teradata drivers and connectors, Teradata can be easily integrated with almost any application. Any software or technology that can integrate with a database or connect with standards-based drivers like ODBC, JDBC, ADO.NET, etc., can use our drivers for live Teradata data connectivity. Explore some of the more popular Teradata data integrations online.

Teradata Analytics is universally supported for BI and data science. In addition, CData provides native client connectors for popular analytics applications like Power BI, Tableau, and Excel that simplify Teradata data integration. Additionally, native Python connectors are widely available for data science and data engineering projects that integrate seamlessly with popular tools like Pandas, SQLAlchemy, Dash, and Petl.

Teradata data integration is typically enabled with CData Sync, a robust any-to-any data pipeline solution that is easy to set up, runs everywhere, and offers comprehensive enterprise-class features for data engineering. CData Sync makes it easy to replicate Teradata data any database or data warehouse, and maintain parity between systems with automated incremental Teradata replication. In addition, our Teradata drivers and connectors can be easily embedded into a wide range of data integration tools to augment existing solutions.

Absolutely. CData offers native Excel Add-Ins for Teradata integration. These Add-Ins provide live access to Teradata data directly from Microsoft Excel.



Industry-Leading Support

Support is not just a part of our business, support is our business. Whenever you need help, please consult the resources below:

Product documentation
Get support