Please ensure Javascript is enabled for purposes of website accessibility
Powered by Zoomin Software. For more details please contactZoomin

AVEVA Enterprise SCADA

Service Type Properties - Relational Database Management System (RDBMS)

Service Type Properties - Relational Database Management System (RDBMS)

  • Last UpdatedJul 05, 2024
  • 2 minute read

The Relational Database Management System (RDBMS) tab allows you to modify the RDBMS property values of a service type.

The RDBMS tab on the Service Type Properties dialog box is only relevant if the Uses RDBMS checkbox is selected on the General tab of the Service Type Properties dialog box. Once selected, the system will assign the service type a Default RDBMS Instance Name. The information on this tab is a duplicate of the information that was entered on the Default RDBMS Properties page of the Create Service Type Wizard. The RDBMS tab only applies to Historical, Archive, and Reporting services.

Fields on the RDBMS tab

Field

Description

Default RDBMS Host

Name

The default host name differs by system. On a myOASyS computer, the computer name will be the default host name and will appear in this field. On an Enterprise system, the default host name will be <system name><Service name> (that is, mainHistorical).

Default RDBMS Port

Number

The default port number differs by service. For the Historical and Archive services, the default port number is 20010. For Reporting Services, the default port number is 20011.

Default RDBMS Instance Name

This field indicates which group of databases the service is accessing within Microsoft SQL Server. Default instance names differ by service. By default, the following instance names will populate the Default RDBMS Instance Name field:

  • Historical - OASYSHDB

  • Archive - OASYSHDB

  • Reporting Services - OASYSRS