Data Source- Database
Opting for database as a data source in integration involves establishing a connection between the application and the database, enabling seamless interaction and data exchange. The various storages available in eZintegrations are: Amzon Aurora (mySQL/Maria), Amazon Aurora (PostgreSQL), Amazon Red Shift, Microsoft SQL Server, MySQL Maria, Oracle Database, PostgreSQL, Snowflake, SQLite, Teradata DB.
After successful login users and initiating creation of integration bridge, users will have to follow the steps mentioned below to have database as their data source.
Source Type-
Upon selecting "Source Type," users will be presented with a dropdown menu where they can select for "Database".
Select Storage Name-
Proceed by choosing the Storage Name, which will prompt a subsequent dropdown presenting multiple options for users to select the specific storage they require.
Version-
After selecting the Storage Name, users will encounter an additional dropdown menu for choosing the version corresponding to the previously selected Storage Name.
Host IP-
The user can input the host IP address associated with their database to ensure proper connectivity.
Port Number-
The user can specify the port number relevant to their database for establishing the connection.
Schema Name-
User Name-
The user is required to input their database-associated username for authentication purposes
Password-
The user needs to provide the password associated with their database for authentication and access purposes.
Chunks Size-
The default size for streaming records from Bizintel360 Data Lake is 1000, ideal for efficient real-time processing. It can be increased to a maximum of 10,000 records for one-time historical data loads.
Response parameter-
The user configures response parameters for each status code that integration returns. Response parameters are a key-value map. The key identifies the location of the request parameter to change, and how to change it. The value specifies the new data for the parameter.
SQL Statement-
Upon completing the required information above, users can provide their SQL query in the designated section following the provided instructions.
Execute-
Once the SQL query is written, users can execute it by selecting the "Execute" option located at the top of the page.
Response-
Users can review the outcome of their SQL query in the response section. If the displayed result aligns with their expectations, they can proceed to the Data Operation section by selecting the "Next" option located at the bottom of the page.