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:

   • Basic properties
   • Advanced properties

   Note

   Basic properties are displayed by default in the External DB connections page. These are the most common properties that you can set.

   Note

   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.

   You can edit the connection using . You can delete a connection using .