14.1 Database
- Billy Sewell (Unlicensed)
The database section of theProperties File specifies parameters used by ServiceSWAT to connect to the ServiceOptimizer database instance. During installation the database section is edited so that the choice of database removes any fields which are Oracle or MSSQL Server specific. Note below is the full list of fields which will not be the same as an installed version of the file.
As part of the installation process the ServiceSWAT properties file will need to be updated to reflect the instance of ServiceScheduling and the SWAT Database instance that SWAT will be using.
Parameter | Description |
|---|---|
| Oracle TNS entry for database. |
| Oracle database username for ServiceScheduling DB. |
| Oracle database password for ServiceScheduling DB. |
| Oracle DBA user – only used for importing DB – can be left blank if this is not used page is available. |
| Oracle DBA password – only used for importing DB – can be left blank if this is not used. |
| Oracle database username for the console tables assumes on same server as ServiceScheduling DB. |
| Oracle database username for the console tables assumes on same server as ServiceScheduling DB. |
| Oracle database tablespace where schema resides – only used for importing DB – can be left blank if this is not used page is available. |
| Oracle - The role to give to the schema user once created – only used for importing DB – can be left blank if this is not used page is available. |
| Oracle - On import is the user being dropped and recreated (set to import) or does the user remain in place (set to datapump). |
| Indicates whether the installation is for Oracle or SQL Server. Values are MSSQL or ORACLE (note field is case sensitive). |
| Host and instance name of swat database. Note this parameter is SQL Server specific and is not required for Oracle. |
| Database instance where the scheduling database is installed. Note this parameter is SQL Server specific and is not required for Oracle. |
| Database instance where the swat database is installed. Note this parameter is SQL Server specific and is not required for Oracle. |