Teach on Udemy

Turn what you know into an opportunity and reach millions around the world.

Learn More

Your cart is empty.

Keep shopping

Tips & Tricks for Oracle Integration 3 (OIC 3)

Name: Tips & Tricks for Oracle Integration 3 (OIC 3)
Rating: 4.5 (23 reviews)

With examples and use cases learn Integration in Oracle Integration 3 (OIC 3), explore more and more features available

Created byBEENUM LEARNING

Last updated 6/2026

English

English [Auto],

What you'll learn

Learn to build Integrations in Oracle Integration 3 with use cases
Tips to build Integrations in Oracle Integration 3
Tricks to build Integrations in Oracle Integration 3
Integration samples and real world project use case demons

Course content

42 sections • 129 lectures • 17h 5m total length

Introduction1:06
Explore Oracle integration through practical use cases, sharpening your skills with real enterprise scenarios and concepts designed for professionals with basic integration knowledge.

for-each loop3:48
Explore how the oracle integration mapper uses a for-each loop to transform a json input, an array of student records, into a mapped output with name and final result.
Using for-each loop, Xpath axes predicate, xsl if, xsl when condition6:59
Explore filtering student records with for-each loops, XPath axes predicates, and xsl if or when conditions in a mapper; compare choose when otherwise for conditional mapping.
For-each-group (2024 edition)4:06
Learn how to remove duplicate data in Oracle Integration 3 using the for-each-group XSLT function, grouping by first name and concatenating first and last names to uniquely identify records.
Using for-each-group to group data or remove duplicate records4:47
Explore using for-each-group in the Oracle Integration three mapper to remove duplicate records by grouping on name (and optionally result) with XSLT 2.0.
Convert datetime to different timezone using XSLT functions5:23
Learn to convert a date time between time zones in Oracle Integration 3 using XSLT 2.0, the adjust date time to time zone function, and mapper for DST-aware offsets.
Convert datetime to different timezone (DST) using user defined library function7:04
Convert date time from one time zone to another in Oracle Integration three with a JavaScript library function that handles daylight saving time automatically.
XPath Predicate function using node index number5:13
Learn to use the XPath predicate function in Oracle Integration 3 to fetch array items by index in JSON and XML, retrieving first, third, or fourth records with XSLT 2.0.
XPath Predicate function get last element in an array1:51
Discover how to retrieve the last object in an array using the XPath predicate function last() in Oracle Integration 3 mapper, with examples of name and ID retrieval from arrays.
XPath Predicate function using logical conditions4:03
Learn to use the XPath predicate function with XSLT in Oracle Integration 3 mapper to filter XML or JSON arrays by conditions, such as ID equals three or city Mumbai.
using format-dateTime function to format date and date time7:57
Format string function6:00
Master the format string function in the Oracle integration Gen three mapper to format and concatenate inputs with custom separators, using up to nine arguments for efficient, complex string construction.
Replace string function5:13
Convert array to string (nodeset to string)4:56
Learn to convert an array or nodeset to a delimiter-separated string in Oracle integration by using the xslt function create-delimited-string in the mapper, producing comma-separated outputs from a JSON array.
Convert string to array (string to nodeset)7:01
Demonstrates converting a comma-delimited string to a nodeset or array in Oracle integration (OIC 3) using the XSLT function create node set from delimited string within the mapper.

Parallel action8:20
Learn to run tasks in parallel with Oracle integration's parallel action, splitting flows into branches to boost performance and response time, with up to five branches.
Cut and Paste Elements (actions and invokes)1:56
Learn how to move actions in Oracle Integration 3 using cut and paste, including parallel, switch, and for loop actions, and note that copy-paste is not available.
Data Stitch (Assign, Append, Remove)13:14

Expose integration as a REST API10:30
Expose an Oracle integration as a rest service by creating a trigger connection, designing a rest endpoint, configuring template parameters, mapping input to output, and testing with built-in observability.
Invoke external REST API within Integration10:16
Learn to invoke external rest apis within an integration flow using an invoke rule, mapping the input country name to fetch the official country name from a free rest service.
REST connection with Trigger and Invoke both roles5:33
REST trigger integration with multiple resources (http method, path/query param)8:16
multipart/form-data request content type10:40
Learn to call external REST APIs with Oracle Integration Gen3 using multipart form data, including attachments and text parameters mapped in the mapper.

Expose integration as a SOAP web service11:34
Expose an integration built with Oracle Integration three as a soap web service using a wsdl, configure the soap adapter, and test with soap ui.
Invoke external SOAP web services with Integration10:04
Learn to invoke external soap web services within an integration flow using the invoke rule, test with soap ui, and call a calculator service’s add operation.
SOAP connection with Trigger and Invoke both roles5:11
Learn to create a soap connection with trigger and invoke roles, test it, and use it to expose and invoke a soap web service within an integration.

