Oracle SOA Suite 12c Complete Guide to Advanced Integration

Name: Oracle SOA Suite 12c Complete Guide to Advanced Integration
Rating: 4.3 (574 reviews)

Advanced Practical Course: Mastering Key Functions in Oracle OSB and Oracle BPEL

Created byCarlos Medger

Last updated 3/2026

English

What you'll learn

How to Read/Write/data from database use DBAdapter
How to use SAPAdapter
How to use XSLT + XQuery in OSB and BPEL
How to use SplitJoin in OSB
How to use FileAdapter and transform a complex file
How to use Queue with JMS to consume and produce messages
Create some SOAP API and REST API
How to use Parallel Flow in BPEL
How to configure DBAdapter, SAPAdapter, FileAdapter, Data Sources and JMS in Weblogic
And others stuff

Course content

4 sections • 16 lectures • 6h 52m total length

Introduction1:48
Master advanced Oracle SOA Suite 12c techniques by solving real business cases, testing solutions, and configuring deployments in WebLogic, while using Postman and SOAP for validation and integration.

Case 1 - How to retrieve and work with databases using DBAdapter - Part 153:59
Case 1 demonstrates building a single API to select, update, delete, and insert information with a DBAdapter to manage user data. It eliminates duplicate APIs.
Case 1 - How to retrieve and work with databases using DBAdapter - Part 28:15
Export and deploy the service resource jar, then use the test console to perform create, update, delete, and select operations against the database via the pipeline, isolating layers for diagnosis.
Case 1 - Select data using a custom SQL + OPatch BugFix At JDeveloper46:42
Learn to select data with a sql via a db adapter and expose results through a rest service in WebLogic OSB, plus patch a JDeveloper json factory bug with opatch.
Case 2 - How to work and create RFC from SAP using SAPAdapter37:57
Show how to use the SAP Adapter to expose an SAP RFC as a REST or SOAP API, linking SAP with Oracle SOA Suite 12c.
Case 3 - Create some APIs REST in OSB and BPEL - Part 118:13
Create REST APIs in OSB and BPEL to compare stateless and stateful flows, and learn why OSB fronts BPO for orchestration. Build JSON payloads and XSD responses, test with Postman.
Case 3 - Create some APIs REST in OSB and BPEL - Part 222:57
Create and deploy REST APIs in OSB and BPEL using a mediator, with post and get operations, JSON transformations, and live testing of composites.
Case 4 - How to use Flow Parallel in BPEL16:28
Case 5 - How to use SplitJoin Parallel in OSB41:01
Explore split-join parallel in OSB using ECB vs BPO. Build three APIs A, B, and C, test with five-second waits, and compare stateless ECB performance to stateful BPO.
Case 6 - How to use XQuery to transformation data in OSB33:09
Leverage XQuery to transform XML data to JSON within Oracle Service Bus, connecting a SOAP API to a REST endpoint and mapping fields for the BPO backend.
Case 7 - How to use XSLT transformation data in BPEL17:51
Learn how to apply XSLT transformation in BPEL to transform rest API data, compare with assign, configure source and target, and test and deploy the integration workflow.
Case 8 - How to read a complex file in BPEL using FileAdapter28:08
Learn to read a complex fixed-length file in BPEL using the FileAdapter, parse header, list, and footer records, and insert products with prices into a MySQL database via for-each.
Case 9 - How to use JMS to consumer and produce Queues32:09
Scale ecommerce transactions with JMS queues in Oracle SOA Suite 12c by converting processing to asynchronous using producers and consumers, persisting messages, and validating end-to-end flow.

Requirements

Should Intermediate knowledge in Oracle SOA Suite
Should participated in course Oracle SOA Suite 12c - APIs REST and SOAP + Orchestration

Description

In this advanced course, you'll explore how to leverage the powerful toolkit provided by Oracle SOA Suite 12c.

We'll cover an in-depth overview of Oracle Service Bus (OSB) and BPEL, highlighting their key features and capabilities. Whether you’re experienced with Oracle SOA Suite or just starting, this course is tailored to help you grasp the latest functionalities and elevate your integration skills.

By the end of the course, you will be able to:

Create REST and SOAP APIs.
Consume external APIs seamlessly.
Connect with databases, SAP systems, and file systems.

Benefits of Using Oracle SOA Suite

Automate and Analyze Integration Flows
Streamline and monitor end-to-end data integrations with advanced automation tools.
Boost Productivity
Eliminate retyping errors and reduce manual work by automating data flow between Oracle, third-party, and custom applications.
Adapt to Changing Business Needs
Enhance business agility and cut support costs by isolating services from clients for application interactions.
Pre-built Application Adapters
Simplify connectivity with on-premises and SaaS applications, as well as B2B partners, to automate ERP, HCM, and CX processes.
Operational Dashboards
Leverage Oracle SOA dashboards to track and trace integration data flows, ensuring rapid response to exceptions and adherence to SLAs.

Real-World Use Cases

Simplified ERP Integration:
Automate requisitioning, purchase order creation, and invoice validation while managing exceptions efficiently.

Additional Resources

Source Code Included: GitLab repositories with source code are provided to help you follow along with the lessons.

Feel free to reach out through the contact section for any questions during the course. I'm here to help you succeed!

Who this course is for:

Developers
IT
Anyone who wants to learn
APIs REST or SOAP
Anyone who wants to learn

Oracle SOA Suite 12c Complete Guide to Advanced Integration

What you'll learn

Explore related topics

Course content

Introduction1 lecture • 2min

Preparing your OS2 lectures • 53min

Cases12 lectures • 5hr 57min

Extra1 lecture • 1min

Requirements

Description

Who this course is for: