Skip to main content

JDBC Receiver Connector

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