Read from Database Sources

Database Read Components connect to relational databases and extract data for your pipelines. They support various databases and offer features like incremental loading, CDC (Change Data Capture), and flexible querying to efficiently bring data into your Data Plane.

Before you begin

• Ensure you have an Ascend Project and Workspace
• Set up the appropriate database Connection for your source

Database Read guides

🐬MySQL

Read data from MySQL databases with support for incremental loading and CDC.

Start building

🐘PostgreSQL

Connect to PostgreSQL databases and extract data incrementally.

Start building

🏢Microsoft SQL Server

Read from SQL Server databases with incremental and CDC capabilities.

Start building

🔶Oracle

Extract data from Oracle databases with incremental loading support.

Start building

Next steps

After setting up database reads:

• 🔄 Transform your data with SQL or Python
• 📤 Write data to destinations
• 🧪 Add data tests to validate data quality
• 🔄 Set up Automations to schedule regular extractions