Configuration

To use JDBC connector, contact your Unica administrator. The administrator will configure a connection for you.

To configure a connection, the Unica administrator must configure a few connection properties. The connection properties are listed in the following table:

Table 1. Connection properties to configure a JDBC connector
Property	Description
`URL`	The URL used to connect to the database. it should contain the connection string. For example: MYSQL: jdbc:mysql://Server Name/Server IP>:<Port>/<DB name> Oracle: jdbc:oracle:thin:@<Server Name/ Server IP>:<PORT>:<Oracle service name> where `thin` is the driver, `<Server Name/ Server IP>` on which oracle is running, `<PORT>` is the port number and `<Oracle service name>` is the Oracle service name.
`User`	Username of the database on which you want to perform the operation.
`Password`	Password of the database on which you want to perform the operation.
`Driver`	Specify the driver class name. Driver name for MySq: `com.mysql.cj.jdbc.Driver` Driver name for Oracle: `oracle.jdbc.driver.OracleDriver`

Note:

To perform update operation on a record in the database table, you need a primary key (the primary key is a column, or set of columns, whose values uniquely identify each row in the table) in the table, which helps in updating the existing record in the table.
JDBC connector has the batch size of 10 with each batch containing 10,000 records.
JDBC connector supports Unica Journey and not Unica Campaign.
Logs are generated and stored in the assigned location.