Set Host, User, Password, Client, and SystemNumber. Additionally, set Language to the ISO 639-1 language code you use to log into SAP ERP. The default is "EN".
To connect to a machine different from the Host machine, set GatewayHost. The GatewayService property indicates the service on the machine; by default this is HTTP.
To connect to a distributed system or systems with other configurations:
UseSimpleNames: SAP ERP supports attribute names with special characters that many database-oriented tools do not support. You can use this property to replace any nonalphanumeric character with an underscore.
InitialValueMode: Set this to return null or the exact value returned by SAP for fields that have an undefined or unknown value. By default the provider returns null.
If you are connecting to a distributed SAP system, such as a system using load balancing, you must set the following additional properties. An administrator can obtain these connection properties on the Connection tab of the System Entry Properties dialog.
· SystemId: Set this property to the value in the System Id box.
The SystemId property is the System Id or R3Name of the SAP system. The system Id is a string with a maximum of three characters.
· MessageServer: Set this property to the value in the Message Server box. If a value is specified in the SAProuter box, prepend the value in the SAProuter box onto the value for the MessageServer connection string property.
The MessageServer property must be specified when connecting to an SAP system using load balancing.
· Group: If a value is specified, set this property to the value in the Group/Server box.
The Group property specifies the logon group being used. The default in most SAP systems will be PUBLIC.
If you are using a message server service other than HTTP, set MessageServerService.
If you are connecting to an SAP system with a dedicated application server or a custom application server, you can obtain the following connection properties on the Connection tab of the System Entry Properties dialog.
· SystemId: Set this property to the value in the System Id box.
The SystemId property is the System Id or R3Name of the SAP system. The system Id is a string with a maximum of three characters.
· Host: Set this property to the value in the Application Server box.
The Host property specifies the host name of the target system. This value can be a regular host name, IP address, or SAProuter address.
· SystemNumber: Set this property to the value in the SystemNumber box.
The SystemNumber property defines the target system.
If the administrator has configured Secure Network Communication (SNC), you need to set the following additional properties. You can obtain the following SNC connection string properties on the Network tab of the System Entry Properties dialog.
· SNCMode: If the "Activate Secure Network Connections" checkbox is enabled, set the SNCMode connection string property to True. If this checkbox is disabled, set the SNCMode connection property to False.
The SNCMode connection property is a boolean value determining if you are using SNC. The default value is False.
· SNCPartnerName: Set this property to the value in the SNC Name box.
The SNCPartnerName property specifies the application server's SNC name. For example: p:CN=IDS, OU=IT, O=CSW, C=DE
· SNCName: Optional. Set this property to the value in the SNC Name box.
The SNCName property specifies the name of the SNC connection. Set this property to make sure that the correct SNC name is used for the connection.
· SNCQop: Set this property to the selected option in the Secure Network Settings section. For example, if the Integrity option is selected, set the SNCQop property to 3.
· SNCLibPath: Set this property to the path and filename of your SNC library.
The SNCLibPath property specifies the full path to the security library you are using. For example, C:\Secude\secude.xll.
By default, the Classic RFC SDK without Unicode support provided with the library librfc32.dll will be used. To use it, simply place the assembly in the appRulesPortal\Bin folder.
To use the Classic RFC SDK with Unicode support provided with the library librfc32u.dll, set ConnectionType to Classic_Unicode. The following libraries from the RFC SDK must also be available at run time, in addition to librfc32u.dll:
icudt30.dll
icuin30.dll
icuuc30.dll
To use the NetWeaver RFC SDK provided with the library sapnwrfc.dll, set ConnectionType to NetWeaver. The following libraries from the RFC SDK must be available at run time, in addition to sapnwrfc.dll:
icudt30.dll
icuin30.dll
icuuc30.dll
libicudecnumber.dll
libsapucum.dll
The RFCs used by the connector are listed as follows. If any listed below are not available, some or all functionality may not work. T-Code SE37 may be used to view available function modules in SAP.
DDIF_FIELDINFO_GET
RFC_GET_FUNCTION_INTERFACE
RFC_GET_STRUCTURE_DEFINITION
RFC_GET_SYSTEM_INFO
RFC_GET_UNICODE_STRUCTURE
RFC_READ_TABLE
SLDAG_CHECK_FOR_UNICODE
The following connection properties provide basic functionality to select the entities you need:
TableMode: Filters tables from the DD02L system table in SAP.
QueryMode: Filters queries by your SAP workspace.
StoredProcedureFilter: Filters SAP function modules, which are modeled as stored procedures.
The following are the connection properties for SAPERP. Not all properties are required. Enter only property values pertaining to your installation. Several properties will be automatically initialized with the appRules defaults.
1
Apply authentication only. The identities of communication partners are verified.
2
Apply integrity protection. The SAP system detects any changes or manipulation of the data exchanged.
3
Apply privacy protection. This level provides integrity and authentication. The SAP system encrypts the messages being transferred. No one but the two communication partners can read or tamper with the data. This is the maximum level of protection.
8
Apply the default protection.
9
Apply the maximum protection.
Property
Description
Authentication
Client
The client authenticating to the SAP system.
ConnectionType
The type of connection you are making.
Group
The Logon Group being used. This typically only needs to be specified when connecting to an SAP system that uses load balancing.
Host
Host name of the target system.
MessageServer
The message server must be specified when connecting to an SAP system that uses load balancing.
MessageServerService
The message server service you wish to connect to.
Password
The password used to authenticate to the SAP system.
RFCUrl
The URL of the SOAP interface to connect with SAP.
SystemId
The System Id or R3Name of the SAP System is a string with a maximum of three characters. It is often used in load balancing connections.
SystemNumber
The number by which the target system is defined. Used when setting the Host connection property.
User
The user that is authenticating to the SAP system.
X509Certificate
The X509 certificate used for login as an alternative to User , and Password .
Firewall
FirewallPassword
A password used to authenticate to a proxy-based firewall.
FirewallPort
The TCP port for a proxy-based firewall.
FirewallServer
The name or IP address of a proxy-based firewall.
FirewallType
The protocol used by a proxy-based firewall.
FirewallUser
The user name to use to authenticate with a proxy-based firewall.
Logging
Logfile
A path to the log file.
MaxLogFileCount
A string specifying the maximum file count of log files. When the limit is hit, a new log is created in the same folder with the date and time appended to the end and the oldest log file will be deleted.
MaxLogFileSize
A string specifying the maximum size in bytes for a log file (for example, 10 MB). When the limit is hit, a new log is created in the same folder with the date and time appended to the end.
Verbosity
The verbosity level that determines the amount of detail included in the log file.
Misc
Charset
The system code page used for Unicode to multibyte translations.
ConnectionLifeTime
The maximum lifetime of a connection in seconds. Once the time has elapsed, the connection object is disposed.
ConnectionString
***
Destination
Reference to an existing destination that is specified in a local saprfc.ini file.
EndianType
The endian type for the SAP server. Enter either Big or Little.
GatewayHost
The gateway host you wish to connect to.
GatewayService
The gateway service you wish to connect to.
GenerateSchemaFiles
Determines how schema files should be generated.
InitialValueMode
How to treat initial values in SAP.
Language
The language value to be used when connecting to the SAP system.
MaxRows
Limits the number of rows returned rows when no aggregation or group by is used in the query. This helps avoid performance issues at design time.
Other
These hidden properties are used only in specific use cases.
Pagesize
The number of results to return per page from SAP. Only used for SAP tables.
PoolIdleTimeout
The allowed idle time for a connection before it is closed.
PoolMaxSize
The maximum connections in the pool.
PoolMinSize
The minimum number of connections in the pool.
PoolWaitTime
The max seconds to wait for an available connection.
PseudoColumns
This property indicates whether or not to include pseudo columns as columns to the table.
QueryMode
Determines which SAP queries will be displayed as views, if any.
ReadTableFunction
The function to use for reading table data.
SSLServerCert
The certificate to be accepted from the server when connecting using TLS/SSL.
StoredProcedureFilter
A filter indicating which function modules to report as stored procedures.
SupportEnhancedSQL
This property enhances SQL functionality beyond what can be supported through the API directly, by enabling in-memory client-side processing.
TableMode
Determines which SAP tables will be displayed as views if any.
Timeout
The value in seconds until the timeout error is thrown, canceling the operation.
UseConnectionPooling
This property enables connection pooling.
UseLabels
Boolean determining if labels should be used for table and column names.
UseSimpleNames
Boolean determining if simple names should be used for tables and columns.
UseUnicodeRFC
A boolean indicating if you want to use RFC_GET_UNICODE_STRUCTURE to get structure information.
Proxy
ProxyAuthScheme
The authentication type to use to authenticate to the ProxyServer proxy.
ProxyAutoDetect
This indicates whether to use the system proxy settings or not. This takes precedence over other proxy settings, so you'll need to set ProxyAutoDetect to FALSE in order use custom proxy settings.
ProxyExceptions
A semicolon separated list of hosts or IPs that are exempt from connecting through the ProxyServer .
ProxyPassword
A password to be used to authenticate to the ProxyServer proxy.
ProxyPort
The TCP port the ProxyServer proxy is running on.
ProxyServer
The hostname or IP address of a proxy to route HTTP traffic through.
ProxySSLType
The SSL type to use when connecting to the ProxyServer proxy.
ProxyUser
A user name to be used to authenticate to the ProxyServer proxy.
Security
SNCLibPath
An optional input detailing the path and file name of the external library.
SNCMode
A boolean determining if you are using SNC. Set this to true to use SNC.
SNCName
An optional input with the name of your SNC connection.
SNCPartnerName
The application server's SNC name. This is a required input when using SNC.
SNCQop
The quality of protection for your SNC connection.