Interact | ETL | patternStateETL | <patternStateETLName> | RuntimeDS

A list of the supported database types for the data source you are defining.

The JNDI name of the data source. This name must also be used in the user's data source configuration to ensure that the user has access to the target and runtime data sources.

The name of the JDBC driver to us, such as any of the following:

Oracle: oracle.jdbc.OracleDriver

Microsoft SQL Server: com.microsoft.sqlserver.jdbc.SQLServerDriver

IBM DB2: com.ibm.db2.jcc.DB2Driver

MariaDB: org.mariadb.jdbc.Driver

The data source URL, such as any of the following:

Oracle: jdbc:oracle:thin:@ <your_db_host>:<your_db_port>:<your_db_service_name>

Microsoft SQL Server: jdbc:sqlserver:// <your_db_host>:<your_db_port> ;databaseName= <your_db_name>

IBM DB2: jdbc:db2:// <your_db_host>:<your_db_port>/<your_db_name>

MariaDB: jdbc:mariadb:// <your_db_host>:<your_db_port>/<your_db_name>

A value indicating the size of the connection pool, provided for performance tuning. Pattern state data is read and transformed concurrently depending upon the available database connections. Increasing the connection pool size allows for more concurrent database connections, subject to limitations of memory and database read/write capabilities. For example, if this value is set to 4, four jobs will run concurrently. If you have a large amount of data, you might need to increase this value to a number such as 10 or 20, as long as sufficient memory and database performance is available.

The name of the database schema to which this configuration is connecting.

The ConnectionRetryPeriod property specifies the amount of time in seconds Unica Interact automatically retries the database connection request on failure. Unica Interact automatically tries to reconnect to the database for this length of time before reporting a database error or failure. If the value is set to 0, Unica Interact retries indefinitely; if the value is set to -1, no retry is attempted.

The ConnectionRetryDelay property specifies the amount of time in seconds Unica Interact waits before it tries to reconnect to the database after a failure. If the value is set to -1, no retry is attempted.