Skip to Main Content
EBS Analytics with ADW/OAC

About This Workshop

Youtube Video

About This Workshop
Departmental Analytics (with EBS Integration)

Lines of business, typically, don't have timely or efficient access to data and information. Analysts gather the data manually, work with it on an individual basis, and then share files through emails or file servers. With Oracle Autonomous Data Warehouse (ADW) and Oracle Analytics Cloud (OAC), you can load and optimize data from Oracle E-Business Suite (EBS) and other sources into a centralized data warehouse for analysis, so departments can gain actionable insights.

These lab guides provide directions on how one can set up departmental EBS analytics in Oracle Analytics Cloud. We will use Oracle Data Integrator (ODI) to load data from an EBS instance and a database into an ADW. Thereafter, we will connect the ADW to OAC, create data sets and import a prebuilt sample analysis with refined data.

Workshop Info

3 hours, 30 minutes
  • Provision the infrastructure required for the modern data warehouse.
  • Load data from multiple sources (EBS and database) into ADW using ODI.
  • Analyze data using OAC.
  • Access to an Oracle Cloud Infrastructure (OCI) account.
  • Necessary permissions and quota to manage and provision the required resources in your tenancy.

Other Workshops you might like