Deep-dive into Oracle Integration-3
About Instructor
Course Overview
What you'll learn
Who this course is for:
Requirements
Course Details
Course Outline
- Introduction of Oracle Integration 3 Course
- Overview of Oracle Integration 3
- Features of Oracle Integration 3
- Oracle Integration Gen-2 vs Oracle Integration Gen-3
- Oracle Integration Gen-3 New Features
- Oracle Cloud Infrastructure (OCI) Free Tier
- Create Oracle Cloud Infrastructure (OCI) Free Tier Account
- Login into Oracle Cloud Infrastructure (OCI) Free Tier Account
- Understanding of Oracle Integration provisioning terms
- Provisioning, Updating & Accessing Oracle Integration 3 Instance
- Know about Oracle Integration Application Roles and Identity Domain
- Creating Users, Groups and Assigning Oracle Integration App Roles to Users
- Know about Oracle Integration Building Blocks
- Walking you through all the Integration Navigations
- Get to know all the steps to create and deploy integrations
- Exploring the capabilities of REST Adapter
- Creating and deploying your first REST API using Oracle Integration
- Consuming public REST APIs in Oracle Integration
- Protecting REST API using OAuth2.0
- Consume REST API which are protected using API Key
- Expose REST API to send Attachments
- Consume External REST API that accept Attachment in Request
- Creating REST Connection using “OAuth Authorization Code Credentials” Policy
- Consume OCI REST API and Configure OCI Signature Version 1 Policy
- Explore SOAP adapter and it’s Capabilities
- Create your own SOAP API in Oracle Integration using SOAP Adapter
- Consuming External SOAP API
- Download File from Universal Content Management (UCM) using SOAP API
- Understand about File Server and how to enable it
- Configuring File Server Settings
- Learn about FTP Adapter
- How to create FTP Connection
- Performing Create, READ, DELETE Operation using FTP Adapter
- Understand the Stage File Action capabilites
- Understanding of PGP Encryption / Decryption on Files
- Perform PGP Encryption / Decryption on Files using FTP adapter
- How to search data from CSV files
- Read Latest File from FTP location
- Learn about Scheduled Orchestration Pattern
- Creating and Submitting Scheduled Orchestration
- Create, Update and Override Scheduled Parameters
- Define Frequency for Schedule Integrations
- View Past, Present and Future Runs
- Learn about Connectivity Agent
- How to download Connectivity Agent
- Installing Connectivity Agent on Linux Machine
- Installing Connectivity Agent in High Availability
- Lear about File Adapter
- How to create File Connection
- Know about the difference between File and FTP Adapter
- Polling CSV Files From Local Server
- Encryption / Decryption using Stage File Action
- Learn about Oracle DBaaS Adapter
- Provisioning Oracle Database on OCI
- How to create DBaaS Connection
- Performing CRUD Operation using DBaaS adapter
- Poll Data From Oracle Database
- Reading Files and push data into Database table
- Get Data in Chunk (Paginate) from Oracle Database
- Learn about Salesforce Adapter
- Creating Salesforce Developer Instance
- Creating Salesforce Connection
- Capturing Salesforce Platform Events in Oracle Integration
- Capturing Outbound Message and Push data to Downstream App
- About Oracle ERP Cloud Adapter
- Creating Oracle ERP Cloud Connection
- Understand Trigger and Invoke Options of Oracle ERP Cloud Adapter
- Creating and Getting Suppliers from Oracle ERP Cloud
- Enable Oracle Account Payable (AP) Invoices Event
- Subscribing Business Events from Oracle ERP Cloud
- Understanding File Based Data Import (FBDI) Process
- Uploading AR Invoices into Oracle ERP Cloud using FBDI with Callback
- Calling Oracle Fusion ESS Job and Register Callback
- Enable Oracle ERP Cloud Business Events
- Subscribing Oracle Account Receivable (AR) event from Oracle ERP Cloud
- Understanding of Oracle HCM Cloud adapter and its Capabilities
- Creating Oracle HCM Cloud Connection
- Understating HDL (HCM Data Loader) and Files Related to HDL
- Creating HDL Files and Upload to Oracle HCM Cloud using HCM Data Loader
- Get Manager Information from HCM Cloud
- About OData Adapter and it’s capabilities
- How to create OData Connection
- Query the data from OData service
- Get the data from OData service based on parameter
- Filter the entity data using OData adapter
- Understanding of Business Intelligence Publisher (BIP) Reports
- Consuming Short BIP Report (PDF Output) in Oracle Integration
- Consuming Short BIP Report (CSV Output) in Oracle Integration
- Code Promotion of Oracle Integration
- Code Promotion using Export / Import tool
- Oracle Integration Versioning & Cloning
- Create Integration Versions & Clone
- Exception Handling in Oracle Integration
- Using Scope to Handle Exception in Oracle Integration
- Implementing Throw New Fault in Oracle Integration
- Implementing Re-throw Fault in Oracle Integration
- Implementing Global Fault Handler in Oracle Integration
- Observability (Run-Time Monitoring) in Oracle Integration
- Exploring Observability Dashboard
- Monitoring the Messages Process Status
- Tracking each Integration Instance Individually
- Connectivity Agent Monitoring
- Track and view the fault of errored out instances
- Integration Projects in Oracle Integration
- Designing, Managing and Monitoring Projects
- How to create and manage deployment
- How to set Integration visibility to call from other projects
- Resource Based Access Control (RBAC) in Integration Project
- How to Restrict Projects using Resource Based Access Control (RBAC)
- Grouping of data using mapper
- Split comma separated string into an Array
- Convert JSON String into Native JSON payload
- Convert JSON to String
- Parallel Execution of Actions
- Save Payload into DB for Future Purpose
- Download and Upload attachments to database
- How to use Private Endpoint to connect to private resources with agent
- How to read fixed length file and push data to database
- Filter unique records using for-each-group
- Validate Items and Sum (Balancing & Control) from summary of the file data
- How to filter data from CSV file
- How to set your own chunk size in Read file in Segment
- Storing secrets in OCI Vault and leverage in Integration for APIs authentication
- Leverage OCI Vault to sign request payload using own private keys
- Leverage OCI Vault to verify the request using own private key
- Implementing pagination to retrieve data in chunks from a database
- Understanding Events in Integration
- How to Publish and Subscribe events in Integration
- About PostgreSQL Adapter
- How to create PostgreSQL instance on OCI and Connect using CLI
- How to connect to PostgreSQL database using PostgreSQL Adapter
- Upload records into PostgreSQL database from FTP server
- Pull records from PostgreSQL database
- About Salesforce REST Adapter
- Creation of Salesforce REST Connection
- Leveraging Salesforce REST adapter to push accounts to Database
Reviews
There are no reviews yet.