Deliver | partitions | partition[n] | dataSources | systemTables
This category contains configuration properties that define the schema, connection settings, and login credentials for the database that contains the Deliver system tables in your network environment.
type
- Description
-
Type of database that hosts the Deliver system tables.
- Default value
-
No default value defined. You must define this property.
- Valid Values
-
-
SQLSERVER
-
ORACLE
-
DB2
MARIADB
ONEDB
-
schemaName
- Description
-
Name of the database schema for the Deliver system tables. This is the same as the schema name for the Campaign system tables.
You must include this schema name when referencing system tables in scripts.
- Default value
-
dbo
jdbcBatchSize
- Description
-
The number of execution requests JDBC runs on the database at a time.
- Default value
-
10
- Valid Values
-
An integer greater than 0.
jdbcClassName
- Description
-
JDBC driver for system tables as defined in your Campaign web server.
- Default value
-
No default value defined. You must define this property.
jdbcURI
- Description
-
JDBC connection URI for system tables as defined in your Campaign web server.
- Default value
-
No default value defined. You must define this property.
asmUserForDBCredentials
- Description
-
Use this property to specify an Unica user that will be allowed to access the Campaign system tables.
- Default value
-
No default value defined. You must define this property.
- Valid Values
-
Any user defined in the Unica Platform. This should typically be the name of the system user for Campaign
amDataSourceForDBCredentials
- Description
-
Use this property to specify the data source that defines login credentials for the database that contains the Deliver system tables. This can be the same as the data source for the Deliver system tables.
- Default value
-
UA_SYSTEM_TABLES
- Valid Values
-
A Unica Platform data source associated with the Unica user you specify in asmUserForDBCredentials
The data source specifies a database user and credentials used to access the Deliver system tables. If the default schema for the database user is not the schema that contains the system tables you must specify the system table schema in the JDBC connection used to access the system tables.
poolAcquireIncrement
- Description
-
When the database connection pool runs out of connections, the number of new connections Deliver creates for the system tables. Deliver creates new connections up to the number specified in poolMaxSize.
- Default value
-
1
- Valid Values
-
An integer greater than 0.
poolIdleTestPeriod
- Description
-
The number of seconds Deliver waits between testing idle connections to the Deliver system tables for activity.
- Default value
-
100
- Valid Values
-
An integer greater than 0.
poolMaxSize
- Description
-
The maximum number of connections Deliver makes to the system tables. A value of zero (0) indicates there is no maximum.
- Default value
-
100
- Valid Values
-
An integer greater than or equal to 0.
poolMinSize
- Description
-
The minimum number of connections Deliver makes to the system tables.
- Default value
-
10
- Valid Values
-
An integer greater than or equal to 0.
poolMaxStatements
- Description
-
The maximum number of statements that Deliver stores in the PrepareStatement cache per connection to the system tables. Setting poolMaxStatements to zero (0) disables statement caching.
- Default value
-
0
- Valid Values
-
An integer equal to or greater than 0.
timeout
- Description
-
The number of seconds Deliver maintains an idle database connection before dropping the connection.
If poolIdleTestPeriod is greater than 0, Deliver tests all idle, pooled, but unchecked-out connections, every timeout number of seconds.
If poolIdleTestPeriod is greater than timeout, the idle connections are dropped.
- Default value
-
100
- Valid Values
-
An integer equal to or greater than 0.