SAP ERP

1 Connecting to SAP ERP

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.

1.1 Connecting to a Distributed SAP System

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.

1.2 Connecting to a Custom Application Server

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.

1.3 Configuring Secure Network Connections

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.

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.

· 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.

2 Connecting with the RFC APIs

2.1 Using the Classic RFC SDK

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.

2.2 Using the Classic RFC SDK with Unicode Support

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

2.3 Using the NetWeaver RFC SDK

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

2.4 Required RFCs

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

2.5 Filtering SAP Entities

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.

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.