Data Analysis and Intelligence Blueprint

Data Analysis and Intelligence comprises the ability within Adobe Experience Platform to perform exploratory query and analysis of the data that exists in the data lake.

Experience Platform’s Query Service allows SQL queries to be performed on the data.

Experience Platform allows connections with third-party SQL clients, interfaces, and Business Intelligence (BI) tools to directly connect to, access and query the data within Experience Platform, using the PostgreSQL protocol.

Certain guardrails apply for the query timeout and for the amount of data that is included in the query result, as noted in the guardrails section below.

Use Cases

  • Interactive query and aggregation of data
  • Row and column access to ingested data for exploration and validation
  • Dashboarding and visualization of data via Business Intelligence tooling

Applications

  • Adobe Experience Platform

Architecture

Reference architecture for the Enterprise Data Exploration and Reporting Blueprint

Guardrails

Refer to the Query Service Product Documentation for details on best practices and guardrails.
Query Service Guidance

Implementation Steps

  1. Create schemas for data to be ingested.
  2. Create datasets for data to be ingested.
  3. Ingest data into Experience Platform.
  4. Confirm that data is available to Query Service and Data Science Workspace for raw access and query.
  5. Connect Business Intelligence tools and SQL clients to Query Service for visualization, data query, and exploration.

On this page