Skip to main content

JDBC Sender Connector

It enables data to be retrieved from databases such as PostgreSql, MsSQL, MySQL, 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.

Required Connector Properties​

  • JDBC Name: Specify the JDBC name to connect to by providing the required information, which was previously configured in JDBC Destinations.
Note

To acquire comprehensive guidance on defining an JDBC Destination, please refer to the JDBC Destinations section. This section offers detailed instructions and insights into the process, ensuring clarity and effectiveness in setting up JDBC Destinations.

  • 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.