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.

This section describes how to configure general connection properties. For more information about configuring advanced connection properties, see Setting advanced connection properties.

To add an IBM IMS source endpoint to Qlik Replicate:

1. In Tasks view, click Manage Endpoint Connections to open the Manage Endpoints Connections dialog box. Then click the New Endpoint Connection button.
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 IBM IMS database. This is optional.

4. Select Source as the database role.

5. Select IBM IMS as the database Type.

   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. Configure the other properties as follows:

   Replicate z/OS server

   • Host: The host name or IP address the Replicate server on z/OS is listening on.

   • Port: The port number the Replicate server on z/OS is listening on. The default is 50051.

     Information noteThis port needs to be opened for inbound HTTPS traffic on z/OS.

   IMS Connect

   • IMS Connect host: The host name or IP address of the IMS Connect server on z/OS.

   • IMS Connect port: The port that IMS Connect on the z/OS server listens on.

   • Username: The username for the connection.

   • Password: The password for the connection.

   Database settings

   • PSB name: The Program Specification Block is a named IMS definition (also known as Program View) that specifies what IMS databases a program can access, what segments can be accessed from each database, and what operations can be performed on each segment. We recommend creating a dedicated PSB for use with Replicate, where all access is limited to READ. In addition, since Replicate can only replicate physical segments, the PSB used with Replicate should not include logical segments (shortcuts to segments from other IMS databases).
   • Override character encoding: Optional. To override the character set specified in the DBDs, click Browse and select one of the available character sets.
   • Metadata file (.dbd or .zip): Optional. Either enter the path to a file on the Replicate server machine containing the IMS database definitions (DBDs) mentioned in the PSB definition, or use the Browse button to upload the file contents into the endpoint settings. Using the Browse button eliminates the need to access files on the Replicate Server machine, which is recommended for better security. If you use the Browse button, the file content will be stored as base64-encoded data in this field. If the PSB definition mentions a database for which a DBD file is not provided, Replicate will use the DBD definition from the catalog. Note that in many cases, the DBD definition stored in the catalog does not define all the fields in the IMS segment. In such cases, a DBD definition must be provided to retrieve all segment fields. The file format can be one of the following:

     • Zip file: All files in the Zip with an extension ".dbd" will be parsed as XML DBD files and will be used in place of the DBD definition in the IMS catalog.

       Information noteThe name of the .dbd files is not significant. Replicate identifies the IMS database for which the file is provided based on the dbdName attribute in the ns2:dbd tag.
     • Single DBD XML file: This provides metadata for a single IMS database (mentioned in the dbdName attribute in the ns2:dbd tag of the file). Metadata for all other IMS databases will be taken from the IMS catalog.

   Change Data Capture settings

   • z/OS LOGSTREAM name: The name of the logstream that the Replicate IMS EXIT function writes to on the z/OS machine.

   Security

   • Client authentication certificate (p12): The client certificate used by the MTLS (mutual TLS) connection to the server on the z/OS machine.

   • Client certificate password: The password for the client authentication certificate. Leave this field empty if there is no password.

   • Server certificate CA (pem): The server certificate in .pem format, used by the endpoint to authenticate the server on the z/OS machine.