Connections > SAP Table Connector connection properties > 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.
Use Secret Vault
Stores sensitive credentials for this connection in the secrets manager that is configured for your organization.
This property appears only if secrets manager is set up for your organization.
This property is not supported by Data Ingestion and Replication.
When you enable the secret vault in the connection, you can select which credentials that the Secure Agent retrieves from the secrets manager. If you don't enable this option, the credentials are stored in the repository or on a local Secure Agent, depending on how your organization is configured.
For information about how to configure and use a secrets manager, see Secrets manager configuration.
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