SAP ODP
This topic explains how to set up a SAP ODP source in a data task. Before you start the data task, make sure that you have fulfilled the Prerequisites and familiarized yourself with the Limitations and considerations.
Setting connection properties
This section describes how to set up connection parameters for a specific SAP Application server or for a SAP system using load balancing.
To open the connector, do the following:
-
In Connections, click Create connection.
-
Select the SAP ODP source connector and then provide the following settings:
Data source
-
Data gateway
Select a Data Movement gateway to use for moving data.
-
Connect to: Select one of the following according to your SAP ODP environment:
- Application server - Then proceed from Connecting to a specific application server below.
- Load balancing environment - Then proceed from Connecting to a load balancing environment below.
Connecting to a specific application server
-
After selecting Application server from the Connect to drop-down list, provide the following information:
- Server name: The IP address of the Application Server on which the SAP ODP source is located.
- Instance identifier: The instance number of your SAP ODP source.
- Client identifier: The System ID of your SAP ODP source.
- Complete the fields described in Account properties and Source properties below.
Connecting to a load balancing environment
-
After selecting Load balancing environment from the Connect to drop-down list, provide the following information:
- Message server: The host name or IP address of the message server host.
- Application servers group name: The name of the SAP server group. This is an optional group of application servers in a load balancing connection.
- SAP system name: The SAP R/3 name.
-
Message server service: 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>
- Client identifier: The System ID of the SAP Application source you want to Move.
- Complete the fields described in Account properties and Source properties below.
Account properties
-
User Name: Your user name for accessing the SAP ODP source. This should be password of the communication user created earlier in SAP.
-
Password: Your password for accessing the SAP ODP source. This should be the user name of the communication user created earlier in SAP.
Source properties
-
ODP context: Choose one of the following:
- ABAP Core Data Services (CDS) views: The context of the CDS views. This is the default ODP context.
- SAP NetWeaver Business Warehouse: The context of the BW objects.
- SAP DataSources/Extractors: The context of the data sources and extractors.
- SAP HANA Information Views: The context of the HANA views.
-
SAP LT Replication (SLT): Required to work with a SAP Landscape Transformation Replication Server.
See also: Setting up SLT on SAP
- SLT alias: This field is only visible when the ODP context is set to SAP LT Replication (SLT). Specify the SLT alias as defined in the configuration created in Setting up SLT on SAP
-
Subscriber type: Choose one of the following:
- SAP NetWeaver Business Warehouse: This is the default ODP subscriber type.
- RODPS_REPL_TEST: Used mainly for testing and is not recommended to use for production.
- Others: This will expose the field Other subscriber type, where you can specify a subscriber type that is not listed.
- Subscriber name: Specify the subscriber name. This will be the name shown in SAP for all subscriptions opened by this endpoint connection.
- Max package size: The size of the data package in bytes. This value can be adjusted according to your network and system capabilities. .
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 Data Movement gateway 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
- Create a workspace folder for the SAP SNC files and binaries (hereafter referred to as "your SNC folder"), for example: /opt/snc/
- Copy the exported server certificate and SAPCAR.EXE to your SNC folder.
- 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.
-
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
- Add system environment variables as follows:
- Add a system environment called SECUDIR with the path to your SNC folder as its value.
- Add a system environment variable called QLIK_SNC_LIB with the path to the sapcrypto.dll file as its value.
- Add the newly added environment variables to the "PATH" environment variable.
-
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
-
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.
-
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"
-
Bind the PSE file with the OS user and create the CRED_V2 file in the SECUDIR folder by running the following command on the Data Movement gateway machine:
sapgenpse seclogin -p <PSE_File_Name>.pse -x <PSE_PIN> -O <OS_USER>
Example:
sapgenpse seclogin -p usr.pse -x password123 -O SYSTEM
-
Generate the CRT file by running 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
-
Import the SAP Application Server Certificate (<SERVER_CRT>) to the PSE by running 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
-
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
- Connect to the SAP Application Server and navigate to the "STRUST" transaction using an authorized user.
- Double-click the SNC (SAPCryptolib) folder.
- Click to switch to Change view.
- Click to import the certificate.
- In the new dialog, enter the path to the .crt file that was created earlier, then click continue.
- Verify the details of the certificate in the Certificate section.
- Click Add to Certificate List to add the certificate to the list.
- 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:
- Run the RZ10 transaction.
- Select the system profile.
Select the Extended Maintenance option and then click Display.
- The value of the snc/identity/as parameter should be the SNC name.
Configuring the SNC connector settings
Configure the SNC settings in the SAP ODP connector as follows:
- Activate Secure Network Communication (SNC): 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 ODP 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 Qlik Talend Data Integration machine and the SAP ODP 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 ODP machine.
Internal properties
Internal properties are for special use cases and are therefore not exposed in the dialog. You should only use them if instructed by Qlik Support.
Use the and buttons to the right of the fields to add or remove properties as needed.
Name
The display name for the source connection.
Defining the metadata
After you have configured the connection properties, click OK. The Connection metadata view will open. Define the metadata for the connection as described in Managing metadata. You can edit the metadata later as needed by doing one of the following:
- Select Metadata from the menu shown for the SAP ODP connection within your project.
- Select Metadata from the menu shown for the SAP ODP connection in Connections view.