Oracle Sales and Partner Academy

PaaS
Working with ERP Cloud Business Events in Oracle Integration 3 (OIC Gen 3)

The purpose of this lab is to familiarize yourself with the SaaS connectivity features of Oracle Integration 3 (OIC 3) so you can represent the product in customer sessions, deliver demonstrations and develop skills to build proof-of-concept (POC) projects for customers. This lab will cover the recommended steps to complete an end-to-end use case based on ERP Cloud Business Events in Oracle Integration 3. It will leverage the pre-built Oracle ERP Cloud Adapter, which enables you to create an integration with Oracle Enterprise Resource Planning (ERP) applications. One of the key differentiators of this adapter is support for subscribing to business events raised by various modules in Oracle ERP Cloud and Oracle Supply Chain Cloud. This lab will showcase the event subscription capabilities to create an app-driven orchestration i.e., real-time integration, with updates in ERP Cloud sent immediately to Oracle Autonomous Database (ADW) using orchestration with OIC 3. The steps outlined in this workshop and the walk-through demo videos can be used to showcase the event-driven capabilities of the ERP Cloud adapter in OIC 3. Estimated workshop time: 1 hour. Upon completion of this Lab you will be able to: Create and activate an integration that subscribes to an ERP Cloud Purchase Order (PO) event. Create a PO in ERP Cloud and a PO event is triggered. Retrieve the PO information through Oracle Autonomous Database table. This lab is intended for: Anyone interested in connecting SaaS applications and database. None. Authored by Ravi Chablani, March 2022. Last updated by - Wallence Wong, February 2023.

Time Limit
5 hours
Oracle Sales and Partner Academy
PaaS
Oracle Integration 3 (Application Integration)

The purpose of this lab is to familiarize yourself with the application integration capability of Oracle Integration (OIC) so you can represent the product in customer sessions, deliver demonstrations and develop skills to build proof-of-concept (POC) projects for customers. You will use the Integration component of the latest Oracle Integration Cloud version -. to build an integration for a RESTful process application to connect to Autonomous Transaction Processing (ATP) database to create a new order based upon an approved order request. Estimated duration is around 1 hour. Upon completion of this Lab you will be able to: Explain the business and technical architectures of the proposed solution for Mama Maggy. Build connections using OIC's prebuilt adaptors (REST and ATP adaptors). Use connections to build a new integration that accepts order data via a REST POST and creates a new order row in the ORDERS table in the ATP database. Activate the integration. This lab is intended for: Anyone interested in application integration. Nil. Dec 2, 2022.

Time Limit
2 hours
Oracle Sales and Partner Academy
PaaS
Building an App from a Spreadsheet using Oracle APEX

Oracle APEX is a low-code application platform for Oracle Database. APEX Application Development, Autonomous Data Warehouse (ADW), Autonomous Transaction Processing (ATP), and Autonomous JSON Database are fully managed services, pre-integrated and pre-configured with APEX, for rapidly building and deploying modern data-driven applications in Oracle Cloud. Business users, citizen, and application developers can create enterprise apps 20X faster with 100X less code — without having to learn complex web technologies with just a browser. There are many ways in the Oracle Cloud to create APEX workspaces. Through ATP, ADW, directly on apex.oracle.com, or from the OCI Console in the Developer section. We will use the Developer section in OCI. This lab will show you how to create a robust APEX application with data imported from a common business spreadsheet. Many customers are wasting enormous amounts of time and energy keeping their business workflows and critical data in unmanageable spreadsheets. It's a common fact, spreadsheets don't scale. What if your customer could create a secure, scalable, multi-user application out of that spreadsheet that could save time and money? That's what you'll be learning in this lab! Build a secure, scalable application using uploaded spreadsheet data. Improve application by managing and changing the filters through APEX’s powerful faceted search. Improve the Interactive Report and form pages to add better usability features. Add maps region and install PWA. Link pages. Build confidence in demonstrating the APEX application to customers! Cloud sales and engineering. Database cloud sales and engineering. Database developers. Basic cloud familiarity. Having an issue with the lab? Have an idea on how it could be made better? Want to tell us how awesome the lab is? Click the icon below to contact the team and let us know your feedback. February 2023.

