Prerequisites
The following section describes the prerequisites for working with the Qlik Replicate SAP ODP endpoint.
ODP API
The SAP ODP endpoint uses ODP API 2.0 which is available from the following SAP basis levels and above:
-
PI_BASIS 730 SP 14 (part of SAP NetWeaver 7.30 SP 14)
-
PI_BASIS 731 SP 16 (part of SAP NetWeaver 7.03 SP 16 and 7.31 SP 16)
-
PI_BASIS 740 SP 11 (part of SAP NetWeaver 7.40 SP 11)
-
SAP_BW 750 SP 0 (incl. former PI_BASIS packages)
For more information, see SAP Note 1931427.
For information on how to release extractors so that they are available for the ODP API, see SAP Note 2232584.
SAP Java Connector
To work with the SAP ODP endpoint, you need to install SAP Java Connector on the Replicate server.
Installing the SAP Java Connector on Replicate for Windows
To install the SAP Java Connector:
-
Download the SAP Java Connector 3.x (64-bit) for Windows from the SAP Support Portal.
To find out the exact SAP Java Connector version you need to support your SAP BW system, refer to the SAP BW Help.
Information noteThe SAP Java Connector 3.1 running on Windows operating systems requires the Microsoft Visual Studio 2013 C/C++ runtime libraries to be installed on the system. See SAP Note 2786882 for details.
-
Install the SAP Java Connector.
-
Copy the Sapjco3.jar and Sapjco3.dll files from the SAP Java Connector installation folder to the following location under the Replicate installation directory:
{REPLICATE_INSTALL_DIR}\endpoint_srv\endpoints\SAPOdp.
- Restart all of the Replicate services.Information noteIf SAP Extractor is already installed, move the Sapjco3.jar and Sapjco3.dll files from <REPLICATE_INSTALL_DIR>\endpoint_srv\externals to <REPLICATE_INSTALL_DIR>\endpoint_srv\endpoints\SAPOdp and restart all of the Replicate services.
Installing the SAP Java Connector on Replicate for Linux
To install the SAP Java Connector:
-
Download the SAP Java Connector 3.x (64-bit) for Linux from the SAP Support Portal.
To find out the exact SAP Java Connector version you need to support your SAP BW system, refer to the SAP BW Help.
-
Unzip the file you downloaded to a folder of your choice.
The folder should contain the Sapjco3.jar and libsapjco3.so files.
-
Copy these files to the following location under the Replicate installation directory:
<INSTALL_DIR>/endpoint_srv/endpoints/SAPOdp.
-
Restart all of the Replicate services.
Information noteIf SAP Extractor is already installed, copy the Sapjco3.jar and Sapjco3.dll files from <REPLICATE_INSTALL_DIR>/endpoint_srv/externals to the following locations:
- <REPLICATE_INSTALL_DIR>/endpoint_srv/endpoints/SAPOdp
- <REPLICATE_INSTALL_DIR>/endpoint_srv/endpoints/SAP
Then restart all of the Replicate services as described in Replicate server procedures.
The SAP ODP endpoint will not be available for selection until the Java connector libraries have been installed and the Replicate service has been restarted.
STXL table support
To expose the table STXL for extraction using the SAP ODP endpoint, a custom extractor needs to be created in transaction RSO2 in SAP GUI. This extractor can then be called by the SAP ODP endpoint.