How to Use a Database as Source in eZintegrations
Opting for a Database as Source in integration involves establishing a connection between the application and the database, enabling seamless interaction and data exchange. Supported storages in eZintegrations include Amazon Aurora (MySQL/MariaDB), Amazon Aurora (PostgreSQL), Amazon Redshift, Microsoft SQL Server, MySQL Maria, Oracle Database, PostgreSQL, Snowflake, SQLite, and Teradata DB.
After successful login and initiating the creation of an integration bridge, follow the steps below to set up a database as your data source.
Source Type
Select Source Type and choose Database from the dropdown menu.
Select Storage Name
Choose the Storage Name from the dropdown to select the specific storage type required.
Version
After selecting the storage name, select the Version corresponding to your storage.
Host IP
Enter the Host IP address of your database for proper connectivity.
Port Number
Specify the Port Number for database connection.
Schema Name
Provide the Schema Name for your database.
User Name
Enter the User Name associated with your database for authentication.
Password
Provide the Password for database access.
Chunks Size
The default size for streaming records from Bizintel360 Data Lake is 1000 for real-time processing. It can be increased up to 10,000 for historical data loads.
Response Parameter
Configure Response Parameters for each status code. These are key-value pairs specifying how to modify request parameters and the new values.
SQL Statement
Provide your SQL query in the designated section after completing the above steps.
Execute
After writing your SQL query, click Execute to run it.
Response
Review the SQL query results in the response section. If the output is as expected, proceed to the Data Operation section by clicking Next.
For more information on writing efficient SQL queries, refer to SQL Best Practices.
