JDBC Destinations
JDBC destinations refer to configuration points that contain the information required for integrations to connect to databases. This configuration information includes basic information such as the JDBC driver, username, password and database connection URL.
| Field | Description |
|---|---|
| Name | JDBC Destination Name |
| Driver | The JDBC driver is the driver used to connect the integration to a specific database management system (DBMS). Every database system has its own JDBC driver. For example, drivers such as "com.mysql.jdbc.Driver" for MySQL and "org.postgresql.Driver" for PostgreSQL can be used. This driver provides the interfaces necessary for the integration to communicate with the relevant database. |
| Connection String (URL) | The URL used to connect to the database typically points to a schema supported by the JDBC driver and the location of the database. For example, a URL for a MySQL database might be: "jdbc:mysql://localhost:3306/databasename". This URL aims to connect to the MySQL server running on localhost and the database named "databasename". |
| Username | Represents the username used to connect to the database. This is a user account associated with access rights to the database. The integration logs into the database with the specified username and can perform operations that this user is allowed to do. |
| Password | It is the password used to connect to the database, together with the user name. Password is the login information for a specific username. This password authorizes access to the database and must be kept secret for security purposes. Therefore, the password is specified along with the username when creating JDBC destinations. |
JDBC destinations contain this basic information and allow integrations to connect to a specific database using this information. In this way, the integration can communicate with the database, send queries, update data or pull data. Once the connection information is provided correctly, the integration can interact with the database and manage the data in the database. To utilize the specified JDBC destination name, simply input it into the 'JDBC Name' field within both the JDBC sender and receiver connectors within the integration setup. This ensures seamless connectivity and communication between components, streamlining data transfer through the designated JDBC destination.
Defined JDBC Destination can use with JDBC Connector and MongoDB Connector.
Clicking the three dots under the "Action" heading offers the following options:
- Where Use Database: Lists the flows where the relevant database is used.
- Edit Database: Allows changing database details.
- Delete Database: Allows the removal of database.