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

  • 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.