PI.DOC – Successfactors BizX Integration using PI Java Mapping – Query Operation on CompoundEmployee Entity – Part I
Landscape / System Details:
SAP PI Version: SAP Netweaver 7.30 &Single Stack
SFSF BizX Entity : CompoundEmployee
Source System: Non SAP – SOAP System
Target System: File System
Target Audiance :
1. Consultant want to integrate Third-parties with SFSF BizX.
2. Consultant want to know How to call Client WSDL in Java Mapping.
Sample Scenario : Query Employee Data from SFSF – CompoundEmployee Entity.
The document provides a step by step execution of test scenario “querying employee information from SFSF Biz X – CompoundEmployee Entity”.
This process can be resused for other entities too.
Requirements as per FD :-
Implemented Solution :
All above said requirement can be full filed by using Employee compound application programming interface (API) for SuccessFactors’ Employee Central.
The service is used to extract employee data out of Employee Central. This API allows you to easily integrate data with external systems and applications.
The API compound Employee selects multiple entities related to an employee and returns all data in hierarchically-structured response XML with the employee person data as the root node.
The select items are a list of all entities to be returned as part of the hierarchical query result xml. The restriction of fields is not supported.
The following sub-structures are supported:
The where expression can be used to filter the query result. The compound API does not support expressions with complex conditions on several fields and different logical operators.
The API supports the following fields and operators:
Field Remark Valid Operators
Note : There is no SAP ECC System involved in this Scenario.
This document explains the configuration of SAP PI scenario which can be used for query employee data. Entire process consisting of the login, logout, query and QueryMore operation on SF Side.
Above Screenshot: Integration solution to integrate Non SAP System with SFSF to File System using SAP PI Middleware.
Third Parties and SAP PI integrated through SOAP (HTTP) and FTP connector.
SAP PI to SFSF connection has been maintained in Java Mapping using Java Class “SOAPConnectionFactory” class and its family.
All calls are Asynchronous in nature between SAP PI and Third-Party.
All calls are Synchronous in nature between SAP PI and Successfactors.
Above Screenshot: Operation Mapping has two mappings added in it
1. Java Mapping : Establish connection from Successfactor and based on Select request Query it will return the Intermediate Response XML Data.
2.Graphical Mapping : Perform transformation function returned response XML Data and finally pass it to Target File Communication channel.
Step 1. Source System triggers the process with Select Query XML Data.i.e. here Source System is Webservice Navigator or SOAP UI.
Step 2. Data will be received to SAP PI using SOAP [HTTP] Sender adapter.
Step 3. Then this Select Query and SF Credentials XML Source Data will be passed to Java Message Mapping.
Step 4. Java Message mapping is written to perform Login , Query , Query more , Logout opreations and pass the Intermediate XML response / result to Next Mapping of Opeartion Mapping.
Target Adapter or Communication Channel
Important points to consider before setting up Integration scenario between SAP PI and SFSF interface are following :-
1. Opening firewall unidirectional port 443 from SAP PI to SFSF
2. Being B2B – Secure call this would need security Certificates in Trusted CA and WebStore.
3. You may not have Axis protocol in your SAP PI Box. Get it deployed explicitly.
Note : Please follow <Click Here> to get more information on above points.
PI ESR Object Development Overview
Source Message Type : Request
Message Type is created to carry select query and username/password/company id from source side.
Select query can be dynamic all the time but should be in proper syntax.
Username-Password -Company will be used to get the sessionID from SFSF.
Intermediate Message Type : CompoundAPI_XSD
XSD is created based on structure similar to CompoundEmployee Entity and uploaded in External Defination.
You can use tool like Altova XMLSpy to handle such cases.
Target Message Type : Employee_Response_MT
Message Type is created on the basis of Target file Struture given in FD.
Create Outbound and Inbound Asynchronous service interface.
Name : WSDLCalling_Async_Out
Name: WSDLCalling _Async_In
Java Mapping : Source XML to Intermediate XML.
Establish connection from Successfactor and based on Select request Query it will return the Response XML Data.
Graphical Mapping: Intermediate XML to Target Message Type.
Perform transformation function returned response XML Data and finally pass it to Target File Communication channel.
ROperation mapping – There are two message mappings in one operation Mapping.
Name : OperationMapping_WSDLCalling_JavaMapping
Due to Size limitation rest will be continued to PI.DOC – Successfactors BizX Integration using PI Java Mapping – Query Operation on CompoundEmployee Entity – Part II