Connections > SAP ODP Extractor connection properties > Prerequisites
  

Prerequisites

Before you use an SAP ODP Extractor connection, the SAP administrator needs to perform certain prerequisite tasks to configure the Secure Agent machine and SAP system.
To process SAP ODP data, you also need to verify if the required licenses are enabled for the SAP system.

Verify the required SAP Notes in the SAP server

To read data from the SAP ODP objects, you need to verify that the required SAP Notes are available in the SAP server.
SAP ODP Extractor Connector uses the ODP Replication APIs version 2.0 when you read data from SAP ODP objects.

Download and configure the SAP libraries

To read data from SAP ODP objects, you need to download and configure the SAP JCo libraries on the Secure Agent machine. If you encounter any issues while you download libraries, contact SAP Customer Support.
  1. 1Go to the SAP Support Portal, and then click Software Downloads.
    2. Note: You need to have SAP credentials to access Software Downloads from the SAP Support Portal.
  2. 2Download the latest version of the 64-bit SAP JCo libraries based on the operating system on which the Secure Agent runs.
    3. Operating System
    SAP JCo Libraries
    Windows
    • - sapjco3.jar
    • - sapjco3.dll
    Linux
    • - sapjco3.jar
    • - libsapjco3.so
  3. 3Copy the JCo libraries to the following directory:
    4. <Informatica Secure Agent installation directory>\apps\Data_Integration_Server\ext\deploy_to_main\bin\rdtm-extra\tpl\sap
    Create the deploy_to_main\bin\rdtm-extra\tpl\sap directory if it does not already exist.
  4. 4Log in to Informatica Intelligent Cloud Services and configure the JAVA_LIBS property for the Secure Agent.
    1. aSelect Administrator > Runtime Environments.
    2. bClick Runtime Environments to access the Runtime Environments page.
    3. cTo the left of the agent name, click Edit Secure Agent.
    4. dFrom the Service list, select Data Integration Server.
    5. eFrom the Type list, select Tomcat JRE.
    6. fEnter the JAVA_LIBS value based on the operating system on which the Secure Agent runs.
      7. Operating System
      Value
      Windows
      ..\bin\rdtm-extra\tpl\sap\sapjco3.jar;..\bin\rdtm\javalib\sap\sap-adapter-common.jar
      Linux
      ../bin/rdtm-extra/tpl/sap/sapjco3.jar:../bin/rdtm/javalib/sap/sap-adapter-common.jar
      Warning: If you copy the value directly from the table, the hyphens (-) in the value might be incorrectly copied. Copy the value to a text editor and make sure that the value you copied is not corrupted.
      The configured JAVA_LIBS property for the Secure Agent.
    7. gClick Save.
  5. 5After you save the JAVA_LIBS value, configure the JVMClassPath property for the Secure Agent.
    1. aFrom the Service list, select Data Integration Server.
    2. bFrom the Type list, select DTM.
    3. cEnter the JVMClassPath value based on the operating system on which the Secure Agent runs.
      4. Operating System
      Value
      Windows
      pmserversdk.jar;..\..\bin\rdtm-extra\tpl\sap\sapjco3.jar;..\..\bin\rdtm\javalib\sap\sap-adapter-common.jar
      Linux
      pmserversdk.jar:../../bin/rdtm-extra/tpl/sap/sapjco3.jar:../../bin/rdtm/javalib/sap/sap-adapter-common.jar
      Warning: If you copy the value directly from the table, the hyphens (-) in the value might be incorrectly copied. Copy the value to a text editor and make sure that the value you copied is not corrupted.
      The configured JVMClassPath property for the Secure Agent.
    4. dClick Save.
    5. eRepeat steps 2 through 5 on every machine where you installed the Secure Agent.
  6. 6Restart the Secure Agent.

Configure SAP user authorization