Time Limit
2 hours
Oracle Sales and Partner Academy
Sec
OCI IAM Authentication using OpenID Connect

Oracle Cloud Infrastructure Identity and Access Management (IAM) provides identity and access management features such as authentication, single sign-on (SSO), and identity lifecycle management for Oracle Cloud as well as Oracle and non-Oracle applications, whether SaaS, cloud-hosted, or on-premises. Employees, business partners, and customers can access applications at any time, from anywhere, and on any device in a secure manner. Upon completion of this Lab you will be able to: Learn OCI IAM Single Sign-On (SSO) features and capabilities by integrating custom apps with OCI IAM. Create and manage domains, users, groups, and resources. This lab is intended for: Anyone interested in Oracle Identity and Access Management. Oracle Cloud Infrastructure supports the latest versions of Google Chrome, Firefox and Internet Explorer 11. - Alejandro Casas, Sr. Principal Enablement Specialist, OSPA. - Alejandro Casas, Sr. Principal Enablement Specialist, OSPA, Jan 2022. Having an issue with the lab? Have an idea on how it could be made better? Want to tell us how awesome the lab is? Click the icon below to contact the team and let us know your feedback. Jan 25th, 2022 - Initial version.

Time Limit
1 day
Oracle Sales and Partner Academy
PaaS
Oracle Integration Gen 2 (Insight)

The purpose of this lab is to familiarize yourself with the. of Oracle Integration (OIC) Gen 2 which provides users with real time visibility and analytics into their process applications and integrations. We adopt the same use case – Mama Maggy, a large pizza chain ordering pizza ingredients that we use in other two labs (Application Integration and Process Automation) of the same series to demonstrate the steps to build an Insight model in OIC environment. Estimated duration is around 1.5 hour. After this lab, you are also highly recommended to attempt two other labs of the same series (Application Integration and Process Automation) which demonstrate the way to build an integration flow and process automation application respectively to give you a complete picture of the end-to-end solution for this use case. Upon completion of this Lab you will be able to: Articulate key benefits of Oracle Integration - Insight capabilities to address customer's needs for business analytics; Demonstrate to your customers how to build an Insight Model for a business process and integration flow that ultimately generates valuable business insights through pre-configured dashboards. This lab is intended for: Anyone interested in application integration, business process creation and analytics. Nil. Sep 15th, 2021.

Time Limit
3 hours
Oracle Sales and Partner Academy
IaaS
OCI Class of Learning Path

This learning path contains the two labs that are presented in the OCI Overview section for new SE's in the Class Of training program. The courses included in this learning path are listed below. Here’s some basic guidance about which course you should take first and how long the path might take. Click on the Labs tab next to Overview to get started on this path. OCI Basics. OCI Advanced - VCN Peering. This lab is intended for: Class Of students attending the OCI Overview instructor led training. Basic computer skills, some command-line experience with Linux, and general networking concepts. July 2021 LP creation.

2 labs
PaaS
Oracle Integration Gen 2 (Application Integration)

The purpose of this lab is to familiarize yourself with the Application Integration capability of Oracle Integration (OIC) so you can represent the product in customer sessions, deliver demonstrations and develop skills to build proof-of-concept (POC) projects for customers. You will use the Integration component of Oracle Integration (OIC) Gen 2 version to build an integration for a RESTful process application to connect to Autonomous Transaction Processing (ATP) database to create a new order based upon an approved order request. Estimated duration is around 1 hour. After this lab, you are also highly recommended to attempt another lab (Oracle Integration - Process Automation) which demonstrates the way to build an process automation application to give you a complete picture of the end-to-end solution for this use case. Upon completion of this Lab you will be able to: Explain the business and technical architectures of the proposed solution for Mama Maggy. Build connections using OIC's prebuilt adaptors (REST and ATP adaptors). Use connections to build a new integration that accepts order data via a REST POST and creates a new order row in the ORDERS table in the ATP database. Activate the integration. This lab is intended for: Anyone interested in application integration. Nil. May 13th, 2021.

