This Document explains you on how to create an inbound interface to post a Hierarchical sObject using the Skyvva connector module.
- Overview:
This is an inbound asynchronous interface to Import SAP Debitors with its Sales Area Data and Partner Roles to Salesforce from SAP ERP system using SAP PO as middleware.
Initially, We have to create four inbound interfaces. One is the parent and the rest of the three are child interfaces.
- Account_IN
- Contact_IN
- SAPPartnerRole
- SAPAccountSalesArea_IN
Login to the Salesforce org and then select Skyvva Integration Cloud.
Go to Integration Tab and create New Integration under that go to the interfaces tab and then create all the four interfaces as shown below.
- Account_IN
- Contact_IN
Now create contact inbound interface
Add Parent Interface as Account interface as shown above.
Create Foreign key lookup to link the contact to an Account as shown below.
- SAPPartnerRole_IN
Create SAPPartnerRole_IN inbound interface as shown below.
Add Parent Interface as Account interface as shown above.
Create Foreign key lookup to link SAPPartnerRole to an Account Interface as shown below.
SAPAccountSalesArea_IN
Create SAPAccountSalesArea_IN inbound interface as shown below.
Add Parent Interface as Account interface as shown above.
Create Foreign key lookup to link SAPAccountSalesarea to an Account Interface as shown below.
Now add Contact_IN, SAPPartnerRole_IN, and SAPAccountSalesArea_IN interfaces as child interfaces to parent Account interface.
Now generate the WSDL for Account_IN and upload it into SAP PO for Mapping.
Click on View to download the WSDL.
WSDL looks like below
Under the parent Account we can see three child objects as shown below.
Import WSDL into ESR
First, we have to create a namespace in ESR like “http://XXXXX/Account
Now create an external definition under the namespace like below. Here the WSDL is for Account. So, we can give the name as Account_IN
Now import the WSDL and Save and activate it.
Similarly, import the IDOC “DEBMAS07” from SAP. This IDOC itself used as a data type, Message type, and service interface.
Create a service interface under the namespace.
Choose the category Inbound or Outbound. In our scenario we are creating an inbound interface, therefore we choose Inbound and also its an asynchronous inbound interface So we choose the mode as Asynchronous.
Now import the external definition and then click on save and activate the inbound service interface.
Message mapping
Create message mapping under the same namespace.
Select the Source structure as DEBMAS07 and the target structure will be the external definition which we downloaded from Salesforce.
Do the respective mapping and save and activate.
Here we have to define the parameters for Account, Contact, PartnerRole, and for AccountSalesArea to pass the values in runtime.
Now we have to bind these parameters in the operation mapping.
- Operation Mapping for asynchronous inbound interface
Create Operation mapping.
Choose the inbound and outbound service interface and the respective message mapping.
Now we have to define the parameters here.
We have to bind the message mapping parameters with operation mapping parameters as shown below.
Then save and activate the operation mapping.
- Creation of Integration Flow
After creating the objects in ESR. We have to configure these objects in the integration directory.
First, we have to create Integration flow in NWDS. Give the relevant name as for example “IF_SAP_to_Salesforce_Account”
Integration flow has the following objects.
- Business System for Sender and Receiver
- Sender and Receiver Communication channel
- Integrated Configuration
These are the objects we should create.
We have to define our business system e.g. for the SAP-Backend. For Salesforce you can use our proposal “Salesforce” as the business system. We have to import these business systems from SLD.
- Configuring the Sender Idoc communication channel
Create sender communication channel as shown below.
Since we are using an IDOC as a source. So, here we are using IDoc adapter in the sender channel.
Provide the necessary details. After that save and activate the channel.
- Configuring the SOAP receiver channel
Configuration for Tab “General”
Specify the parameters as shown in the above screenshot.
Below is the configuration for the “Advanced” Tab.
The value “TserverLocation” has to be entered for the parameter Variable Header (XHeaderName1).
Below are the settings for Tab “Module”. Here, the SKYVVA module containing the logic for session handling.
Configuration of module parameters are described in detail below
- Skyvva Module Parameters
Starting from version 2.27 Skyvva provides a single module, “Salesforce/GetSessionID_V4”, to be used with SOAP receiver channels. Module parameters are outlined below
Parameter | Description | Value |
IntegrationID | This parameter contains the skyvva engine integration id on Salesforce. Here we recommend to use only Integration name instead of id because if we transport the objects from one environment to other environment IntegrationId will be changed but Integration Name will not be changed. | Lalitha_Test_Integration |
SessionGlobalFilePath | This parameter holds the path in which the session id is being stored | /usr/sap/O5B/SYS/global |
SforceAccessPoint | This parameter represents the URL(endpoint) for getting the session id. The URL is that of the Enterprise WSDL for Salesforce used for logging in and getting the session id | https://login.salesforce.com/services/Soap/c/43.0 |
SessionPooling.Active | A flag that actives or deactivates the session pooling. Set for better performance | X |
SforceRequestPayload | It will show the request payload of skyvva | X |
SforceSecurityToken | This parameters holds the security token from salesforce. Necessary only of configured in the salesforce instance | By54dfe0000DerYvvv |
SforceShowSAPChannelParameters | It displays the SAP PI parameters in the output log | X |
SforceUsername | This parameter is the salesforce username | xxx@bbbb.com |
SforceWebServiceOperation | Defines the webservice operation in skyvva | integrate |
pwdSforceLoginPassword | It holds the password of the salesforce user used to log in to the salesforce | xxxxxxx |
- Creating I-flow in NWDS
Create an I-Flow as “IF_SAP_2_SF_Account as shown below
Select the point to point channel because here we are sending data to one receiver only then click on next.
Provide the sender system and the receiver system details as shown below and then click on finish.
Assign the sender and the receiver channel and the operation mapping.
After adding all the details the flow will look like below.
Specify the parameter values to which we defined in ESR.
Test the Inbound Interface.
IDOC DEBMAS07 has been triggered by ECC. Now we have to check the result in Salesforce Skyvva message board.
The message got successfully posted to Salesforce. Below is the screenshot to show the parent Account with the child Contacts, partner roles, and AccountSalesArea.