The “Data Bridge” for a Logical Data Warehouse
The pressure of more data and analytics is spurring organizations to rethink their EDW strategy. Many have already embarked on creating a logical data warehouse, where data and analytic computation is distributed on fit-for-purpose systems. This architecture reduces costs, offers optimal price-performance for different workloads and creates the agility business users crave.
Simplifying movement of data between nodes is essential to the success of a logical data warehouse. A common first step in building-out of the logical data warehouse is to offload analytics from the EDW to a purpose built system (typically an analytic appliance) - this accelerates deep analytic queries and frees up compute cycles on the EDW for reporting and operational querying. While the business benefits are obvious, a potential hurdle to the process is establishing and managing data replication between EDW and analytic marts. Technologies to move data can demand greater specialized resources than businesses can afford.
Organizations need an “easy button” to simplify the setup and management of replication, ETL and change data capture technologies, so creating a “Data Bridge” between systems in the logical data warehouse. That’s what we’re developing in our labs, and we plan to make it available to customers in the near future. In the picture above you see a screenshot of a cool tool called Blueprint Director that offers a wizard-based GUI to drag-and-drop a subset of data from the EDW into an analytic mart. The tool automates a series of actions otherwise requiring the work of several administrators - initializing the database on the target system, creating mappings between the source and target database objects, and configuring the underlying replication technology. The tool is flexible and extensible, meaning we can accommodate many more use cases, and dramatically simplify other areas of data warehousing and BI.
If you happen to be at the IOD conference, do stop by our booth and check out the demo of the “Data Bridge” in action.