Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Note
Note that it is critically important to configure the initialSize, maxActive, and maxIdle parameters according to your consumption use case and the number of schemas you want to configure. The default values are high but could probably be decreased to limit the number of active connections to your database instance (eg. initialSize="2" maxActive="10" maxIdle="2"). Please see the "Optimize context.xml" section in Configuring the CAST Application Analytics Dashboard for large numbers of Applications for more information about these parameters, or consult the relevant Apache Tomcat documentation: https://tomcat.apache.org.

Tomcat 8 or 8.5 - configuration for one Dashboard Service stored on CSS2

If you are using Tomcat 8 or 8.5 to host the CAST Application Engine Dashboard and CSS2 to host you CAST Dashboard Services, please follow these instructions:

...

Note
Note that it is critically important to configure the initialSize, maxTotal and maxIdle parameters according to your consumption use case and the number of schemas you want to configure. The default values are high but could probably be decreased to limit the number of active connections to your database instance (eg. initialSize="2" maxActive="10" maxIdle="2"). Please see the "Optimize context.xml" section in Configuring the CAST Application Analytics Dashboard for large numbers of Applications for more information about these parameters, or consult the relevant Apache Tomcat documentation: https://tomcat.apache.org.

Configuring access to Dashboard Services stored on Microsoft SQL Server or Oracle Server for Tomcat 7/8/8.5

If your target Dashboard Service is located on a Microsoft SQL Server or Oracle Server, you need to:

  • Remove or re-comment the uncommented template for CSS2/Tomcat 7 from the context.xml file
  • Copy the commented template available in the context.xml file for Microsoft SQL Server or Oracle Server into uncommented space - ensure you chose the correct template for Tomcat 7 or Tomcat 8 / 8.5.
  • Make the same configuration changes as suggested above:
    • Set the URL parameter to the server on which the Dashboard Service is located (please see http://jtds.sourceforge.net/faq.html#urlFormat for more information about the Microsoft SQL Server jTDS JDBC driver URL format)
    • Set the initConnectionSqls parameter to the name of the Dashboard Service {database} or {schema}

    • Ensure the username and password parameters for your target RDBMS are correct - these provide access to the Dashboard Service database or schema.
  • Following any changes you make, save the context.xml file.

Configuring access to multiple Dashboard Services for Tomcat 7/8/8.5

If you would like to configure access to multiple Dashboard Services for use with your CAST Application Engineering Dashboard, please do as follows:

  • For each additional Dashboard Service you want to configure access to, please add an uncommented configuration template (these are supplied in the context.xml file - ensure you chose the correct template for Tomcat 7 or Tomcat 8 / 8.5) for the target RDBMS/CSS2 underneath the section configured for your initial Dashboard Service
  • First change the name parameter to something other than "jdbc/domains/AED" (the default "name" used in the pre-provided templates) - CAST recommends using the name of your target Dashboard Service - for example "jdbc/domains/V80_CENTRAL_CSS2" (you must retain the "jdbc/domains" part of the the name). This is because each Dashboard Service you connect to the CAST Application Engineering Dashboard must have a unique "name" parameter
  • Set the URL parameter to the server on which the additional Dashboard Service is located (usually you just need to alter the "localhost" to the name of the server on which the host RDBMS is located).
  • Then, depending on your target RDBMS/CSS2:
    • CSS2: Change [Dashboard Schema] to the name of the additional Dashboard Service schema (see Install CAST schemas).
    • Microsoft SQL Server/Oracle Server: Set the initConnectionSqls parameter to the name of the Dashboard Service {database} or {schema}
  • Ensure the username and password parameters for your target RDBMS/CSS2 are correct (note that if you need to encrypt the username and password to avoid entering names in clear text, please see: CAST-AAD-AED - Encrypt login and password for datasource and Active Directory)
  • Following any changes you make, save the context.xml file.

...