SAP Table Connector > Connections for SAP Table Connector > Connect to SAP table

Connect to SAP table

Let's configure the SAP Table Connector connection properties to connect to SAP tables and SAP BW/4HANA ADSO objects.

Before you begin

Before you get started, you'll need to configure the Secure Agent machine and SAP system to establish an SAP Table connection.

Check out Prerequisites to learn more about these tasks.

Connection details

The following table describes the basic connection properties:

Property	Description
Connection Name	Name of the connection. Each connection name must be unique within the organization. Connection names can contain alphanumeric characters, spaces, and the following special characters: _ . + -, Maximum length is 255 characters.
Description	Description of the connection. Maximum length is 4000 characters.
Type	SAP Table Connector
Runtime Environment	The name of the runtime environment where you want to run tasks. Select a Secure Agent or serverless runtime environment. For more information about how to configure a serverless environment, see Use the serverless runtime environment.
Username	The user name with the appropriate user authorization to connect to the SAP account.
Password	The password to connect to the SAP account.
Client	The client number of the SAP application server. Get the required client number from the SAP system to which you want to connect.
Application Server	The host name or IP address of the SAP application server when you read from SAP tables. If you enter the host name or IP address of the SAP application server in this field to read from SAP tables, do not enter the directory of the sapnwrfc.ini file in the Saprfc.ini Path field and the DEST entry in Destination field. Note: This property doesn't apply if you create the connection to write to SAP tables.
System Number	The system number of the SAP application server when you read from SAP tables. If you enter the system number of the SAP application server in this field to read from SAP tables, do not enter the directory of the sapnwrfc.ini file in the Saprfc.ini Path field and the DEST entry in Destination field. Note: This property doesn't apply if you create the connection to write to SAP tables.
Language	Language code that corresponds to the SAP language. Get the required language code from the SAP system to which you want to connect.

Advanced settings

The following table describes the advanced connection properties:

Property	Description
Saprfc.ini Path	The path and file name or the path to the sapnwrfc.ini file. This property is required if you want to use the connection to write to SAP tables. Enter the following directory where the sapnwrfc.ini file is available: <Informatica Secure Agent installation directory>/apps/Data_Integration_Server/ext/deploy_to_main/bin/rdtm For the serverless runtime environment, the sapnwrfc.ini file is copied from the AWS location to the following serverless agent directory: /data2/home/cldagnt/SystemAgent/apps/Data_Integration_Server/ext/deploy_to_main/bin/rdtm For more information about how to create the sapnwrfc.ini file, see Configure the sapnwrfc.ini file. If you enter the directory of the sapnwrfc.ini file in this field, do not enter the host name or IP address, and system number of the SAP application server in the Application Server and System Number fields.
Destination	DEST entry that you specified in the sapnwrfc.ini file for the SAP application server. Use all uppercase letters for the destination. This property is required if you create the connection to write to SAP tables. If you enter the DEST entry in this field, do not enter the host name or IP address, and system number of the SAP application server in the Application Server and System Number fields.
Port Range	HTTP port range. The SAP Table connection uses the specified port numbers to connect to SAP tables using the HTTP protocol. Default range is 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 RFC protocol.
Https Connection	Connects to SAP through HTTPS protocol. To successfully connect to SAP through HTTPS, verify that your administrator has configured the Secure Agent machine and the SAP system. For more information about how to connect to SAP through HTTPS, see Configure HTTPS to connect to SAP.
Keystore Location	Absolute path and file name of the keystore file to connect to SAP. Specify both the path and file name in the following format: <Directory>/<Keystore file name>.jks
Keystore Password	The destination password to access the keystore file.
Private Key Password	The export password to access the .P12 file.
SAP Additional Parameters	Additional SAP properties that the Secure Agent uses to connect to the SAP system as an RFC client. Specify the required RFC-specific parameters and connection information that enable the Secure Agent to connect to SAP. For example, you can specify the load balancing parameters listed in the following sample: MSHOST=<Host name of the message server> R3NAME=<Name of the SAP system> group=<Group name of the application server> If you configure a parameter in other connection property fields, do not enter the same parameter value in the SAP Additional Properties field. For more information about RFC-specific parameters, see the SAP documentation.

Related links