Setting general connection properties

This section describes how to set up connection parameters for a specific SAP Extractor server or for a SAP Extractor system using load balancing.

Connecting to a specific SAP Application server

To connect to a specific SAP Application server:

1. In the Qlik Replicate console, click the Manage Endpoint Connections toolbar button to open the Manage Endpoints Connections dialog box. Then click the New Endpoint Connection button.
2. In the Name field, enter a display name for your endpoint.
3. Optionally, in the Description field, enter a description for the SAP Application endpoint.
4. Select Source as the database role.

5. Select SAP Extractor as the database Type.

6. From the Connection mode drop-down list, select Custom Application Server.
7. In the Server name field, enter the IP address of the Application Server on which the SAP Extractor source is located.
8. In the Instance identifier field, enter the instance number of the SAP Extractor source you want to replicate.
9. In the Client identifier field, enter the System ID of the SAP Extractor source you want to replicate.

10. Enter your credentials (User Name, Password) for accessing the SAP Extractor source.

    These are the credentials for the communication user created earlier in SAP.

11. From the Number format drop-down list, select one of the following, according to the number format in your system (Replicate needs this information in order to be able to parse the STRING correctly):

    • 1,234,567.89
    • 1.234.567,89

    • 1 234 567.89

Connecting to a SAP system using load balancing

To connect to a SAP system using load balancing:

1. In the Qlik Replicate console, click the Manage Endpoint Connections toolbar button to open the Manage Endpoints Connections dialog box.
2. In the Name field, enter a display name for your endpoint.
3. Optionally, in the Description field, enter a description for the SAP Application endpoint.
4. Select Source as the database role.
5. Select SAP Extractor as the database Type.
6. From the Connection mode drop-down list, select Load Balancing Server.
7. In the Message server field, enter the host name or IP address of the message server host.
8. In the Application servers group name field, enter the name of the SAP server group. This is an optional group of application servers in a load balancing connection.
9. In the SAP system name field, enter the SAP R/3 name.

10. In the Message server service field, enter the name of the SAP message server service as specified in the following file:

    <system drive>:\WINDOWS\system32\drivers\etc\services

    If you do not specify a value, the Data Provider for SAP uses the following default name:

    sapms<R/3 system name>

11. In the Client identifier field, enter the System ID of the SAP Application source you want to replicate.

12. Enter your credentials (Username, Password) for accessing the SAP Extractor source.

    Note: These are the credentials for the communication user created earlier in SAP.

13. From the Number format drop-down list, select one of the following according to the number format in your system (Replicate needs this information in order to be able to parse the STRING correctly):

    • 1,234,567.89
    • 1.234.567,89

Security

In the Security settings, you can configure Secure Network Communication (SNC).

Prerequisites for working with SNC

Follow the steps below to install the Secure Network Communication (SNC) client on the Replicate machine.

What you need:

• An exported certificate (.crt) of the SAP server
• SAPCAR.EXE
• SAP user (authorized customer)
• The version of the crypto library which is installed on the corresponding SAP server

Installing the SNC client

1. Create a workspace folder for the SAP SNC files and binaries (hereafter referred to as "your SNC folder"), for example: "C:\snc\"
2. Copy the exported server certificate and SAPCAR.EXE to your SNC folder.
3. Go to https://support.sap.com/en/my-support/software-downloads.html and search for SAPCRYPTOLIB under Installations & Upgrades. Download the 64-bit .SAR to your SNC folder.

4. Open a command prompt and change the working directory to your SNC folder. Then run the following command to unpack the content of the .SAR to your SNC folder:

   sapcar -xvf LibName.sar

   Example:

   sapcar -xvf SAPCRYPTOLIBP_8541-20011731_32.SAR

5. Add system environment variables as follows:
   1. Add a system environment called SECUDIR with the path to your SNC folder as its value.
   2. Add a system environment variable called QLIK_SNC_LIB with the path to the sapcrypto.dll file as its value.
   3. Add the newly added environment variables to the "PATH" environment variable.

