Your Data Anywhere

Yellowbrick

Yellowbrick Data Warehouse

The only modern enterprise cloud data warehouse.

The Yellowbrick Data Warehouse is an elastic, massively parallel processing (MPP) SQL database that runs on-premises, in the cloud, and at the network edge. It was designed for the most demanding batch, real-time, ad hoc, and mixed workloads and can run complex queries at up to petabyte-scale with guaranteed sub-second response times. Yellowbrick is proven, providing business-critical services at many large global enterprises with thousands of concurrent users. It is available on AWS, Azure, and Google Cloud as well as on-premises.

Elasticity in Your Cloud Account

The Yellowbrick Data Warehouse runs in your cloud account without data ever leaving your network to an external SaaS provider. This eliminates compliance and security risks. Running costs are lowered by paying for the cloud infrastructure (both storage and compute) using your own enterprise cloud agreements.

In an industry-first, full SQL-driven elasticity with separate storage and compute is available within your own cloud account as well as on-premises. Compute resources – elastic, virtual compute clusters (VCCs) – are created, resized, and dropped on-demand through SQL, and cache data persisted on shared cloud object storage. For example, ad-hoc users can be routed to one cluster, business-critical users to a second cluster, and more clusters created and dropped on demand for ETL processing.

Each data warehouse instance runs completely independently of one another. There is no single point of failure or metadata shared across instances. Global outages – when deployed with replication across multiple public clouds and/or on-premises – are impossible.

Yellowbrick is secure by default with no external network access to your database instance. Encryption of data at rest is standard with keys you manage. Columnar encryption, granular role-based access control, column masking, OAuth2, Active Directory, and Kerberos authentication are built in. Integrations with best-in-class enterprise data protection solutions secure PII data. Enterprise-class high availability, backups for data retention, and asynchronous replication for disaster recovery are standard.

Simple and Predictable Pricing

No more surprise bills with transparent and consistent pricing

We support both on-demand and subscription-based pricing. All pricing is based on consumption of vCPUs for compute; we do not charge for storage since data is persisted on object storage in your own cloud account. On-demand pricing caters to short-term burst needs and is billed monthly in arrears without credits. Subscription pricing is predictable, works across cloud and on-premises, and allows efficient acquisition of capacity that you know you’ll need. Models can be mixed and matched to meet business objectives.

Designed for Performance

Time is money. Faster answers = less compute spend
Yellowbrick was conceived with the goal of optimizing price/performance. The storage engine is a hybrid column and row store: Most data is persisted in the column store while the row store supports real-time streaming ingest of hundreds of thousands of records per second from CDC tools and Kafka. Yellowbrick’s patented Direct Data Path Architecture is an OS bypass technology enabling in-memory analytics performance at petabyte-scale without requiring a typical database buffer cache – leading to more predictable response times and massive cost reductions.

Open Standards Support

Keep control over your data - no vendor lock-in

Yellowbrick’s database engine is fully ACID compliant. A deliberate design choice was to make use of PostgreSQL’s SQL grammar, wire protocols, and metadata schema to avoid vendor lock-in and provide compatibility with a database familiar to modern developers. We’ve enhanced the PostgreSQL grammar with compatibility functions for other databases as well as improved manageability. All core SQL data types are present (numeric, UTF-8 varchar, dates and times, etc.). Further semi-structured data support is a key roadmap item. Views and PL/pgSQL stored procedures are fully supported as are cursors for data retrieval.

Access to Yellowbrick is through PostgreSQL ODBC, JDBC, and ADO.NET drivers. A substantial number of commercial and open-source tools, including Python, R, Kafka, and Spark interoperate with Yellowbrick.

Availability

Run data across clouds and on-prem without concentration risk

The Yellowbrick Data Warehouse is designed for business-critical data warehouse workloads and has no single points of failure. It is resilient to storage, server, and network outages. Data is persisted on shared object storage for the highest possible availability in the cloud and on erasure-coded local storage for on-premises deployments.

Full, cumulative, and incremental backups allow businesses to meet off-site data retention requirements. Transactionally consistent, asynchronous replication is built in and supports failover and failback; replication of DDL, data, and metadata allow provisioning of read-only hot standby databases for disaster recovery which may be in the same cloud, a different cloud, or on-premises.

Modern with Minimal Management

Power your data consistently across all instances, everywhere

The Yellowbrick Data Warehouse largely runs itself on autopilot. Minimal administrative activities are required: there’s no need for creating and maintaining indexes, vacuuming, keeping statistics up to date, and defragmenting; provisioning and managing storage is completely unnecessary.

A friendly web UI called Yellowbrick Manager surfaces all information needed to keep the instances running, configure integrations and control, and optimize workloads. For developers, Yellowbrick Manager provides a simple way to execute queries, develop and maintain schemas, and profile query plans. All management and monitoring functionality can be accomplished through SQL and system tables as well as the web UI.

