Technical Reference

AWS EC2/RDS topology, ETL01 node, MySQL databases, SSIS execution environment.

How data moves from SSIS through DWRPT views to Juicebox and the AI agent.

All 13 SSIS jobs with status, runtimes, failure modes, and dependency mapping.

The full DAS data-processing surface: 231 SQL objects / 20 modules / 5 platforms (SSIS, Mautic, PostgreSQL-CDXP, Juicebox, BlackBook). Data flow, CVH identity join, and raw-vs-derived CDP ingestion guidance.

Each of the 27 MVP CDP fields → its ETL source (table.column), provider coverage (Authenticom/CDK/BlackBook), ingestion path, and availability. ~12 sourced today, the rest gaps. Mirrors the working "Data Source Catalog" sheet.

Per-database documentation for the source systems the CDP ingests from: rendered analysis doc, inline ERD, and searchable DDL dump for each — driven by each doc's frontmatter. 22 databases tracked; 11 with full schema + ERD as access lands.

Observed throughput, peak load, growth, and end-to-end latency across the four DAS SQL Server instances — the numbers the new CDP must match or beat. Audited 2026-06-14.

All 85 APIs DAS integrates with — operational and datasource — across 19 categories, from the DAS Integration Explorer v5. Each entry carries its Confluence research references and a research status; all pending until researched.

Complete schema-prefixed view catalog from DWRPT: SL, ML, RL, CDXP, core, dbo, zuora.

DAS-provided technical architecture plan. Data model, ingestion pipeline, identity resolution, Azure stack. Reference material — not a CONFLICT deliverable.

DAS-provided MVP specification. Feature scope, 4-stage build plan, identity resolution, multi-tenant. Reference material — not a CONFLICT deliverable.

DAS-provided Vehicle Smart Score microservices spec. Services, Kong gateway, Azure AKS/Event Grid, DB schema. Reference material — not a CONFLICT deliverable.

DAS-provided field → source-system mapping (Authenticom/CDK support, EDW_staging tables). Reference data — not a CONFLICT deliverable.