Oracle Cloud Infrastructure Documentation

Integration Cloud

Using the Integration Cloud subject area, you can create reports about the integration runtime activity and optional features such as Visual Builder and File Server.

Business Questions

The subject area can answer the following business questions:

  • Integration Instance Overview:
    • What is the total count of integration instances by compartment?
    • How many integration instances are in each lifecycle state (e.g., ACTIVE, INACTIVE)?
    • What is the distribution of integration instances across different shapes (e.g., DEVELOPMENT, PRODUCTION)?
  • Attachment and Integration:
    • How many attachments are associated with each integration instance?
    • What is the distribution of attachments by target service type (e.g., FUSION)?
    • For a given compartment, what are the integration instances and their corresponding attachments?
  • Usage and Adoption:
    • How many integration instances are using Bring Your Own License (BYOL)?
    • What is the count of integration instances by their integration instance type (e.g., STANDARD, ENTERPRISE)?
    • Are there any integration instances with disaster recovery enabled, and if so, how many?
  • Performance and Health:
    • What is the count of integration instances in each lifecycle state, and what are their corresponding lifecycle details?
    • Are there any integration instances with a specific state message or error?
  • Cost and Billing:
    • For compartments with integration instances using BYOL, what is the total count of such instances?
    • How many message packs are configured for integration instances in each compartment?
  • Security and Governance:
    • What are the defined tags and freeform tags associated with integration instances, and how are they distributed?
    • Are there any integration instances with specific network endpoint details or private endpoint outbound connections?
  • Change and Audit:
    • When were integration instances created or last updated?
    • Are there any patterns or trends in the creation or update times of integration instances?

Logical Model

The Integration Cloud subject area is based on a relationship-driven logical model.

An Integration Instance Attachment fact table is connected to the following dimension tables:


Fact table Integration Instance Attachment connected to six dimension tables, Tenancy, Compartment, Date, Region, Integration Instance, and Integration Attachment Details.

Metric Details

The fact folders in this subject area do not contain any metrics.