Configure the SAP user account in the SAP system to process SAP ODP data.
For more information about how to configure SAP user authorization in the SAP system, see SAP user authorizations.
The following table describes the required authorization to read from SAP ODP objects:
Read Object Name
Authorization Values
Value
Activity
Design Time/Run Time
S_RFC
RFC_TYPE - Function Group(FUGR)
SYST
16
Both
RFC_TYPE - Function Module(FUGR)
RFC1
16
Both
RFC_TYPE - Function Module(FUNC)
RFCPING
16
Both
RFC_TYPE - Function Group(FUGR)
RFC_METADATA
16
Both
RFC_TYPE - Function Module(FUNC)
RFC_METADATA_GET
16
Both
RFC_TYPE - Function Module(FUNC)
RFC_GET_FUNCTION_INTERFACE
16
Both
RFC_TYPE - Function Module(FUNC)
RODPS_REPL_CONTEXT_GET_LIST
16
Both
RFC_TYPE - Function Module(FUNC)
RODPS_REPL_ODP_GET_DETAIL
16
Both
RFC_TYPE - Function Module(FUNC)
RODPS_REPL_ODP_GET_LIST
16
Both
RFC_TYPE - Function Module(FUNC)
RODPS_REPL_ODP_OPEN
16
Both
RFC_TYPE - Function Module(FUNC)
RODPS_REPL_ODP_CLOSE
16
Both
RFC_TYPE - Function Module(FUNC)
/INFADI/ODP_FETCH_XML
16
Run Time
RFC_TYPE - Function Module(FUNC)
RODPS_REPL_ODP_FETCH
16
Run Time
RFC_TYPE - Function Module(FUNC)
RODPS_REPL_ODP_FETCH_XML
16
Run Time
RFC_TYPE - Function Module(FUNC)
DDIF_FIELDINFO_GET
16
Both
S_BTCH_ADM
FIELD NAME - BTCADMIN
Y
N/A
Both
S_BTCH_JOB
FIELD NAME - JOBACTION
RELE
RELE(Release Jobs)
Both
FIELD NAME - JOBGROUP
' '
N/A
Both
S_RS_ODP_H
FIELD NAME - RSODPHNAME
*
3
Both
FIELD NAME - RSODPHPKG
*
3
Both
S_RO_OSOA
FIELD NAME - OLTPSOURCE
*
3
Both
FIELD NAME - OSOAAPCO
*
3
Both
FIELD NAME - OSOAPART
Data, Definition
3
Both
S_RS_HYBR
FIELD NAME - RSHYBRPROV
'*'
3
Both
FIELD NAME - RSHYBRPROJ
Definition
3
Both
S_RS_ICUBE
FIELD NAME - OLTPSOURCE
*
3
Both
FIELD NAME - OSOAAPCO
*
3
Both
FIELD NAME - OSOAPART
Data, Definition
3
Both
S_RS_IOMAD
FIELD NAME - RSINFOAREA
*
3
Both
FIELD NAME - RSAPPLNM
*
3
Both
FIELD NAME - RSIOBJNM
*
3
Both
S_RS_MPRO
FIELD NAME - RSINFOAREA
*
3
Both
FIELD NAME - RSMPRO
*
3
Both
FIELD NAME - RSMPROOBJ
Data
3
Both
S_RS_ODSO
FIELD NAME - RSINFOAREA
*
3
Both
FIELD NAME - RSODSOBJ
*
3
Both
FIELD NAME - RSODSPART
Data
3
Both
S_ADMI_FCD
FIELDNAME - S_ADMI_FCD
PADM
N/A
Both

Configure the Secure Network Communication protocol

To use the SAP ODP Extractor connection with the Secure Network Communication (SNC) protocol, you need to configure the SNC protocol on both the SAP server and Secure Agent machine.
To create a connection with the SNC protocol, use the application server SNC connection and load balancing server SNC connection.
For more information about the prerequisites and steps to configure an SAP SNC connection, see Configure the SAP Secure Network Communication protocol Informatica How-To Library article.