Overview
Using a Database as a Data Source in eZintegrations enables secure connectivity between the platform and your database system for seamless data retrieval and integration.
This configuration allows structured data to be queried using SQL and streamed into the Integration Bridge pipeline in JSON format.
Supported database storages include:
- Amazon Aurora (MySQL/MariaDB)
- Amazon Aurora (PostgreSQL)
- Amazon Redshift
- Microsoft SQL Server
- MySQL MariaDB
- Oracle Database
- PostgreSQL
- Snowflake
- SQLite
- Teradata DB
When to Use
Use Database as a Source when structured relational data needs to be integrated into downstream systems.
- Extracting transactional data
- Synchronizing master records
- Performing data migrations
- Loading historical datasets
- Supporting reporting workflows
How It Works
The Database Source establishes a secure connection using provided credentials and host information.
Once connected, SQL queries retrieve records, which are then streamed into the Integration Bridge for transformation and delivery.
Steps to Configure Database as Source
Step 1: Select Source Type
Select Database from the Source Type dropdown menu.
Step 2: Select Storage Name
Choose the required storage type from the dropdown list.
Step 3: Select Version
Select the version corresponding to your selected storage.
Step 4: Enter Host IP
Provide the Host IP address of your database server.
Step 5: Enter Port Number
Specify the Port Number used by your database.
Step 6: Enter Schema Name
Provide the Schema Name of the database.
Step 7: Enter User Name
Enter the database User Name for authentication.
Step 8: Enter Password
Provide the Password associated with the database user.
Step 9: Configure Chunk Size
Chunk Size defines the number of records streamed per batch.
- Default: 1000 (recommended for real-time processing)
- Maximum: 10000 (for historical data loads)
Step 10: Configure Response Parameters
Set Response Parameters for each status code. These key-value pairs define how request parameters are modified and what new values are applied.
Step 11: Provide SQL Statement
Enter your SQL query in the designated section.
Step 12: Execute SQL
Click Execute to run the SQL query.
Step 13: Review Response
Review the results in the Response section. If correct, click Next to proceed to Data Operations.
Frequently Asked Questions
What databases are supported in eZintegrations?
Supported databases include Amazon Aurora, Redshift, SQL Server, MySQL, Oracle, PostgreSQL, Snowflake, SQLite, and Teradata.
What is Chunk Size used for?
Chunk Size controls how many records are streamed per batch during data retrieval.
Where is the SQL query executed?
The SQL query is executed directly against the configured database source.
What happens after executing SQL?
The query results are displayed in the Response section and streamed into the integration pipeline.
Can I modify the connection settings later?
Yes. Connection parameters can be edited before finalizing or deploying the Integration Bridge.
Notes
- Ensure database network access is enabled.
- Verify credentials before testing.
- Use optimized SQL queries for better performance.
- Keep Chunk Size at recommended levels for real-time processing.
- Follow SQL best practices for efficient querying.
