Configuration

Connect to your Teradata database and extract data by providing the following configuration parameters:

KeyDescriptionSample Value
databaseThe name of the database you want to read data from.demo
hostHostname or IP address of your Teradata database.test.clearscape.teradata.com
portPort number for the database connection (default is 1025 for Teradata).1025
usernameUsername with permissions to access the database and schema.demo_user
passwordPassword for the user to authenticate.abc123...

Optional Configs

KeyDescriptionSample Value
batch_fetch_limitNumber of rows to fetch per batch (default: 50,000). Adjust based on available memory.50000

What is Teradata?

Teradata is a powerful enterprise-grade relational database management system (RDBMS) optimized for high-performance data warehousing and large-scale analytics. It supports complex queries and advanced analytics across massive datasets.


Why Integrate Teradata with Mage?

  • High-performance analytics: Leverage Teradata’s parallel processing to extract large volumes of data efficiently.
  • Scalable ETL workflows: Integrate Teradata data into your data pipelines for advanced transformation and analysis.
  • Enterprise-ready: Built for high security, reliability, and compliance standards.
  • Batch optimization: Customize batch fetch limits to tune performance based on workload and memory.