SAP Connector Guide > Part III: Connections > SAP Connections > SAP Table Connections
  

SAP Table Connections

SAP Table connections enable you to access data directly from SAP tables. You can use the SAP Table connection type in Data Synchronization tasks, mappings, and Mapping Configuration tasks.
You can use the SAP Table connection type to read data from transparent tables, cluster tables, pool tables, or views. You can also use the SAP Table connection type to write data to custom transparent tables.
To enable the Secure Agent to connect to SAP through HTTPS, you must enable HTTPS and specify the keystore details when you configure an SAP Table connection. To read SAP table sources through HTTPS, specify an SAP Table connection configured for HTTPS when you create Data Synchronization tasks, mappings, or Mapping Configuration tasks.

SAP Table Connection Properties

To process SAP table data, select the SAP Connector connection type and configure the following properties:
Connection Property
Description
Runtime Environment
Runtime environment that contains the Secure Agent that you want to use to access SAP tables.
Username
SAP user name with the appropriate user authorization.
Password
SAP password.
Client
SAP client number.
Language
Language code that corresponds to the SAP language.
Saprfc.ini Path
Local directory to the sapnwrfc.ini file.
To write to SAP tables, use the following directory:
<Informatica Secure Agent Installation Directory>/main/bin/rdtm
Destination
DEST entry that you specified in the sapnwrfc.ini file for the SAP application server.
Destination is case sensitive.
Note: Use all uppercase letters for the destination.
Port Range
HTTP port range. The SAP Table connection uses the specified port numbers to connect to SAP tables using the HTTP protocol. Ensure that you specify valid numbers to prevent connection errors. Default: 10000-65535.
Enter a range in the default range, for example, 10000-20000. When a range is outside the default range, the connection uses the default range.
Test Streaming
Tests the connection. When selected, tests the connection using both RFC and HTTP protocol. When not selected, tests connection using HTTP protocol.
Https Connection
When selected, connects to SAP through HTTPS protocol. To successfully connect to SAP through HTTPS, verify that an administrator has configured the machines that host the Secure Agent and the SAP system.
Keystore Location
The absolute path to the JKS keystore file.
Keystore Password
The destination password specified for the .JKS file.
Private Key Password
The export password specified for the .P12 file.

SAP Connection Rules and Guidelines

The following SAP data types are not supported for the SAP table writer at this time:
Tasks that include these data types for the SAP table writer might fail.