JDBC Connector
It is used to access databases and perform database operations.
Service Description
There are two component options for configuring a connector to communicate with JDBC:
- JDBC Receiver Connector
- JDBC Sender Connector
JDBC stands for Java Database Connectivity. It is a Java-based API (Application Programming Interface) that allows Java applications to interact with relational databases. JDBC provides a standardized way for Java programs to connect to and query databases, as well as update and manipulate the data within them. The general logic of JDBC is to enable Java applications to connect to various databases using a standard interface and run SQL queries on these databases. The JDBC connector provides seamless communication between the integration and the database, allowing SQL queries to be executed. This allows the integration to perform a wide variety of operations, including retrieving, inserting, updating, and deleting data. The versatility of SQL queries through JDBC provides a flexible and efficient means to interact with databases, ensuring robust data management and manipulation capabilities for integrations.
Follow these steps before starting the integration:
- The connection information required to connect to the database must be provided correctly. This information includes information such as database URL, username and password.
- Create the connection for JDBC in the JDBC Destinations tab on the Operations page.