What is Blue Yonder CKB Database Replication?
Blue Yonder CKB Database Replication is a service that provides a replicated, read-only copy of the Category Knowledge Base (CKB) database, giving customers direct read access to core CKB tables for reporting and analytics.
Category management data—planograms, floorplans, assortments—is enormously valuable to downstream reporting and analytics teams. But in Blue Yonder's Cloud, direct access to the main Category Knowledge Base (CKB) is not allowed, for good reason: ad-hoc queries against the operational database would put space planning performance at risk. CKB Database Replication resolves this tension by providing a replicated copy of the CKB database to which customers have direct, read-only access.
Why It Matters: Open the Data, Protect the System
Retailers want to join space data with sales, loyalty, and supply chain data in their own BI environments. Without a sanctioned path, teams resort to manual exports—slow, stale, and error-prone. The replicated database is that sanctioned path: direct read access to core CKB tables without running reporting queries against the production system.
How It Works: A Read-Only Mirror
- Database Replication: The CKB database is replicated to a separate copy maintained by the service.
- Direct Read Access: Customers query the replicated database directly—the access to core CKB tables that Cloud policy does not permit against the main database.
- Read-Only by Design: Access is read-only, so downstream consumers cannot change the category management system of record.
Key Benefits
- True SQL Access to Space Data: Reporting and analytics teams query real tables, not flattened exports.
- Production Performance Protected: Heavy analytical workloads run against the replica rather than the operational CKB.
- Fresher Downstream Data: Replication replaces manual extract cycles.
- Safe by Construction: Read-only access protects the integrity of the category management data.
The Blue Yonder Difference
Because the replica preserves the genuine CKB schema, everything customers build against it—reports, data pipelines, analytical models—works with the full richness of the category management data model rather than a simplified extract.