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.
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 Provide a value if you have installed multiple DB drivers. Specify the driver class name.
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.