Skip to main content

Oracle SOA with SAP Adapter Configuration in 12C/11G

Hello All,

Hope you are doing well!!!

Today i am going to write over how we can configure SAP adapter for 11G/12C. As Oracle SOA 12C already have built in SAP adapter which minimise number of task that need to be done in 11G. In this blog we will see what all configuration we need to configure SAP R/3 system in oracle SOA using "THIRD PARTY ADAPTER" Configuration.

@Note: I don't have working SAP account access, This blog contain information from oracle documentations only.

What is SOA SAP R/3 System: Oracle WebLogic Server connects to a SAP R/3 system through Oracle Application Adapter for SAP R/3. Oracle Application Adapter for SAP R/3 provides connectivity and carries out interactions on a SAP R/3 system.

Reference pointers:

 ■ For SOA: \soa\soa\thirdparty\ApplicationAdapters 
■ For OSB: \osb\3rdparty\ApplicationAdapters

 How Oracle SOA Works with SAP:

 Oracle Application Adapter for SAP R/3 using SAP Java Connector (SAP JCo) 3.0xx is a remote function call adapter that provides a means to exchange real-time business data between SAP Enterprise Central Component (ECC) 5.0/6.0 systems and other application, database, or external business partner systems.

 The adapter enables external applications for inbound and outbound processing with SAP R/3. Oracle Application Adapter for SAP R/3 can be deployed as a J2EE Connector Architecture (J2CA) version 1.0 resource adapter. This deployment is referred to as Oracle Adapter J2CA. It can also be deployed as a Web services servlet and is referred to as Oracle Adapter Business Services Engine (BSE).
Messaging type used by SAP adapter in SOA:

 Oracle Application Adapter for SAP R/3 uses XML messages to enable non-SAP R/3 applications to communicate and exchange transactions with SAP R/3 using services and events.The role of services and events is outlined. Services and events are described as follows: 
■ Services (also known as outbound processing): Enable applications to call an SAP R/3 business object or business operation. 
■ Events (also known as inbound processing): Enable applications to access SAP R/3 data only when an event occurs. 

 Implementation supports by SAP Adapter:
■ Support for bidirectional message interactions. 
■ Oracle Adapter Application Explorer (Application Explorer), a GUI tool which uses SAP R/3 object repository metadata to build XML schemas and Web services to handle adapter requests or event data. 
■ Support for Remote Function Calls (RFC), Business Application Programming Interfaces (BAPI), and Intermediate Documents (IDoc) interfaces to SAP R/3. 
■ XML schemas and WSDL files for the J2CA 1.0 and J2CA 1.5 resource adapter. 
■ Web services for BSE

 Sample projects available at "\etc\sample\SAP_Samples.zip\SAP_ Samples".

Configurations in oracle SOA for SAP Adapter:
Once the SOA installation is completed, copy the required third-party library files (sapjco3.jar and sapjco3.dll).
For SAP Java Connector (SAP JCo) to the following directories: \lib\user_projects\domains\base_domain\lib.
The sapjco3.dll file must be copied to the following directory: C:\Windows\system32 For more information on installing SAP JCo on other operating systems, see the Oracle Fusion Middleware Application Adapters Installation Guide for Oracle WebLogic Server.

 FOR DOWNLOADING THESE TWO FILES YOU NEED A REGISTERED SAP ACCOUNT.

 Verify SAPJCO configuration:

 On windows:

  1. Navigate to the directory where the sapjco3.jar file is located. 
  2. Right-click the sapjco3.jar file, select Open With from the context menu, and click Java 2 Platform Standard Edition binary. 
  3. The SAP Java Connector (JCo) dialog is displayed.
  4. All the required information that pertains to the SAP Java Connector on your Windows platform is provided. 
  5. Once you have reviewed the SAP Java Connector files, click Close
On linux/unix:
  1. Navigate to a UNIX command prompt. 
  2. Execute the following command: 
  3. $ java -jar sapjco3.jar -stdout
  4. Review the information for the SAP Java Connector on your UNIX platform.
Parameter's Configuration:
Integration with BPEL in oracle SOA Composite:

To integrate with Oracle BPEL Process Manager, Oracle Application Adapter for SAP R/3 must be deployed in the same WLS container as Oracle BPEL Process Manager. The underlying adapter services must be exposed as WSDL files, which are generated during design time in Oracle Adapter Application Explorer (Application Explorer) for both request-response (outbound) and event notification (inbound) services of the adapter. 

The generated WSDL files are used to design the appropriate BPEL processes for inbound or outbound adapter services. A completed BPEL process must be successfully compiled in JDeveloper and deployed to a BPEL server. Upon deployment to the BPEL server, every newly built process is automatically deployed to the Oracle Enterprise Manager console, where you run, monitor, and administer BPEL processes, and listen to adapter events.

Designing an Outbound BPEL Process for Service Integration (J2CA Configuration): A sample project has been provided for this outbound use case scenario in the following folder of the Application Adapters installation: \etc\sample\SAP_Samples.zip\SAP_Samples\BPEL\J2CA\Outbound_Project.

Generating WSDL for Request/Response Service (This complete process will be done with downloaded JAR file of SAPJCO):

  • Before you design a BPEL process, you must generate the respective WSDL file using Application Explorer. 
  • Perform the following steps to generate a WSDL for request/response service: 
  • Start Application Explorer and connect to a defined MySAP target (a J2CA configuration). For more info
  • rmation on starting the Application Explorer and defining a target, and connecting to SAP R/3.Expand the MySAP target to which you are connected. 
  • Expand Remote Function Modules, Financial Accounting, 0002 Company Code Business Object, and then select BAPI_COMPANYCODE_GETDETAIL.Right-click the BAPI_COMPANYCODE_GETDETAIL node.
  • Click Create Outbound JCA Service (Request/Response).
  • Click OK. 
  • You can now create an empty composite for SOA, which is the first step that is required to define a BPEL outbound process in JDeveloper.
