InteractDT | partition | partition[n] | dataSources

The properties in InteractDT|partitions|partition[n]|dataSources determine how Unica InteractDT interacts with databases, including its own system tables, for the specified partition.

These properties specify the databases that Unica InteractDT can access and they control many aspects of how queries are formed.

Each data source that you add in Unica InteractDT is represented by a category under InteractDT|partitions|partition[n]|dataSources|<data-source-name>.

Note: The Unica InteractDT system tables data source for each partition must be named UA_SYSTEM_TABLES in Unica Platform, and every Unica InteractDT partition must have a dataSources | UA_SYSTEM_TABLES category on the Configuration page.

New category name

Description
Use the New category name field when you create a data source using provided template. Enter a category name to identify the data source. After you save a new category, it appears in the navigation tree. You can change its properties as needed.
Default value
-

JndiName

Description
Set its value to the Java Naming and Directory Interface (JNDI) data source that you created in your application server to connect to this data source.
Default value
-
Valid Values
DB2 | ORACLE | SQLServer | OneDB | MariaODBC

Type

Description
This property specifies the database type of this data source.
Default value

schemaName

Description
Use this property to limit the table mapping display in Unica InteractDT to tables in a specified schema. For example, to specify tables in the schema dbo, set schemaName=dbo.
Default value

NumberOfRetries

Description
The NumberOfRetries property specifies the number of times Unica InteractDT automatically retries a database operation on failure. Unica InteractDT automatically resubmits queries to the database this number of times before reporting a database error or failure.
Default value
0 (zero)