Migration

Reduce risk and deliver value fast with easy, incremental cloud migrations

Migration from legacy data warehouses and SQL-on-Hadoop is largely automated. We partner with Next Pathway to offer their SHIFT™ Migration Suite. Shift features a workload profiler to automatically isolate workloads and identify their dependencies in complex data warehouses and Hadoop clusters, allowing estimation of migration effort and cost ahead of time. SHIFT enables >95% automated migration of the vast majority of database objects as well as ETL, BI, and even BTEQ scripts. Testing and validation services are offered alongside. We also partner with KPMG, Capgemini, Accenture, ZS, Systech, and Cognizant for other ongoing development and migration work.

Thanks to Yellowbrick’s unique distributed data cloud architecture, cloud migrations can be staged to reduce risk. Staging allows you to incrementally migrate from legacy on-premises warehouses to Yellowbrick, replicating data to the cloud and moving workloads as needed. Organizations with complex on-premises ecosystems prefer this approach: In particular, Yellowbrick is supported by both Informatica Powercenter and Informatica Cloud to enable easier ETL migrations. Our Customer Success Managers have first-hand migration experience and will be by your side throughout the process.

Summary

Yellowbrick is the modern data warehouse designed to solve today’s analytics challenges. It provides full elasticity in your own cloud account as well as on-premises, with separate storage and compute. Pricing is simple and predictable, and our architecture, optimized for performance, means that nobody runs data warehouses faster or more cost effectively than Yellowbrick. Yellowbrick is built on open standards to avoid lock-in, meets the availability needs of business critical, ad-hoc workloads, and is easy to use. Migration from legacy data warehouse platforms or Hadoop is largely automated.

The only modern enterprise cloud data warehouse.

The Yellowbrick Data Warehouse is an elastic, massively parallel processing (MPP) SQL database that runs on-premises, in the cloud, and at the network edge.

Powering the Highest Performing Data Warehouses for Large-Scale Enterprises.

We enable complex queries on live data to customers' most challenging business questions at a petabyte scale.
bread-financial-200px.svg
teoco-formatted.6ef341c.6d6f383c950d9dbcc4c3477afccf9d8d.svg
bmw-100px.svg
lexisnexis.svg
symphony.svg
Nielsen_logo.svg
yellowbrick-aci.svg
yellowbrick-customer-logos-horizontal.svg

Run all your data anywhere

The Yellowbrick Data Warehouse is trending
Yellowbrick | End of IQ Not Your Data
Learn why the Yellowbrick Data Warehouse is the next step for SAP IQ End of Life.
Trillions of rows load in minutes vs. hours. Queries run in seconds
Yellowbrick | The End of an Era
Learn why the Yellowbrick Data Warehouse delivers the optimal migration strategy for Netezza users. 100x faster. 10x more scale. Millions in savings.
Yellowbrick | MELCO
“Yellowbrick allows us to tailor meaningful solutions for our clients and analyze preferences and behaviors across millions of data points in real time.”
Jonathan Ozark
EVP Chief Strategy and Analytics Officer
Melco Resorts & Entertainment
Yellowbrick | TEOCO
“The power of Yellowbrick, combined with our deep knowledge of the data and proprietary algorithms, will produce insights that were impossible before.”
Atul Jain
Chairman & CEO
Yellowbrick | LexisNexis
“Following extensive testing of data warehouses and Hadoop-based solutions, we found that Yellowbrick provided superior performance.”
Matthias Baumhof
CTO
Yellowbrick | Symphony Retail
“It’s a big benefit to customers—and a big win for us—when we tell them they’ll get 10X more data accuracy and 2X performance gain. Our largest data set is about 60TB, which Yellowbrick is handling with ease.”
Nigel Pratt
SVP Development
Yellowbrick | Catalina
“Catalina’s partnership with Yellowbrick has significantly enhanced the performance of our on-premises data platform, enabling our teams to more efficiently deliver actionable insights and new data-driven solutions to our CPG, retail and agency partners.”
Michael Bailey
CTO
Catalina

Join Us for a Webinar

Meet our experts and learn how to leverage Yellowbrick's secure and fast query response.

Book a Demo

Blazing-fast performance at petabyte scale awaits you.

Book a Demo

Learn More About the Only Modern Data Warehouse for Hybrid Cloud

Faster
Run analytics 10 to 100x FASTER to achieve analytic insights that have never been possible.

Simpler to Manage
Configure, load and query billions of rows in minutes.

Economical
Shrink your data warehouse footprint by as much as 97% and save millions in operational and management costs.

Accessible Anywhere
Achieve high speed analytics in your data center or in any cloud.

Search Our Data