Adding a relational ARC data source to Qlik Replicate

To add a relational ARC data source to Qlik Replicate:

1. In the Qlik Replicate console, click Manage Endpoint Connections to open the Manage Endpoint Connections dialog box and then click New Endpoint Connection. For more information on adding an endpoint to Qlik Replicate, see Defining and managing endpoints.
2. In the Name field, type a name for your database. This can be any name that will help to identify the database being used.
3. In the Description field, type a description that helps to identify the ARC CDC Solution. This is optional.
4. Select Source as the role.

5. Select a relational ARC data source from the Type list. The ARC data sources are listed as <Data Source> (ARC). For a list of supported relational data sources, see Using ARC CDC agents as endpoints.

   Information note

   When this endpoint is used as a duplicated source in a Log Stream Staging setup, select the Read changes from log stream staging folder check box and then select the relevant Log Stream Staging task from the drop-down list.

   For information on setting up and managing Log Stream Staging tasks, see Using the Log Stream.

6. In the Host/IP field, type the name or IP Address of the computer where the CDC Solution (data source) you defined in Attunity Studio is located.
7. In the Port field, type the port number for the port you used when creating the CDC Solution in Attunity Studio. The default port number is 2551.
8. In the CDC Solution field, enter the name of the solution you defined when you created the data source in Attunity Studio.
9. In the User name and Password fields, enter the username and password required to access the database.

10. Click OK to add the database to Qlik Replicate. You can use this database as the source database for any replication task that you create.

    Information note

    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.