Adding a non-relational ARC data source to Qlik Replicate

When you add a database to Qlik Replicate and you select a non-relational ARC data source as the database type, the following dialog box opens.

To add an ARC source database to Qlik Replicate:

1. In the Qlik Replicate console, click Manage Endpoint Connections to open the Add 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 an ARC non-relational data source from the Type list. The ARC data sources are listed as <database> (ARC), for example RMS (ARC). For a list of supported non-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 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. When working with theRMS (ARC)data source, choose one of the following Change Processing modes:

   • Non relational (the default) - When this mode is selected, Replicate reads the changes from a CSV file that contains the modified data records. Use this mode if you need to retrieve changes to arrays and variant tables.

     If you select this option, continue from Step 7 below.

   • Relational - When this mode is selected, Replicate reads the changes directly from the ARC Agent. Relational mode improves performance but does not support changes to complex data structures such as arrays and variant tables.

     If you select this option, continue from Step 6 in Adding a relational ARC data source to Qlik Replicate.

7. In the Port field, type the port number for the port you used when creating the CDC Router 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. If a username and password are required to access the CDC Solution Router, enter them in the User name and Password fields in the Local ARC router section.
10. If a username and password are required to access the CDC Solution, enter them in the User name and Password fields in the ARC on <source> machine section.

11. Required for IBM IMS (ARC) only: In the Bulk started task field, specify the correct z/OS Started Task name for IMS/BMP or IMS/DLI. This member was copied to the z/OS PROCLIB library from <ARC HLQ>.USERLIB. NVBMPSRV and NVIMSSRV are the provided member names.

    Information note

    If you choose IMS/DLI, you will need to close the database to IMS/TM or IMS/DBCTL. This option might be faster than using BMP. IMS/BMP does not require exclusive access to the database.

12. 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.