Adding external database connections

You must create a new external database connection to connect to any of the external databases. You can use this connection while configuring the ETL.

The communication channel between the BMC Helix Continuous Optimization components and the external databases can be in TCP or TLS 1.2 mode.

  1. Click Administration > ETL & SYSTEM TASKS > External DB connections
  2. Click Add connection. The External DB connections page is displayed.

  3. Enter the following details:

    Important

    The External DB connections page displays basic properties by default. These are the most common properties that you can set.

    Important

    To view or configure Advanced properties, click Advanced. You do not need to set or modify these properties unless you want to change the way the connection works. These properties are for advanced users and scenarios only.

  4. Click Save.


 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*