Teradata Connector - Mule 4
Anypoint Connector for Teradata (Teradata Connector) establishes communication between your Mule app and a Teradata Vantage database, enabling you to connect with your Teradata Vantage instance to load data and run SQL queries in Teradata Vantage tables.
Reference: Teradata Connector Reference
Release Notes: Teradata Connector Release Notes
Before You Begin
To use this connector, you must be familiar with:
-
Teradata Vantage SQL
-
Anypoint Connectors
-
Mule runtime engine (Mule)
-
Elements and global elements in a Mule flow
-
Anypoint Studio (Studio)
Before creating an app, you must have:
-
Anypoint Studio version 7.5 or later
-
Credentials to access the Teradata Vantage target resource
| If you need a test instance of Vantage, you can provision one for free at https://clearscape.teradata.com. |
Common Use Cases for the Connector
Teradata Connector enables you to:
-
Perform predefined queries, dynamically constructed queries, and template queries that are self-sufficient and customizable.
-
Use a source listener operation to read from a database in the data source section of a flow.
-
Execute other operations to read and write to a database anywhere in the process section.
-
Run a single bulk update to perform multiple SQL requests.
-
Make Data Definition Language (DDL) requests.
-
Execute stored procedures and SQL scripts.
The Teradata Connector supports:
-
Connection pooling
-
Auto reconnects after timeouts
Examples
After you complete the prerequisites, you can try the examples and configure the connector using Anypoint Studio.