This documentation supports releases of BMC Helix Continuous Optimization up to December 31, 2021. To view the latest version, select the version from the Product version menu.

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 are displayed by default in the External DB connections page. These are the most common properties that you can set.
      Property Value
      Datasource parameters
      Name Specify a name for the external datasource connection. 
      Description (Optional) Enter a brief description for this connection.
      Databasee type

      Select a database type from the list.

      Database user 

      Enter the database user name.

      Database password

      Enter the database password. 

      Host name Enter the hostname where the DB is running.
      Port Enter the port number that will be used to access the DB on the specified Host name.
      (For Oracle) SID / Service name Select SID or Service name. Based on the selection, specify the SID or Service name.
      (For PostgreSQL) Database name Enter the name of the PostgreSQL datasource.
      (For Microsoft SQL Server and Sybase) Port Enter the port number that will be used to access the DB on the specified Host name.
      (For Microsoft SQL Server and Sybase) Database name Enter the name of the datasource.
      (For Microsoft SQL Server and Sybase) TDS version Enter the TDS protocol version number.
      (For Oracle, PostgreSQL, Microsoft SQL Server) Use SSL/TLS Select Yes if you want to use a secured TLS compliant connection. Else, select No.
      (For PostgreSQL) Server certificate name Enter the name of the external database certificate that you imported into the truststore. For example, extdatabase.crt.
      (For Microsoft SQL Server) Instance Enter the instance information of the Microsoft SQL Server datasource.
      (For other databases) JDBC URL Enter the JDBC URL.
      (For other databases) DBI URL Enter the database interface module URL.
      (For other databases) JDBC driver

      Specify the JDBC driver information.


      To connect to another database type, verify that the correct driver is installed on the Capacity Optimization server running this ETL. For an ETL in Perl code, install an appropriate DBD driver. For an ETL in Java code, install an appropriate JDBC driver.


      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.

      Property Value
      Datasource parameters
      Database prefix This is applicable for all databases. Enter the database prefix.
      JDBC prefix This is applicable for Oracle, PostgreSQL, Microsoft SQL Server, and Sybase databases. Enter the JDBC prefix.
      (For Microsoft SQL Server and Sybase) Driver type Select the driver type; Default or JDTS.
    • Click Save.

      Additional info

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

    Was this page helpful? Yes No Submitting... Thank you