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
🐘 PostgreSQL
Connect to PostgreSQL databases and extract data incrementally
🏢 Microsoft SQL Server
Read from SQL Server databases with incremental and CDC capabilities
🔶 Oracle
Extract data from Oracle databases with incremental loading support
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