Account Types
SAP JCo Account
Label | Specify a unique and meaningful label for the account instance |
---|
Username
| Specify the SAP username. Username is not required for authentication through SAP SNC. See Advanced JCo Properties for more details. |
|
---|
Password
| Specify a password for the username. Password is not required for authentication through SAP SNC. See Advanced JCo Properties for more details. |
|
---|
Language*
| Specify the SAP language code. |
---|
Client* | Specify the SAP client. |
---|
Application server* | Specify the SAP application server address. |
---|
System number* | Specify the system instance number. |
---|
Peak limit
| Specify the maximum number of active connections that can be created simultaneously for a destination. Recommended value could be <100 as too many connections may impact JCC performance. |
Default value: 5 |
---|
Connection pool capacity | Specify the maximum number of idle connections kept open by the destination. No connection pooling takes place when the value is 0. |
---|
Router string
| Specify the SAP Router string required for making connections to systems that are behind the SAP Router. An SAP router string contains a chain of SAP routers with their port numbers and has the form (/H/<host>[/S/<port>][/W/<password, if provided>])+ . For more information on router strings, see Router Strings in SAP Help. |
---|
Enable trace
| Activates the JCo traces to get more information that can help analyze the connection-related errors. Default value: Not selected |
---|
Reload Metadata on Validate | Select this checkbox to clear the JCo Metadata cache on the plex node before validating the account. Default value: Not selected |
---|
Advanced JCo properties | This field set enables you to specify JCo parameters and respective values for SAP Secure Network Communications (SNC) authentication. Only one JCo parameter can be specified in each row. Click to add a new row in this table and define the values accordingly. This field set comprises the following fields: - Property name
- Property value
Leave the Username and Password fields blank while passing values in the form of JCo properties, as part of SAP SNC authentication. |
|
---|
Property name | Specify the name of the JCo parameter to be passed for SAP SNC authentication. Alternatively, select the parameter from the Suggestions drop-down list. Default value: None Example: jco.client.user , jco.client.passwd , jco.client.cert1
|
---|
Property value | Specify the value for the JCo parameter needed for SAP SNC authentication. If you have the JCo parameters defined at a Pipeline-level, pass the Pipeline parameter names as expressions. Default value: None Example: johndoe , pass*word#4
|
---|
Account EncryptionStandard Encryption | If you are using Standard Encryption, the High sensitivity settings under Enhanced Encryption are followed.
|
---|
Enhanced Encryption | If you have the Enhanced Account Encryption feature, the following describes which fields are encrypted for each sensitivity level selected for this account. Account: - High: Password
- Medium + High: Username, password
- Low + Medium + High: Username, password, Application Server, System number
|
---|
|
SAP Load Balanced JCo Account
The SAP Load Balanced JCo Account is used to connect to a message server. Label*
| Specify a unique and meaningful label for the account instance |
---|
Username*
| Specify the SAP username for the account. Username is not required for authentication through SAP SNC. See Advanced JCo Properties for more details. |
|
---|
Password
| Specify a password for the username. Password is not required for authentication through SAP SNC. See Advanced JCo Properties for more details. |
|
---|
Language* | Specify the SAP language code. |
---|
Client* | Specify the SAP client. |
---|
Message server* | Specify the SAP message server address. |
---|
System ID* | Specify the SAP system ID. |
---|
Logon group | Specify the SAP logon group. |
---|
Peak limit*
| Specify the maximum number of active connections that you can create simultaneously for a destination. Recommended value could be <100 as too many connections may impact JCC performance. |
Default value: 5 |
---|
Connection pool capacity* | Specify the maximum number of idle connections to be kept open by the destination. No connection pooling takes place when the value is 0. |
---|
Router string
| Specify the SAP Router string required for making connections to systems that are behind the SAP Router. An SAP router string contains a chain of SAP routers with their port numbers and has the form (/H/<host>[/S/<port>][/W/<password, if provided>])+ . For more information on router strings, see Router Strings in SAP Help. |
---|
Enable trace
| Activates the JCo traces to get more information that can help analyze the connection-related errors. Default value: Not selected |
---|
Reload Metadata on Validate | Select this checkbox to clear the JCo Metadata cache on the plex node before validating the account. Default value: Not selected |
---|
Advanced JCo properties | This field set enables you to specify JCo parameters and respective values for SAP Secure Network Communications (SNC) authentication. Only one JCo parameter can be specified in each row. Click to add a new row in this table and define the values accordingly. This fieldset comprises the following fields: - Property name
- Property value
Leave the Username and Password fields blank while passing their values in the form of JCo properties, as part of SAP SNC authentication. |
|
---|
Property name | Specify the name of the JCo parameter to be passed for SAP SNC authentication. Alternatively, select the parameter from the Suggestions drop-down list. Default value: None Example: jco.client.user , jco.client.passwd , jco.client.cert1
|
---|
Property value | Specify the value for the JCo parameter needed for SAP SNC authentication. If you have the JCo parameters defined at a Pipeline-level, pass the Pipeline parameter names as expressions. Default value: None Example: johndoe , pass*word#4
|
---|
Account EncryptionStandard Encryption | If you are using Standard Encryption, the High sensitivity settings under Enhanced Encryption are followed.
|
---|
Enhanced Encryption | If you have the Enhanced Account Encryption feature, the following describes which fields are encrypted for each sensitivity level selected for this account. Account: - High: Password
- Medium + High: Username, password
- Low + Medium + High: Username, password, Application Server, System number
|
---|
|
SAP Configurations
Installing JCO Library
Install the SAP Java Connection (JCO) library for this Snap Pack to work.
Windows
- In all nodes of the Snaplex, install
sapjco3.dll
in %SL_ROOT%\ldlib (usually, c:\opt\Snaplogic\ldlib). - Upload the
sapjco3.jar
file into the project that you want to use for SAP integration. - Set the Windows PATH variable to point to c:\opt\Snaplogic\ldlib. Restart the Snaplex (JCC).
If an MSHOST is configured, add sapms<SystemID><MSHOSTPort>/tcp, for example: sapmsABA 3301/tcp
,
to %WINDIR%\System32\drivers\etc\services.
Linux
- In all nodes of the Snaplex, install
libsapjco3.so
in $SL_ROOT/ldlib (usually /opt/Snaplogic/ldlib). - Install
libsapjco3.jnilib
in $SL_ROOT/ldlib (usually /opt/Snaplogic/ldlib). - Upload the
sapjco3.jar
file into the project that you want to use for SAP integration. Restart the Snaplex (JCC). - If an MSHOST is configured, add
sapms<SystemID><MSHOSTPort>/tcp
, for example: sapmsABA 3301/tcp
,
to /etc/services. For example, sapmsABA 3301/tcp
.
Please update the following native library files under $SL_ROOT/ldlib/: a) libsapjco3.so for Linux-based JCC nodes. b) sapjco3.dll for Windows-based JCC nodes. This is due to the parameter change in JCo (Java Connector) from 3.0 to 3.1. According to the JCo documentation, parameter jco.use_repository_roundtrip_optimization is used to optimize the metadata lookups. In JCo 3.0.6, the default value of the parameter is 0, whereas, in JCo 3.1.4, the default value of the parameter is 1. In the 3.0 driver, if the function module is not remote-enabled, the driver would still try to call the function module and let the SAP server inform you regarding the failure. However, in the latest driver, if the function module is not remote-enabled, the JCo would detect it in advance, and let the Snap fail. If you want to revert to the previous behavior, the JCo properties could be set through the jvm_options:
jcc.jvm_options=-Djco.use_repository_roundtrip_optimization=0 |
BAPI and IDoc Integration
BAPI (Business Application Programming Interface) and IDoc (Intermediate Document) are different interfaces that SAP ERP provides to enable business-data exchange across SAP and non-SAP platforms.
BAPI is a library of functions stored on the SAP platform that can be called by SAP or non-SAP platforms to perform specific operations. All related data is exchanged immediately and not stored anywhere during transit. SnapLogic uses the RFC (Remote Function Call) protocol provided by the SAP Java Component to call BAPI remotely.
IDocs, on the other hand, are formatted data containers that can be transferred between SAP platforms or non-SAP platforms. IDocs are stored in database tables on the SAP side, and can be sent to a receiver system using their ALE technology.
The SAP Execute Snap is calls a BAPI function, while the IDoc (Document) Listener, IDoc Read and IDoc Write Snaps use IDocs to integrate with SAP.
Configuring SAP for BAPI Integration
There is no additional configuration required for standard BAPI integration other than ensuring that the configured SAP user has sufficient roles/privileges to access and invoke the desired BAPIs. If the standard functions do not meet your integration requirements, you must design and implement a custom function according to your needs.
Configuring SAP for IDoc Integration
The following configurations are required in SAP to send or receive IDocs.
Set up the logical system and distribution model, and generate the partner profile. For more information, see SAP Help: Implementation - IDoc Interface/ALE - SAP Library and SCN Welcome | SCN.
- Add a logical system using transaction code SALE.
- Create/Change the distribution model using transaction code SALE or BD64.
- You may either create a new model view or edit an existing one. Then add sender/receiver (Logical System) and message types.
- Generate partner profiles. Use the transaction code we20.
Additional SAP Configuration for Outbound IDoc Integration
The following configurations are required in SAP to send outbound IDocs to the SnapLogic SAP account.
- Register the external program in the SAP gateway by editing the reginfo file. For additional information, see Gateway Security Files secinfo and reginfo.
- Import reginfo in Gateway using the transaction code SMGW.
- Create RFC Destination of Type = 'T' (TCP/IP). For additional information, see SAP JCo Server Programming.
- Check the gateway monitor to ensure that the connection is registered correctly.
- Create a port using transaction code WE21.
Local TID Database Configuration (Outbound IDoc Only)
When listening for outbound IDocs sent from SAP, the SAP Snaps require a local database to track the TIDs for the IDocs received and processed successfully. The SnapLogic SAP account must be able to access that database. If the database is not supported by default, you must obtain the appropriate JDBC driver and add it to the SnapLogic SAP Account.