skip to main content
Installing and upgrading the Hybrid Data Pipeline server : Installing the Hybrid Data Pipeline server : Silent installation process : Creating a response file using the installer in GUI mode : Creating a response file for a load balancer installation (GUI mode)
  

Try Now
Creating a response file for a load balancer installation (GUI mode)
1. 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.
2. Select whether you want to use the MySQL Community Edition data store for either a system database or data source. Hybrid Data Pipeline does not provide a driver for MySQL Community Edition; however, it does support the MySQL Connector/J driver. If you choose Yes, in the Jar Path field, provide the name and location of the driver's jar file.
For more information on the MySQL Connector/J driver, refer to the MySQL developer website at https://dev.mysql.com/.
3. Select the external database you want to use to store system information from the drop down menu.
*Select Oracle, and continue at Step 4.
*Select MySQLCommunity, and continue at Step 5.
*Select MSSQLServer, and continue at Step 6.
*Select PostgreSQL, and continue at Step 7.
4. Provide the Oracle connection information.
a. Type the name of the host.
b. Type the port number.
c. 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.
d. 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 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
e. Click Next, and continue at Step 8.
5. Provide connection information for the MySQL Community Edition external database.
a. Type the name of the host.
b. Type the port number.
c. Type the database name.
d. 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.
e. Click Next, and continue at Step 8.
6. Provide the SQL Server connection information.
a. Type the name of the host.
b. Type the port number.
c. Type the database name.
d. Type the name of the schema.
e. 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.
f. Click Next, and continue at Step 8.
7. Provide the PostgreSQL connection information.
a. Type the name of the host.
b. Type the port number.
c. Type the database name.
d. 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.
e. Click Next, and continue at Step 8.
8. 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. For a list of required privileges, see External system databases.
*In the Password field, type the user password.
Important:
*Administrator credentials are only required at install time to create the database schema. Administrator credentials are not used by the product at run time.
*Passwords for an external database implementation are not persisted. These values must be specified in the response file with the D2C_DB_ADMIN_PASSWORD and D2C_DB_USER_PASSWORD options before running a silent install.
*The installer attempts to validate the database. If the installer is unable to validate, you are prompted to reenter credentials or skip validation. If you skip validation, the response file must have the SKIP_DATABASE_VALIDATION property set to true. During a silent installation, the installer will complete the installation even when the database validation fails.
9. Review the Server Access Port. The Server Access Port must be opened for the load balancer. The default is 8080.
Note: In most cases, the default port works without problems. However, your environment might have already defined a function for the port. If the default port is in use, the installer pops up a message so that you can make the necessary changes.
10. Select whether you are using the On-Premises Connector.
Note: An SSL certificate must be specified in Step 1 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 12.
11. Review the On-Premises Access Ports. The On-Premises Access Port and the 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.
On-premises access ports with default values. If your environment has already defined one of these ports, a message window is displayed when you click Next.
Table 14. On-Premises Access Ports
Name
Default
Description
On-Premises Port
40501
Port for the On-Premises Connector
TCP Port
11280
Port for the Notification Server
Message Queue Port
8282
Port for the message queue
12. 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 any 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.
Server ports showing the default values. If your environment has already defined one of these ports, a message window is displayed when you click Next.
Table 15. Server Internal Ports
Name
Default
Description
Internal API Port
8190
Non-SSL port for the Internal API
Shutdown Port
8005
Shutdown port
13. Review the installation summary. If you are satisfied with your choices, press ENTER to generate the response file.
14. After the response files has been generated, press ENTER to exit the installer.
15. Confirm that a response file has been generated by navigating to the response file directory you specified in Step 3 in "Creating a response file using the installer in GUI mode" and opening the response file.
16. You must now edit the response file according to the guidelines in Editing a GUI generated installation response file. In all scenarios, the response file must be edited to include passwords for the d2cadmin and d2cuser user accounts. Depending on your environment, the response file may require additional modification.