1. Enter the hostname of the load balancer.
    Note: The hostname should be the domain name of the load balancer. For example: www.example.com.
  2. Make the appropriate selection regarding SSL configuration based on your environment.
    Important: If an SSL certificate is not specified, the installer will not generate the configuration and certificate files required for the installation of the On-Premises Connector and the ODBC and JDBC drivers.
    • Select Yes to specify the SSL certificate file to be used with the Hybrid Data Pipeline server. The specified file must be the root certificate used to sign the certificate for the load balancer server. PEM, DER, and Base64 encodings are supported. Type the full path to the certificate file, or click Choose... to browse to the location of the SSL certificate file. Then, click Next.
    • Select No if you do not want to specify an SSL certificate.
  3. Select MySQL Community Edition if you plan to use MySQL Community Edition as an external system database or as a data source. Hybrid Data Pipeline does not provide a driver for MySQL Community Edition. However, you can use the MySQL Connector/J driver to use MySQL Community Edition as an external system database or as a data source. If you select MySQL Community Edition, enter the name and location of the MySQL Connector/J jar file in the Jar Path field. Then, click Next to continue.
    For more information on the MySQL Connector/J driver, refer to the MySQL developer website at https://dev.mysql.com/.
  4. Select the external database you want to use to store system information from the drop down menu.
    • Select Oracle, and continue at Step 5.
    • Select MySQLCommunity, and continue at Step 6.
    • Select MSSQLServer, and continue at Step 7.
    • Select PostgreSQL, and continue at Step 8.
  5. Provide the Oracle connection information.
    1. Type the name of the host.
    2. Type the port number.
    3. Select the connection type. Do one of the following:
      • If you connect using the Oracle System Identifier (SID), select Connect using SID, then type the SID.
      • Select Connect using Service Name, then type the database service name that specifies the database that is used for the connection. The service name is a string that is the global database name. The global database name typically comprises the database name and domain name.
    4. Optionally, in the Advanced Options field, specify additional connection parameters and their values to be included in the connection URL. Values should be entered as a semicolon-separated list of parameter=value. For example, you may enter to following options to configure SSL: 
      encryptionLevel=Required;encryptionTypes=(AES256);
dataIntegrityLevel=Required;dataIntegrityTypes=(SHA1);
encryptionMethod=SSL;keyStore=/common/Oracle/trustStore.jks;
keyStorePassword=secret; serverType=dedicated;authenticationMethod=ntlm;
hostNameInCertificate=oracle;editionName=hybrid
    5. Click Next, and continue at Step 9.
  6. Provide connection information for the MySQL Community Edition external database.
    1. Type the name of the host.
    2. Type the port number.
    3. Type the database name.
    4. Optionally, in the Advanced Options field, specify additional connection parameters and their values to be included the connection url. Values should be entered as a ampersand-separated list of parameter=value.
    5. Click Next, and continue at Step 9.
  7. Provide the SQL Server connection information.
    1. Type the name of the host.
    2. Type the port number.
    3. Type the database name.
    4. Type the name of the schema.
    5. Optionally, in the Advanced Options field, specify additional connection parameters and their values to be included in the connection URL. Values should be entered as a semicolon-separated list of parameter=value.
    6. Click Next, and continue at Step 9.
  8. Provide the PostgreSQL connection information.
    1. Type the name of the host.
    2. Type the port number.
    3. Type the database name.
    4. Optionally, in the Advanced Options field, specify additional connection parameters and their values to be included in the connection URL. Values should be entered as a semicolon-separated list of parameter=value.
    5. Click Next, and continue at Step 9.
  9. Provide the database credential information for the external database.
    • In the Admin Username field, type the administrator user name. The administrator user must have certain privileges that are specific to the database vendor. For a list of required privileges, see External system databases.
    • In the Admin Password field, type the password for an database administrator account.
    • In the Username field, type a user name. The standard user must have certain privileges that are specific to the database vendor. For a list of required privileges, see External system databases.
    • In the Password field, type the user password.
  10. Review the Server Access Port. The Server Access Port must be opened for the load balancer.
    Note: In most cases, the default ports work without problems. However, your environment might have already defined a function for one or more of the ports. If a default port is in use, the installer pops up a message so that you can make the necessary changes.
    Table 1. Server Access Ports
    Name Default Description
    Server Access HTTP Port 8080 HTTP port used for communication to the Hybrid Data Pipeline Web UI and API.
    Server Access HTTPS Port 8443 HTTPS port used for encrypted communication to the Hybrid Data Pipeline Web UI and API.
  11. Select whether you are using the On-Premises Connector.
    Note: An SSL certificate must be specified in Step 2 to use the On-Premises Connector.
    • If using the On-Premises Connector, select Enable On-Premises Connector. Click Next and continue to the next step.
    • If not using the On-Premises Connector, leave the check box empty and click Next. Continue at Step 13.
  12. Review the On-Premises Access Ports. The On-Premises Access Port and a TCP Notification Server Port must be opened for the load balancer.
    Note: In most cases, the default ports work without problems. However, your environment might have already defined a function for one or more of the ports. If a default port is in use, the installer pops up a message so that you can make the necessary changes.
    Table 2. On-Premises Access Ports
    Name Default Description
    On-Premises Port 40501 Port for communication between the On-Premises Connector and the Hybrid Data Pipeline server.
    Notification Server TCP Port 11280 TCP port for communication from the On-Premises Connector to the Notification Server.
    Notification Server TCP SSL Port 11443 TCP SSL port for encrypted communication from the On-Premises Connector to the Notification Server.
    Message Queue Port 8282 Port for communication between the Notification Server and the Hybrid Data Pipeline server. Required for Linux installation of Hybrid Data Pipeline. Not used in Docker deployments.
  13. Review the Server Internal Ports. The Internal API Port and the Shutdown Port must be opened.
    Important: As a matter of best practice, the Shutdown Port should not be available outside the firewall of the Hybrid Data Pipeline instance.
    Note: In most cases, the default ports work without problems. However, your environment might have already defined a function for one or more of the ports. If a default port is in use, the installer pops up a message so that you can make the necessary changes.
    Table 3. Server Internal Ports
    Name Default Description
    Internal API HTTP Port 8190 HTTP port for communication between individual nodes in a cluster deployment.
    Internal API HTTPS Port 8090 HTTPS port for encrypted communication between individual nodes in a cluster deployment.
    Shutdown Port 8005 TCP port that listens for shutdown requests.
  14. Review the installation summary. If you are satisfied with your choices, click ENTER to install.
  15. After the installation has finished, press ENTER to exit the installer.
  16. Verify the installation by accessing the Hybrid Data Pipeline user interface from a browser. The login page should appear. For example, type:

    https://<myserver>/

    where <myserver> is the fully qualified hostname or IP address of the load balancer.

    After logging in, administrators can verify product version information by selecting About from the question mark drop-down menu.

Refer to installation log files for a record of any problems that may have occurred during the installation. See Deployment logs for details.

What to do next

During installation, the installer generates four configuration and certificate files. These files will be located in the redist subdirectory of the key location you specified in Step 10 in "GUI mode installation." Before installing a component such as the ODBC driver, the JDBC driver, or the On-Premises Connector, these files must be copied to the installer directory of the component you are installing.

Note: If an SSL certificate was not specified in Step 2, the installer will not generate the configuration and certificate files required for the installation of the On-Premises Connector and the ODBC and JDBC drivers.

The four configuration and certificate files are:

  • config.properties
  • ddcloud.pem
  • ddcloudTrustStore.jks
  • OnPremise.properties