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. |
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 Mass Ingestion. 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. If you enter the host name or IP address of the SAP application server in this field, 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. If you enter the system number of the SAP application server in this field, 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. |
Property | Description |
|---|---|
Saprfc.ini Path | The path and file name, or the path to the sapnwrfc.ini file. 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 This property is required if you want to use the connection to write to SAP tables. 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 | 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 | 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 to 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. |