Created by James Hurrell, last modified on Feb 12, 2020

Summary: This section provides details about options that are common to all the GUI based tools.

Connection / Dashboard Connection tabs

When using the GUI based tools to install and configure your Health Dashboard, you are required to enter various parameters that will allow you to connect to your chosen RDBMS/CAST Storage Service. The parameters that are required are the same in all GUIs and are listed below:

JDBC driver

Select the driver that corresponds to the host RDBMS where your CAST Measurement Service/CAST Dashboard Service is stored:

  • org.postgresql.Driver > CAST Storage Service
  • net.sourceforge.jtds.jdbc.Driver > Microsoft SQL Server
  • Oracle.jdbc.OracleDriver > Oracle Server
Note that the CAST Storage Service driver is the only driver available for connecting to a CAST Measurement Service using the AAD Connection tab (this CAST AIP schema can ONLY be installed on a CAST Storage Service). All three drivers are available in the Dashboard connection tab.
Database URL

Enter the connection parameters for the host RDBMS where your CAST Measurement Service/CAST Dashboard Service is stored:

  • CAST Storage Service
    • jdbc:postgresql://<host>:<port_number>/postgres
  • Microsoft SQL Server
    • jdbc:jtds:sqlserver://<server>:<port_number>
    • jdbc:jtds:sqlserver://<server>/<database>
    • If you have a named instance, add ;instance=MY_SQL_SERVER to the end of the above URLs
  • Oracle Server > jdbc:oracle:thin:@<server>:<port_number>:<instance>
  • Host/Server can be a Netbios name or an IP address
  • Default port numbers are as follows:
    • CAST Storage Service 2: 2280 / CAST Storage Service 3: 2282
    • Microsoft SQL Server: 1433
    • Oracle Server: 1521
  • For the CAST Storage Service the parameter "postgres" is required and refers to the parent database on which the CAST schemas are installed - this cannot be modified when installing the CAST Storage Service.
  • Please refer to the jTDS documentation for more information about URL formats for the Microsoft SQL Server driver: http://jtds.sourceforge.net/faq.html#urlFormat

Schema

Enter the name of your CAST Measurement Service or the CAST Dashboard Service depending on the action you are executing.

User

Enter the user that you want to use to connect with:

  • CAST Storage Service > use the default operator user
  • Microsoft SQL Server > use the sa user or a user with the sysadmin role
  • Oracle Server > use the schema owner of the CAST Measurement Service or the CAST Dashboard Service

Password

Enter the password that corresponds to the user you entered above.
TrustedTrusted connections are not supported currently. Please do not activate this option.

Debug tab

When working in Advanced mode in the GUI (select View > Advanced mode), a Debug tab will be visible:

DebugTick this option if you would like to see SQL trace diagnostics in the log. This option is equivalent to the addition of the -jdbc_debug option for the command line interface.
Log FileEnter a path to a log file so that execution logs can be saved. This option is equivalent to the addition of the -log_file log.log option for the command line interface.

Advanced tab

When working in Advanced mode in the GUI (select View > Advanced mode), an Advanced tab will be visible:

Select the Node Level
Please do not modify this option.
Synchronize Indicators
Ensures that custom Quality Rule data is transferred from the Dashboard Service to the Measurement Service. This option is always selected when running a consolidation via the CAST Management Studio.