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.
- Click Administration > ETL & SYSTEM TASKS > External DB connections
- Click Add connection. The External DB connections page is displayed.
Enter the following details:
NoteBasic properties are displayed by default in the External DB connections page. These are the most common properties that you can set.
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.
Enter the database user name.
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.
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.
You can edit the connection using. You can delete a connection using .