Solutions

EDW Offload

<< Back to Solutions

The cost of maintaining a traditional Enterprise Data Warehouse (EDW) is skyrocketing as legacy systems buckle under the weight of exponentially growing data and increasingly complex processing needs. Hadoop has massive horizontal scalability along with system-level services that allow developers to free up storage and processing power from premium EDW platforms, increasing the ability for IT organizations to meet SLAs.

But Hadoop is not a complete ETL (Extract-Transform-Load) solution. While the platform offers powerful utilities and virtually unlimited horizontal scalability, it does not provide the complete set of functionality users need for enterprise ETL. In most cases, these gaps must be filled through large number of lines of complex manual coding, slowing Hadoop adoption and frustrating organizations eager to deliver results.

CDAP fills the gaps between Hadoop and ETL needs. Cask’s EDW Offload solution package comes with pre-built pipelines which can be edited in a studio environment that consists of drag-and-drop sources, transforms, analytics, sinks, and actions. The bulk load pipeline reads data from your EDW, transforms fields in the data using the wrangling tool, and writes it to a denormalized table on Hadoop. After you have migrated data and workloads to Hadoop, CDAP ensures extensive security and sophisticated governance across your datasets. This is done by automating the collection metadata from ingestion to data delivery. Additionally, CDAP provides access controls that meet typical security needs of the enterprise.

Rapid Time to Value

Pre-configured pipelines in Cask Hydrator save developers the complex and time-consuming process of having to write custom data pipelines from scratch, enabling quick deployment of EDW offload solutions.

Simplifies Processes

Cask Hydrator provides a graphical drag-and-drop interface for building pipelines from the EDW into Hadoop.

Cask Tracker provides metadata audit, which simplifies tracking data flows and makes it easier to retrieve, use, and manage datasets.

Want to see CDAP in action? Request a personalized demo. >>