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:

   Note

   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. Note 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.

   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.

   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.

4. Click Save.

   Additional info

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