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:
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:
Driver
name for Oracle:
|
- 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.