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. |