6. Determine the <PSE_File_Name> and choose a <PSE_PIN> to protect it. You will need to provide this information in the next steps.

   Example:

   pseName: "CN=USR,OU=SAP,O=Qlik,C=IS" password: password123

7. Determine the <SNC_NAME>. It should look something like this: CN=USR, OU=SAP, O=Qlik, C=IS

   See also Determining the server SNC name below.

8. Make sure you have the required permissions to access and execute the files in the SECUDIR folder, and then run the following command to generate the PSE file:

   sapgenpse get_pse -p <PSE_File_Name>.pse -x <PSE_PIN> <SNC_NAME>

   Example:

   sapgenpse get_pse -p usr.pse -x password123 "CN=USR,OU=SAP,O=Qlik,C=IS"

9. Bind the PSE file with the OS user and create the CRED_V2 file in SECUDIR folder as follows:
   1. Make a note of the OS user under which Replicate is running:
      • Windows: Open the Services console and double-click the Qlik Replicate Server service to open the properties dialog. Look in the Log On tab.
      • Linux: Run the ps aux command.

   2. Run the following command:

      sapgenpse seclogin -p <PSE_File_Name>.pse -x <PSE_PIN> -O <OS_USER>

      Example:

      sapgenpse seclogin -p usr.pse -x password123 -O SYSTEM

10. Generate the CRT file by executing the following command:

    sapgenpse export_own_cert -o <PSE_File_Name>.crt -p <PSE_File_Name>.pse -x <PSE_PIN>

    Example:

    sapgenpse export_own_cert -o usr.crt -p usr.pse -x password123

11. Import the SAP Application Server Certificate (<SERVER_CRT>) to the PSE by executing the following command:

    sapgenpse maintain_pk -a <SERVER_CRT>.crt -p <PSE_File_Name>.pse -x <PSE_PIN>

    Example:

    sapgenpse maintain_pk -a sapsys.crt -p usr.pse -x password123

12. To verify that the DN of the SAP Server’s PSE was imported into the client, run the following command and then check the "subject" value:

    sapgenpse maintain_pk -v -l -p <PSE_File_Name>.pse

    Example:

    sapgenpse maintain_pk -v -l -p usr.pse

Importing the client certificate

1. Connect to the SAP Application Server and navigate to the "STRUST" transaction using an authorized user.
2. Double-click the SNC (SAPCryptolib) folder.
3. Click to switch to Change view.
4. Click to import the certificate.
5. In the new dialog, enter the path to the .crt file that was created earlier, then click continue.
6. Verify the details of the certificate in the Certificate section.
7. Click Add to Certificate List to add the certificate to the list.
8. Save the changes.

Determining the server SNC name

There are two ways you can determine the server name:

• Method 1: Decrypt the server CRT file using the OpenSSL command. The server name will be part of the subject.
• Method 2: This method requires appropriate permissions. While connected to the system:
  1. Run the RZ10 transaction.
  2. Select the system profile.

  3. Select the Extended Maintenance option and then click Display.

  4. The value of the snc/identity/as parameter should be the SNC name.

Connection settings

Configure the SNC settings in the SAP Extractor endpoint as follows:

• Activate Secure Network Communication: Select to turn on SNC.

• SNC name: The SNC partner name.

  Example:

  p:CN=SYS, OU=SAP, O=Qlik, C=IS

• SNC quality of protection - Select one of the following:
  • Authentication only: Select to verify the identity of the SAP Extractor machine. This is the minimum protection level offered by SNC.
  • Integrity protection: Select to detect any changes or manipulation of the data, which might have occurred between the Replicate machine and the SAP Extractor machine.
  • Privacy protection: Select to encrypt the messages being transferred to prevent eavesdropping. Privacy protection also includes integrity protection. This is the maximum level of protection provided by SNC.
  • Maximum security available: The maximum level of data protection supported by the SAP Extractor machine.