Create a library with JavaScript function9:20
Build a jar with multiple JavaScript js files / libraries3:18
Bundle multiple JavaScript libraries into a jar to build a complex function for Oracle integration, then import and configure encrypt and decrypt functions using crypto-js for aes.
Convert month name to number4:34
Learn how to convert month names to numbers using a JavaScript function in Oracle integration and explore XSLT alternatives, with practical demos from January to December.
Convert month number to name3:40
Learn to convert month numbers to names in Oracle integration using JavaScript functions, XSLT, or libraries, mapping requests to month names and exposing via rest API.
HMAC-SHA256 with base64 code return7:13
Convert Date Time from time zone to another with DST12:03

OCI Signature Version 1 and GET Object16:40
Configure OCI signature version one in Oracle Integration three with tenancy ocid, user ocid, fingerprint, and private key. Convert to pkcs1 and use rest connection to get object from storage.
OCI Service Invocation and GET Object7:00
Learn how OCI service invocation simplifies connecting Oracle Integration to OCI rest APIs using a security policy, without api keys, by configuring dynamic groups, client IDs, and policies.
PUT Object to Object Storage6:41
OAuth with JWT User Assertion18:36
Learn to authenticate Oracle Integration REST calls on behalf of a user using JWT user assertion, including key generation, certificate handling, and token creation.

Requirements

Prior knowledge to build Integrations in Oracle Integration 3 is needed
Prior knowledge to use POSTMAN / SOAPUI tools is needed
Basic knowledge on RESTful services, SOAP web services, WSDL, FTP protocol and Databases is needed
NOTE: The course is delivered in an Indian English accent, ensuring clarity and relatability throughout. If you find Indian English difficult to understand, it may be best to consider other courses, as this course focuses on an Indian English pronunciation and style.

Description

NOTE: The course is delivered in an Indian English accent, ensuring clarity and relatability throughout. If you find Indian English difficult to understand, it may be best to consider other courses, as this course focuses on an Indian English pronunciation and style.

Oracle Integration 3

Oracle Integration 3 is a fully managed, preconfigured environment that gives you the power to integrate your cloud and on-premises applications, automate business processes, develop visual applications, use an SFTP-compliant file server to store and retrieve files, and exchange business documents with a B2B trading partner. Select from our portfolio of hundreds of adapters and recipes to connect with Oracle and third-party applications.

Overview of Oracle Integration 3

Capabilities

With Oracle Integration 3, you can:

Design integrations to monitor and manage connections between your applications, selecting from our portfolio of hundreds of prebuilt adapters and recipes to connect with Oracle and third-party applications.
Create process applications to automate and manage your business work flows, whether structured or dynamic.
Develop visual applications using the embedded Visual Builder feature.
Store and retrieve files in Oracle Integration using the embedded SFTP-compliant file server.
Create integrations that use B2B e-commerce to extend business processes to reach trading partners.

Editions

Oracle Integration is available in two editions: Standard or Enterprise.

Oracle SaaS customers can use Oracle Integration for SaaS, which gives you the features and benefits of Oracle Integration with a focus on SaaS.

Instances and Updates

Every instance has either a Development or Production shape, which you choose when you create the instance. Both instances have the same service level agreements (SLAs); the only difference is the timing of functional updates. Production instances are updated two weeks after Development instances.

Functional updates to Oracle Integration 3 occur every two months and involve zero downtime. Oracle completes all update work on your behalf, with no work required by you.

Who this course is for:

Beginners in Integration in Oracle Integration 3 for developers
Beginners in Oracle Integration 3 for technical professionals
Beginners who aspire to learn Oracle Integration 3 from scratch and basics
This course is not for functional consultants / functional professionals. This course is created for Technical professionals only.
NOTE: The course is delivered in an Indian English accent, ensuring clarity and relatability throughout. If you find Indian English difficult to understand, it may be best to consider other courses, as this course focuses on an Indian English pronunciation and style.

Tips & Tricks for Oracle Integration 3 (OIC 3)

What you'll learn

Explore related topics

Course content

Introduction1 lecture • 1min

Create Free Tier Oracle Cloud Account1 lecture • 7min

Connectivity Agent2 lectures • 10min

Mapper14 lectures • 1hr 14min

Actions3 lectures • 24min

REST Connection5 lectures • 45min

SOAP Connection3 lectures • 27min

Library (JavaScript function)6 lectures • 40min

REST Connection Security Policies4 lectures • 49min

OCI Functions2 lectures • 20min

Requirements

Description

Who this course is for: