Connections > SAP Table Connector connection properties > Prepare for configuration
  

Prepare for configuration

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

Download and configure the SAP libraries

To read data from or write data to SAP tables, you need to download the SAP JCo libraries and configure them on the Secure Agent machine. If you encounter any issues with downloading the 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 SAP NetWeaver RFC SDK 7.50 libraries that are specific to the operating system that hosts the Secure Agent process.
    3. The following table lists the libraries corresponding to the different operating systems:
    Operating System
    SAP NetWeaver RFC SDK Libraries
    Linux 64
    • - libicudata.so.50
    • - libicui18n.so.50
    • - libicuuc.so.50
    • - libsapnwrfc.so
    • - libsapucum.so
    Windows 64
    • - icudt50.dll
    • - icuin50.dll
    • - icuuc50.dll
    • - libsapucum.dll
    • - sapnwrfc.dll
  3. 3Copy the SAP NetWeaver RFC SDK 7.50 libraries to the following directory:
    4. <Informatica Secure Agent installation directory>\apps\Data_Integration_Server\ext\deploy_to_main\bin\rdtm
    Create the deploy_to_main\bin\rdtm directory if it does not already exist.
  4. 4Set the following permissions for each NetWeaver RFC SDK library:
  5. 5From the SAP Support Portal, download the latest version of the 64-bit SAP JCo libraries based on the operating system on which the Secure Agent runs:
    6. Secure Agent System
    SAP JCo Libraries
    Windows
    sapjco3.jar
    sapjco3.dll
    Linux
    sapjco3.jar
    libsapjco3.so
  6. 6Copy the JCo libraries to the following directory:
    7. <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.
  7. 7Log 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 on Windows.
    7. gClick Save.
    8. hRepeat steps 2 through 7 on every machine where you installed the Secure Agent.
  8. 8Restart the Secure Agent.

Configure SAP user authorization

Configure the SAP user account in the SAP system to process SAP table 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 tables:
Read Object Name
Required Authorization
S_BTCH_JOB
DELE, LIST, PLAN, SHOW.
Set Job Operation to RELE.
S_PROGRAM
BTCSUBMIT, SUBMIT
S_RFC
SYST, SDTX, SDIFRUNTIME, /INFADI/TBLRDR, RFC1
S_TABU_DIS / S_TABU_NUM
Provide SAP table name from which you want to read data.
The following table describes the required authorization to write to SAP tables:
Write Object Name
Required Authorization
S_RFC
/INFADI/GET_TRANSPORT_VERSION, /INFADI/ZPMW, DDIF_FIELDINFO_GET, RFC1, RFCPING, RFC_READ_TABLE
S_TABU_DIS / S_TABU_NUM
Provide SAP table name where you want to write data.
Note: You need to add S_TABU_DIS or S_TABU_NUM based on the version of the SAP system. For more information about S_TABU_DIS or S_TABU_NUM, see the SAP documentation.

Install transport files to read from an SAP table

To read data from SAP tables from a Unicode SAP system, install the SAP Table Reader transport files from the Secure Agent directory to the SAP system.
Ensure that the transport files you install on the SAP machines are the latest. Get the latest transport files from the following directory:
<Informatica Secure Agent installation directory>\downloads\package-SAPConnector.<Latest version>\package\rdtm\sap-transport\SAPTableReader

Prerequisites to install the transport files

Before you install the SAP Table Reader transports, you need to perform the prerequisite tasks.
The following table lists the transports that you need to install based on the SAP source type that you want to access:
Data and Cofile Names
Transport Request
Functionality
TABLE_READER_R900059.ER6
TABLE_READER_K900059.ER6
ER6K900059
To read data from SAP transparent tables, cluster tables, and pool tables, install only the TABLE_READER transport.
TABLE_READER_Addon_R900085.S4N
TABLE_READER_Addon_K900085.S4N
S4NK900085
To read data from ABAP CDS views, install both the TABLE_READER and TABLE_READER_Addon transports.
Use the TABLE_READER_Addon transports for SAP NetWeaver 7.50 SP4 version and later.
Whenever you install the TABLE_READER transport, you need to reinstall the TABLE_READER_Addon transport even though there is no change in the TABLE_READER_Addon transport version.
Note: Ensure that you first install the TABLE_READER transport and only then install the TABLE_READER_Addon transport.

Installing transport files

To install the SAP Table Reader transport files, perform the following steps:
  1. 1Find the transport files in the following directory on the Secure Agent machine:
    2. <Informatica Secure Agent installation directory>\downloads\package-SAPConnector.<Latest version>\package\rdtm\sap-transport\SAPTableReader
  2. 2Copy the cofile transport file to the Cofile directory in the SAP transport management directory on each SAP machine that you want to access.
    3. The cofile transport file uses the following naming convention: TABLE_READER_K<number>.ER6.
  3. 3Remove "TABLE_READER_" from the file name to rename the cofile.
    4. For example, for a cofile transport file named TABLE_READER_K900059.ER6, rename the file to K900059.ER6.
  4. 4Copy the data transport file to the Data directory in the SAP transport management directory on each SAP machine that you want to access.
    5. The data transport file uses the following naming convention: TABLE_READER_R<number>.ER6.
  5. 5Remove "TABLE_READER_" from the file name to rename the file.
  6. 6To import the transports to SAP, in the STMS, click Extras > Other Requests > Add and add the transport request to the system queue.
  7. 7In the Add Transport Request to Import Queue dialog box, enter the request number for the cofile transport.
    8. The request number inverts the order of the renamed cofile as follows: ER6K<number>.
    For example, for a cofile transport file renamed as K900059.ER6, enter the request number as ER6K900059.
  8. 8In the Request area of the import queue, select the transport request number that you added, and click Import.
  9. 9If you are upgrading from a previous version of the Informatica Transports, select the Overwrite Originals option.

Install transport files to write to an SAP table

To write data to SAP custom tables that have been created under the customer namespace, install the SAP Table Writer transport files.
To get and install the latest SAP Table Writer transport files, contact Informatica Global Customer Support.