SAP On-premise

SAP JCo connector

SAP is an enterprise resource planning software used by the largest corporations in the world.

Workato SAP On-premise connector allows you to connect with SAP system on-premises or on a server behind a corporate firewall. The connector supports using IDoc or RFC to communicate with SAP. Using Workato, you can build powerful automation around SAP and other applications, without writing a line of code.

Supported SAP versions

Workato's On-premise SAP connector supports SAP ERP ECC 6.0 and later, SAP CRM, SAP SRM, SAP SCM, and any other modules compatible with the NetWeaver platform.

It requires the SAP Java Connector (JCo) to work. Please refer to SAP Note 1077727 - SAP JCo 3.0 release and support strategy for details on JCo versions.

Supported communication method

The connector supports the following communication methods with SAP:

  • Inbound IDoc (send IDoc to SAP)
  • Outbound IDoc (receive IDoc from SAP)
  • Transactional RFC (invoke synchronous RFC and BAPI in SAP)

Introduction to IDoc

The term IDoc stands for intermediate document. It is simply a data container used to exchange information between SAP systems or between SAP and 3rd-party systems.

IDoc is an open interface which is independent of the internal data structure stored in SAP, and independent of sending or receiving applications. Any application can use IDoc by following the syntax and semantics of IDoc.

IDoc is independent of the direction of data exchange, having both Outbound and Inbound capabilities.

Introduction to RFC

RFC is a SAP protocol that handles communications between SAP systems and third party applications. It is the process of calling a function module which is residing on a different machine from the caller program.

Workato can call SAP RFCs in an SAP system to fetch the data returned or make synchronous updates to the SAP data.

How to connect to SAP On-premise on Workato

The SAP On-premise connector can connect to both on-premise SAP system and SAP system on a server behind the corporate firewall.

Please follow these steps strictly in this sequence to configure the connection:

If you encounter error at any step, please review the Troubleshooting section.

Configure IDoc and RFC in SAP

Step 1: Register a Program ID for Workato in SAPGUI

In SAP, use Transaction SM59 to create RFC Destination of type TCP/IP (type T).

RFC connections

In the Technical Settings tab, select the Registered Server Program option and provide the PROGRAM ID name which has been decided for Workato.

RFC destination

The RFC Connection can be tested once the Workato On-prem Agent (OPA) has been setup (instructions below).

Step 2: Define a port for Workato

Use the transaction WE21 to define a port for sending and receiving IDocs of type Transactional RFC.

IDoc ports

Enter your RFC Destination created in the previous step.

IDoc port for Workato

Step 3: Create Logical System for Workato

Use Transaction SALE and define Logical System

Display IMG

Create new Logical System to interface IDocs. The name selected for Logical System will be used for Partner Profile creation in the below steps.

Display IMG

Step 4: Create Partner Profile for Workato

Use Transaction WE20 to define a partner profile to send and receive the IDocs

Partner profiles

Create a partner profile of type Logical System and provide the same name as the Logical System. In this configuration, you define the Message types that you want to be sent and received from Workato system.

Important Note: Only the Message types configured here will be available to use in Workato recipe.

Message types

Step 5: Create a distribution model for the partner and message type which will be interfaced with Workato

Use Transaction BD64 to create a Distribution Model for the IDocs which need to be interfaced with Workato system. The direction of flow for the IDocs are configured in this transaction based on the attributes Sender, Receiver and Message type.

Example:

  • Sender : T90CLNT090 (SAP system)
  • Receiver: WORKATOTST (Workato system/OPA Agent)
  • Message Type: DEBMAS

The below configuration in the distribution model will enable SAP to send DEBMAS IDOCs to Workato. A Workato recipe will receive them using the New IDoc trigger.

Distribution model

Configure Workato On-prem Agent (OPA) on SAP server

Step 6: Download Workato On-prem Agent (OPA)

For Workato to talk to SAP, you need to install a Workato On-prem Agent (OPA) on your SAP server, or on a separate Virtual Machine that can reach your SAP server.

The Virtual Machine server and your SAP server need to be in the same domain, not outside of the firewall, and able to access each other (From each server, try to ping the other server to make sure they can reach each other).

Follow these instructions to download and setup Workato OPA.

Step 7: Download the SAP JCO libraries

If you do not already have a license to use SAP JCo libraries, please contact your SAP provider for license.

From the link below, download 2 items: SAP JCO connector libraries (version 3.x or later) and SAP Java IDoc class library. Please ensure that the correct Operating system is selected.

https://support.sap.com/en/product/connectors/jco.html

Once the libraries are downloaded, place them in the lib_ext/ directory of the OPA. If the lib_ext directory is not already created, please create it under the root directory of the OPA.

Step 8: Create SAP profile in OPA

Follow these instructions to create a SAP profile in OPA.

Step 9: Run OPA

Follow these instructions to run the OPA. After it successfully runs, you can move on to set up the SAP connector in Workato.

Configure SAP connector in Workato UI

Step 10: Connect to SAP from Workato

SAP connection

There are 2 ways to create a connection in Workato. Click on App Connections on the navigation bar and then on Create a new connection; or click on the Connections tab in a recipe with SAP triggers/actions. Then, follow the steps below:

  • Select the connector SAP On-premise
  • Input the OPA profile name for SAP you have created in previous step, in this case Direct1
  • Select the OPA name, in this case OPA @ BCone SAP
  • Click Link your account. If the connection is successful, you can start building recipes in Workato to talk to SAP.

Troubleshooting

The followings are issues you may encounter during your setup. This list is constantly being updated. If you don't find your issue listed here, please contact Workato Support.

After clicking Link your account in Workato, it fails to connect This is often due to incorrect OPA configuration. Please check the SAP profile in the OPA's config.yml file for these errors:

  • gwhost is not accessible: In the machine that OPA is installed, use Terminal / Command Prompt to ping that gwhost and verify that it's accessible.

  • gwserv is wrong: Please make sure you input the correct gateway server port number.

I don't see the needed IDocs in the dropdown list in Workato

You need to configure the needed IDoc in your SAP first, before it can be displayed in the dropdown list in Workato.

results matching ""

    No results matching ""