Data Integration
Using the Data Integration subject area, you can create reports and dashboards to analyze and visualize Data Integration Workspaces across tenancies, compartments, and regions. This subject area enables tracking workspace inventory and operational status using the curated logical model described below.
Business Questions
The subject area can answer the following business questions:
- Which workspaces are associated with a particular VCN?
- What's the count of workspaces in particular state (Creating, Failed, Stopped, Active, and so on)?
- How many workspaces are in an Active status?
- What's the count of workspaces with
isPrivateNetworkEnabled? - Which workspaces were created before a certain date and time?
- Can I get a list of workspaces with a particular state, in a particular compartment?
- How can I keep track of terminated workspaces?
- What's the count of public workspaces within a compartment?
- What's the metadata of a workspace?
Logical Model
The Data Integration subject area is based on a relationship-driven logical model.
A Data Integration fact table is connected to the following dimension tables:
Metric Details
The fact folders in this subject area show the following metrics:
| Metric | Description |
|---|---|
| Workspace Count | COUNT(workspaceId) from workspace_fact.workspaceId (primary-key in fact) |
| Terminated Workspace Count | SUM(terminatedWorkspaceCount) from workspace_fact.terminatedWorkspaceCount (1 if terminated, else 0) |