Setting general connection properties

This section describes how to configure general connection properties. For an explanation of how to configure advanced connection properties, see Setting advanced connection properties.

To add a Pivotal Greenplum Target endpoint to Qlik Replicate:

1. In Tasks view, click Manage Endpoint Connections to open the Manage Endpoint Connections dialog box.
2. In the Manage database Connections dialog box, click New Endpoint Connection.
3. In the Name field, type a name for your database. This can be any name that will help to identify the database being used.
4. In the Description field, type a description that helps to identify the Pivotal Greenplum database. This is optional.

5. Select Target as the database role.

6. Select Pivotal Greenplum as the database Type.

7. Type the Database host name. This is the name of the computer with the Pivotal Greenplum instance you want to work with.

   Information note

   Although the gpfdist program acts as a Webserver, it does not carry out security checks on any requests made to it. Therefore, when you define the path to the gpfdist program, it must be to a specific location so that no other data on the computer is accessed.

   You can use the Advanced tab to add specific properties and create a custom connect string. In this case, you do not need to enter information in this tab. For more information on using the Advanced tab, see Setting advanced connection properties.

8. Type the Pivotal Greenplum database Port, where the Pivotal Greenplum instance you are working with is located. The default value is 5432.

9. Type the Pivotal Greenplum authentication information (User Name, Password) for the authorized user for this Pivotal Greenplum database. If you do not know this information, see your Pivotal Greenplum system manager.

   Information note

   • If you are using the Advanced tab to create a custom string, make sure to include the User Name property. A Password can also be included but is not required. See Setting advanced connection properties for more information.

   • This information is case sensitive.
   • If you want to set custom properties for this database, see Setting advanced connection properties.

   • To determine if you are connected to the database you want to use or if the connection information you entered is correct, click Test Connection

     If the connection is successful a message in green is displayed. If the connection fails, an error message is displayed at the bottom of the dialog box.

     To view the log entry if the connection fails, click View Log. The server log is displayed with the information for the connection failure. Note that this button is not available unless the test connection fails.

   Information note

   Make sure that the Pivotal Greenplum user entered in the Pivotal Greenplum Authentication section has the correct access privileges. For information on how to provide the required privileges, see Security requirements.

10. Type the Database name or select one from the list of available databases. This is the name of the Pivotal Greenplum database where you are replicating the data to.

11. Type the gpfdist hostname for the server where the gpfdist program is installed.

12. Type the gpfdist port number where the gpfdist program is listening. The default value is 8080.

13. In the Security section:
    1. To enable SSL, select the Use SSL check box.
    2. In the CA Path, specify the folder containing the certificate required to execute gpfdist.

    3. In the Public key file field, specify the full path of the public key file (i.e. including the file name). The file can reside in the same folder as the CA certificate.

    4. In the Private key file field, specify the full path of the private key file (i.e. including the file name). The file can reside in the same folder as the CA certificate.