Setting database connection properties for monitoring

Two files contain the database connection information required by the monitoring tool.

About this task

  • jdbc.properties contains database user credentials and JDBC configuration for the connection to the Marketing Platform database, for Marketing Platform notifications.
  • monitor.xml contains database user credentials and JDBC configuration for the connection to the Opportunity Detect design time database

You must edit these files in the following cases.

  • If Opportunity Detect is installed using the manual database creation option, you must set values in both of these files manually.

    If the automatic database creation option is used, and if Opportunity Detect Design Time and Run Time are installed on the same server, the installer sets the values.

  • If Opportunity Detect Design Time and Run Time are installed on different servers, you must set values in the monitor.xml file.
  • If Opportunity Detect is installed using the manual database creation option, and if Opportunity Detect Design Time and Run Time are installed on different servers, the files are laid down in DB2 format.

    However, sample Oracle files are provided in the conf directory under your Opportunity Detect Run Time installation. If you are using Oracle for your system tables in this scenario, you must do the following.

    1. Change the names of the jdbc.properties and monitor.xml files.

      You can use any name, such as monitor.xml.old

      .
    2. Rename the jdbc.properties.oracle file to jdbc.properties.
    3. Rename the monitor.xml.oracle file to monitor.xml.

    Then proceed with the steps shown in this procedure.

Procedure

  1. In the conf directory under your Opportunity Detect Run Time installation, locate the jdbc.properties file, open it in a text editor, and do the following.
    1. Set the value of the uasm.data_source_password property to the password of the Marketing Platform database user account.

      For example: uasm.data_source_password=YOUR_PASSWORD

      You can encrypt this password by running the encode shell script located in the cli directory under your Opportunity Detect design time installation. For example: ./encode.sh YOUR_PASSWORD

      If you use an encoded password, precede the encoded password with ENC and enclose the password in parentheses. For example: uasm.data_source_password=ENC(15jqpwXzPPor4FChvS63Gw==)

    2. Save and close the file.
  2. In the conf directory under your Opportunity Detect Run Time installation, locate the monitor.xml file, open it in a text editor, and do the following.
    1. Set the value of the ConnectionPassword key to the password of the Opportunity Detect database user account.

      For example: <entry key="ConnectionPassword">YOUR_PASSWORD</entry>

      You can encrypt this password as described in the previous step.

      If you encrypt the password, set the ConnectionPasswordEncrypted key to true. For example:

      
<entry key="ConnectionPassword">hJOvSd18EqBFPWr2+a36Ag==</entry>
<entry key="ConnectionPasswordEncrypted">true</entry>
    2. Save and close the file.