JDBC connector enables data to be retrieved from databases such as PostgreSQL, MsSQL, MySQL, and Oracle using JDBC with the operating frequency determined by cron expression. The captured data can then be used for processing purposes in the integration flow.
JDBC Sender
JDBC Name: The name of the previously defined database to which you want to connect is written.
JDBC Query: JDBC query refers to SQL (Structured Query Language) queries sent to the database via JDBC. SQL queries are used to perform operations such as retrieving data from the database, adding, updating or deleting data.
Return As: It is determined which type the result obtained from the query will be returned, it can be returned in JSON, CSV or XML types.
Scheduler – JDBC Polling: This variable allows determining the working interval and frequency of the defined JDBC Sender service in Cron expression. Cron expression is used to schedule tasks to run at specific intervals or on specific dates and times.
JDBC Receiver
JDBC Name: The name of the previously defined database to which you want to connect is written.
JDBC Query: JDBC query refers to SQL (Structured Query Language) queries sent to the database via JDBC. SQL queries are used to perform operations such as retrieving data from the database, adding, updating or deleting data.
Return As: It is determined which type the result obtained from the query will be returned, it can be returned in JSON, CSV or XML types.
Get in touch with us to kickstart your integration journey.