Configuring a Third Party Adapter Service Component:
  • Drag and drop the Third Party Adapter component from the Service Adapters pane to the External References pane.
  • Enter a name for the third party adapter service. 
  • Ensure that Reference is selected from the Type list (default). 
  • Click the Find existing WSDLs icon, which is located to the right of the WSDL URL field.
  • Browse and select an outbound WSDL file from the following directory: \wsdls.
  • Click OK.
  • Click the Find JCA file icon, which is located to the right of the JCA File field.
  • Browse and select the JCA properties file from the following directory: \wsdls.
  • Click OK

Complete BPEL process and invoke this adapter with invoke activity inside BPEL. Deploy and test it.


Detailed information is available in below oracle documentation:
http://www.oracle.com/technetwork/middleware/adapters/documentation/e17656-12c-sap-2344549.pdf



Labels:

Comments

  1. rmouniakApril 16, 2018 at 3:24 AM

    It is very good blog and useful for students and developer , Thanks for sharing
    Thanks for sharing this amazing blog

    Oracle SOA Online Training

    ReplyDelete
  2. raveenaMarch 6, 2020 at 10:45 PM

    Best blog ever.
    Oracle Integration Cloud Service Online Training

    ReplyDelete
  3. Ashley BillyNovember 5, 2020 at 10:44 PM

    Thanks for sharing this great information I am impressed by the information that you have on this blog. Same as your blog i found another one Oracle SOA Training
    . Actually, I was looking for the same information on internet for Oracle SOA Interview Questions and Answers

    and came across your blog. I am impressed by the information that you have on this blog. It shows how well you understand this subject, you can learn more about Oracle SOA Tutorial also.

    ReplyDelete
  4. Bronco AustinFebruary 5, 2021 at 2:39 AM


    Iam so thrilled because of finding your alluring website here.Actually i was searching for Oracle BPM.Your blog is so astounding and informative too..Iam very happy to find such a creative blog. Iam also find another one by mistake while am searching the same topicOracle SQL.Thank you soo much..

    ReplyDelete
  5. arnav digitalMay 17, 2023 at 12:34 AM

    At ERP Training Noida, we understand the significance of SAP HR Training in Noida in today's competitive job market. SAP HR, also known as SAP Human Capital Management (HCM), is a crucial module within the SAP ecosystem that focuses on managing human resources efficiently. It covers a broad range of HR functions, including personnel administration, organizational management, time management, payroll, and more.

    ReplyDelete

Post a Comment

Popular posts from this blog

Solution for BPM standard dashboard & activity guide not working in Oracle SOA 12.2.1.0 C

As earlier i publish a post about different issue of Oracle BPM, After some oracle support i got to fixed them. Issue Blog Here... Issue 3:BPM 12.2.1 process workspace activity guide not working. if you have a normal BPM Process, then this is the issue. In order to have data populated in "Activity Guide" firstly you should create a BPMN Guided Business Process. Below you can find the documentation about activity guide and how to create a Guided Business Process: https://docs.oracle.com/middleware/1221/bpm/bpm-develop/GUID-F765955D-90A5-48D4-8D2A-2F01FBB539E3.htm#BPMPD901 And here is specified: " A Guided Business Process is modeled as an activity guide that is based on a business process. The Activity Guide includes a set of Milestones. A milestone is a contained set of tasks that the end user has to complete. A milestone is complete when the user successfully runs a specific set of tasks in the milestone. " And in the below chapters you will find the
Post a Comment
Read more

Oracle SOA 12C rest adapter with Custom HTTP headers

Most existing web applications are connected through web services, which are commonly known as SOAP services. More and more users are relying on mobile devices for communication, and they’re looking for lighter ways to access enterprise information on the go. REST services are the answer for the mobile device platform, because they get rapid responses and fast access to data. Oracle SOA Suite 12 c  provides a complete set of service infrastructure components for designing, deploying, and managing composite applications. Oracle SOA Suite 12 c  enables services to be created, managed, and orchestrated into composite applications and business processes. Some time we have need to send HTTP headers in REST service, In OSB we use header component and add what ever is needed but in oracle SOA 12C it's little bit different. Let see how we can do it. Create one SOA Application. Create one SOA Sample project inside SOA Application. Go to composite and drag drop REST adapt
22 comments
Read more

Dynamic Routing in OSB 12C

Dynamic Routing in OSB cab be used when the BusinessService endpoint required to be determine at runtime in message flow. Consider a scenario where OSB has to route the incoming requests to 2 different services based on the CustomerType element value sent in the payload. So create a XQuery resource with the following contents. Observe that we are using the absolute path of business service in configuration as required by dynamic routing. Following is the XML schema that we use:>>  Customer.xsd <?xml version="1.0" encoding="windows-1252" ?> <xsd:schema targetNamespace="http://xmlns.oracle.com/schema/Customer" xmlns:xsd="http://www.w3.org/2001/XMLSchema"             xmlns:ns1="http://xmlns.oracle.com/schema/Customer">   <xsd:complexType name="Customer">     <xsd:sequence>       <xsd:element name="CustomerId" type="xsd:string"/>       <xsd:elemen
14 comments
Read more