This section provides you the details on various fields required to configure JDBC in Data Integrity Suite.
| Field | Description |
|---|---|
| Name | Specifies the name of data connection. This is a mandatory field. Example: JDBCDataConnection |
| Description | Allows you to describe the purpose of this data connection. Example: Connection to the customer database for data analysis. |
| Agent | Select the agent from the drop down list that will be responsible for managing the JDBC connection. Example: Agent1 |
| JDBC bundle name | Specify the name of the JDBC bundle that contains necessary drivers for the desired connection. This is the same as the driver display name given while uploading the driver. Example: MyJDBCDriver |
| JDBC URL | Specify the JDBC connection string that contains parameters required to connect database using a JDBC driver. This should be accurately entered, ensuring it aligns with the correct database and its corresponding location. Example: jdbc:mysql://localhost:3306/mydatabase |
| Additional Parameters | Secifies the parameters to configure the JDBC connection. These parameters include options for connection URLs, authentication, and more. Click + Add to include properties in the connection setup.
|
These JDBC connection settings allow you to configure access to a database using a JDBC driver. The key fields are the connection name for identification, JDBC bundle to provide the driver, JDBC URL to point to the database, and username/password for authentication. These mandatory settings enable establishing a connection from agent to the desired database through JDBC driver.