Database Service

The Database Service provides a connection to a database server. A typical iWD solution has one defined database connection for historical-reporting data (iWD Data Mart).  

The configured database and user must exist in the database server. The creation and upgrade of database structures are handled automatically by iWD; so, besides the read/write permissions, the database user also must be able to create and alter tables and views (plus sequences and triggers for Oracle).

In addition to the options described in Service Details, the following properties are configurable for the Database Service:

startAutomatically

Indicates whether the service should be started automatically after the configuration deployment.

logLevel

The Service log level. This should be set to Default unless otherwise instructed by Genesys Technical Support. See "Service Log Levels" for a description of each log level. Depending on the setting of this property, additional logging properties might be available. Refer to "Logging Service" for descriptions of these common properties.

DatabaseType

The type of the database server. Refer to the Genesys Supported Operating Environment Reference Manual for supported databases. Depending on which database type is selected, additional properties are displayed.

ServerName

The host name of the database server.

MysqlServerPort

The TCP port of the MySQL database server. This is available only when the DatabaseType is MySQL.

SqlServerCustomURL

If selected, the connection is configured by specifying a custom MS SQL JDBC URL. This option is available only when the DatabaseType is MS SQL Server.

SqlServerJDBCURL

The JDBC connection URL for MS SQL. This option is available when SqlServerCustomURL is selected.

SqlServerPort

The TCP port of the MS SQL database server. This option is available only when the DatabaseType is MS SQL Server.

DatabaseName

The name of the database.  This is available only when the DatabaseType is MySQL or MS SQL Server.

OracleCustomURL

If this is checked, the connection is configured by specifying a custom Oracle JDBC URL. This option is available only when the DatabaseType is Oracle.

OracleJDBCURL

The JDBC connection URL for Oracle. This option is available when OracleCustomURL is checked.

OracleServerPort

The TCP port of the Oracle database server. This option is available only when the DatabaseType is Oracle.

OracleSID

Oracle System ID of the database. The Oracle System ID (SID) is used to uniquely identify a particular database on a system.

Username

The database user name.

Password

The password for the database.

AutoSynchronize

If checked, iWD will try to initialize/upgrade database structure automatically.