Time Limit
2 hours
Oracle Sales and Partner Academy
PaaS
Oracle Integration Gen 2 (Integration, Process, and Insight)

The purpose of this lab is to familiarize yourself with the features and functionality of Oracle Integration (OIC) Gen 2 so you can represent the product in customer sessions, deliver demonstrations and develop skills to build proof-of-concept (POC) projects for customers. You will use Oracle Integration Gen 2 (Integration, Process and Insight capabilities) to address the use case challenge by developing an integration and a process automation application. In Lab 1, you will use the Integration component of Oracle Integration (OIC) to build an application integration that will be used in Lab 2 to interact with an Autonomous Transaction Processing (ATP) database to create a new order based upon an approved order request. Finally, in Lab 3, you will use OIC Insight capability to create an Insight model that will enable business users to collect and monitor metrics for the above business process and integration flow. Estimated duration is around 4-5 hours. Lab 1 (OIC Application Integration), Lab 2 (OIC Process Automation) and Lab 3 (OIC Insight) are also made available as standalone labs in Luna if you have time constraint to complete all three labs on one go. Upon completion of this Lab you will be able to: Explain the business and technical architectures of the proposed solution for Mama Maggy. Build connections using OIC's prebuilt adaptors. Use connections to build a new integration that accepts order data via a REST POST and creates a new order row in the ORDERS table in the ATP database. Model an order submission and approval process using OIC’s Process component; Create a process application enabling store managers to submit requests and regional managers to approve/disapprove them; Initiate your integration (from Lab 1) from the process model to add a new order to the ATP database; Create an Insight model and associate it to a business process implementation by mapping model milestones to the process; Activate and test the model to view and analyze the business process and integration using dashboards. This lab is intended for: Anyone interested in application integration. Nil. March 29, 2022.

Time Limit
6 hours
Oracle Sales and Partner Academy
PaaS
Oracle Cloud Event Notification

Notifications should be an important part of any customers cloud infrastructure as they can save a lot of time and money. Notifications from applications can send emails or alerts to their users when something happens. For example: a file or order has been processed. The Oracle Cloud Infrastructure Notifications service broadcasts messages to distributed components through a publish-subscribe pattern, delivering secure, highly reliable, low latency and durable messages for applications hosted on Oracle Cloud Infrastructure and externally. Use Notifications to get messages whenever alarms, service connectors, and event rules are triggered. Upon completion of this Lab you will be able to: Setup a notification and verify that it works. Configure an Oracle Cloud Topic. Configure an Oracle Cloud Subscription. Configure and test an event and notification. This lab is intended for: Anyone interested in using Oracle Cloud. Basic computer experience. Having an issue with the lab? Have an idea on how it could be made better? Want to tell us how awesome the lab is? Click the icon below to contact the team and let us know your feedback. February 2023.

Time Limit
1 hour
Oracle Sales and Partner Academy
PaaS
APEX - Creating an App From a Spreadsheet

Oracle Application Express (APEX) is a low-code development platform that enables customers to easily build stunning, scalable, secure apps with world class features, that can be deployed anywhere. It's also included free in all current versions of the Oracle Database, including Autonomous Data Warehouse (ADW) and Autonomous Transaction Processing (ATP) services. This lab will show you how to create a robust APEX application with data imported from a common business spreadsheet. Many customers are wasting enormous amounts of time and energy keeping their business workflows and critical data in unmanageable spreadsheets. It's a common fact, spreadsheets don't scale. What if your customer could create a secure, scalable, multi-user application out of that spreadsheet that could save time and money? That's what you'll be learning in this lab! Build a secure, scalable application using uploaded spreadsheet data. Improve application by managing and changing the filters through APEX’s powerful faceted search. Improve the Interactive Report and form pages to add better usability features. Improve the Calendar page to reflect business objectives. Link pages. Build confidence in demonstrating the APEX application to customers! This lab is intended for: Cloud sales and engineering. Database cloud sales and engineering. Basic cloud familiarity. Having an issue with the lab? Have an idea on how it could be made better? Want to tell us how awesome the lab is? Click the icon below to contact the team and let us know your feedback. July 2022.

