Introduction to Integration in Oracle Integration 3 (Gen 3)

Learn how to create a personal Oracle Cloud free account for learning, including starting a free trial, payment verification with a credit card, region selection, and enabling two-factor authentication.

Sign in to your Oracle Cloud account by entering the tenancy name, username, and password at cloud.oracle.com, then access the Oracle Cloud Console and explore the dashboard and services.

Provision an Oracle Integration 3 instance in your Oracle Cloud tenancy by selecting compartment, edition, domain, and settings; then access design time and runtime URLs and monitor metrics.

Explore the Oracle Integration 3 user interface, from the card dashboard to design and observability, learn to install recipes and accelerators and create integrations for SAP and Salesforce.

Explore the designer canvas in Oracle Integration, mastering icons, selection and cut and paste, layout views, export and print options, and managing triggers, actions, business identifiers, observability, and fault handling.

Learn how to view and copy the outbound IP address for Oracle Integration 3 (Gen 3) from the about section, enabling third party app whitelisting.

Activate an integration in Oracle Integration 3 by selecting an integration in configure state, choose tracing (production, audit, or debug) with payload logging and retention, and run or schedule integration.

Deactivate an active integration in Oracle Integration 3 gen 3 from the design view by hovering the status, clicking the deactivate symbol, and confirming to switch to configure for editing.

Learn how to clone an integration to quickly create a copy without rewriting it, modify actions for new use cases, and keep the original untouched.

Create and version integrations with major, minor, and patch updates for production rollback. Update documentation, package, description, and keywords for new versions, then activate them to deactivate older ones.

Learn how to delete an integration from the Oracle Integration instance by selecting delete from the status menu for drafts or configured integrations, with a confirmation prompt and final deletion.

Export an integration from Oracle Integration 3 Gen 3 by selecting the integration, using the configure status or share options, then download the .iar file for import into other instances.

Import an integration from a .iar file via the import button or drag-and-drop, after deleting an existing instance for demonstration.

Group several integrations into a package to manage and migrate them across environments. Export, import, and delete a package to move all included integrations between development, test, and production.

Learn how to replace a configured connection in Oracle Integration 3 by using the configure option, selecting a same-type connection, deactivating the old, and saving changes.

Enable the file server (sftp) for the Oracle Integration three instance in the OCI console, and manage user access, folders, and permissions from the file server settings.

Delete an Oracle Integration instance you no longer need from its options, removing design-time and runtime data; the action cannot be undone, and the status changes to deleting in minutes.

Expose your Oracle Integration 3 instance as a SOAP web service using a WSDL, define the SOAP envelope, and test with SoapUI to validate a two-number addition.

Learn to invoke external soap web services within an integration flow using an invoke role, test with SoapUI, clone a similar integration, and observe executions via observability.

Create a soap connection configured for both trigger and invoke roles, then build an integration that uses this dual-role connection as both trigger endpoint and invoke in the flow.

Invoke external REST APIs within an integration flow using an invoke role connection, pass the country name as a path parameter, and map the official country name from the response.

Design a single rest trigger that exposes multiple resources under one integration. Use path and query parameters to produce dynamic json messages.

Create your first scheduled integration in Oracle Integration 3 to run at a periodic frequency, enabling automated jobs like FTP file retrieval and cross-system data updates.

Learn to define scheduling for Oracle Integration 3 with iCal expressions. Validate and build iCal frequencies, set time zones, and schedule runs like every 15 minutes.

Learn to replace hard-coded values with scheduled parameters in Oracle integration, map parameters at runtime, and run ad hoc tests to pass country name and last run time to APIs.

Create a country lookup to translate Oracle to Microsoft values at runtime, using the lookup value function in the mapper and handling no data found when there is no match.

Clone existing lookups across applications to create versioned entries, delete old ones, add new columns, and save updates in Oracle Integration 3. Export to CSV for import and bulk updates.