Time Limit
2 hours
Oracle Sales and Partner Academy
PaaS
Getting Started with Oracle Analytics

Connect to the right data, at the right time. Leverage the most complete platform in the cloud analytics market. Choose your own journey to the cloud. Deliver the technology your business stakeholders need to become innovators with Oracle Analytics Cloud. Collaborative, providing a efficient methods to interact and share information. This lab is intended for: Anyone interested in Oracle Analytics. None. Having an issue with the lab? Have an idea on how it could be made better? Want to tell us how awesome the lab is? Click the icon below to contact the team and let us know your feedback. March 16, 2023.

Time Limit
2 days
Oracle Sales and Partner Academy
PaaS
Oracle Integration Gen 2 (Process Automation)

In this lab, you’ll use the Process component of Oracle Integration (OIC) Gen 2 to build a process automation application Mama Maggy’s store managers use to enter order requests. Regional managers use the application to evaluate order requests from store managers. If the requests are approved, orders will be created in the ATP database using an imported integration. Estimated duration: 1-2 hours. Upon completion of this Lab you will be able to: Model an order submission and approval process using OIC’s Process Automation component; Create a process application enabling store managers to submit requests and regional managers to approve/disapprove them; Import a pre-built integration into the process model to add a new order to the ATP database. This lab is intended for: Anyone interested in application integration. Nil. May 20th, 2021.

Time Limit
3 hours
Oracle Sales and Partner Academy
IaaS
OCI Advanced - VCN Peering

OCI VCNs are distinct and by default cannot communicate with each other. This lab will show you how to create a local peering connection so that two OCI networks in the same region can communicate securely, without passing traffic on the public internet. You will create two VCNs, each with a deployed Linux instance. Then you'll connect the two together with a Local Peering Gateway to create a private connection that is not exposed to the internet. Upon completion of this Lab you will be able to: Create a secure private peering connection between two VCNs. This lab is intended for: Oracle Cloud Architects. Solution Engineers. Anyone interested in OCI network architecture. None. Having an issue with the lab? Have an idea on how it could be made better? Want to tell us how awesome the lab is? Click the icon below to contact the team and let us know your feedback. August 9, 2022 - Updated shape information.

Time Limit
8 hours
Oracle Sales and Partner Academy
PaaS
Provisioning Autonomous Database

This lab is a brief introduction to Oracle Autonomous Database on Oracle Cloud. You will provision an Autonomous Data Warehouse instance, connect to it, and view sample data using the Oracle SQL Developer web tool. Upon completion of this Lab you will be able to: Provision an Autonomous Data Warehouse on OCI. Connect to ADW via the Oracle SQL Developer web tool. Run a query on sample data. This lab is intended for: Executive and management level audience interested in the basics of the Oracle Autonomous Database. Basic computer operation experience. Familiarity with basic database concepts. June 24, 2022 - refresh. Having an issue with the lab? Have an idea on how it could be made better? Want to tell us how awesome the lab is? Click the icon below to contact the team and let us know your feedback.

Time Limit
1 hour
Oracle Sales and Partner Academy
IaaS
OCI Basics

Gain customer credibility by using the OCI console to create a virtual cloud network, add a virtual machine with storage, and launch a web application on OCI. Anyone interested in OCI. New to OCI and already have some familiarity with IT and Cloud concepts. OCI technical. - Basic overview training to help acquaint those new to OCI with a complete overview of terms and technology. Basic network, compute, and data storage knowledge. Entry-level knowledge of command-line Linux/Unix. Having an issue with the lab? Have an idea on how it could be made better? Want to tell us how awesome the lab is? Click the icon below to contact the team and let us know your feedback. May 25, 2023.

Time Limit
2 hours
Oracle Sales and Partner Academy