Data Warehouse Automation with WhereScape
We all want answers, and we’d like them now!
By Neil Barton, WhereScape Chief Technology Officer
In 1789, Benjamin Franklin wrote that nothing can be said to be certain apart from death and taxes. Fast forward 230 years and we can add to that list of certainties peoples’ desire for immediacy. Social media has proven this in our personal lives, and business decision-makers want information on-demand as well. Immediately. As technology becomes increasingly able to provide us with this instant information, so increases the pressure on IT teams to deliver it to their organizations. Time, after all, is money.
Last month, WhereScape and HVR announced our partnership helping data warehousing teams accelerate their capability to deliver the near-real-time information that businesses crave. If you’re an HVR customer, you are familiar with HVR’s log-based change data capture capabilities to help your team more easily detect and load new data into your data infrastructure. But you may not yet be aware of how data warehouse automation (DWA) can help your team fast-track the design, development, deployment, and operation of the data infrastructure that will utilize it. Here are just a few of the benefits that data warehouse automation can provide to further accelerate your abilities to deliver the analytics your organization expects:
Increase in team productivity
DWA is all about increasing the productivity of your data warehousing team and enabling them to deliver more given their existing resourcing constraints. It removes 80-90% of the manual coding effort of designing, building and managing a DW. By leveraging the patterns apparent in data warehousing best practices, models and data platform development, data warehouse automation can take over the repetitive work previously needed by your team. It can shrink project timelines and free your staff up to tackle the more strategic elements of the project or better yet spend more time working with the business to identify and address their needs.
Increase in business responsiveness
Data warehouse automation increases IT’s ability to be responsive to business needs – both in regards to the business’ initial requests for assistance and in the undoubtedly changing and evolving nature of these requests over time. Working with business leaders, you need to establish a cadence of implemented change for all to remain engaged. If it takes a few days or weeks to make a change based on some input from the business, then business stakeholders will lose focus and IT will lose their engagement. Metadata-driven automation, like WhereScape, provides you with the ability to quickly and easily incorporate changes into the data infrastructure you deliver.
Automatic updates to documentation
An extremely valuable by-product of DWA is the availability of documentation without the labor-intensive effort of constructing and maintaining it. For most organizations, documentation – if available at all – is often of poor quality and/or out of date most of the time. The result of which is that most organizations are reliant on the tribal knowledge stored among long-standing employees. But what happens when those employees aren’t available to consult? Or if memories are hazy? Given its use of metadata, data warehouse automation automatically creates and updates business and technical user documentation as developers work, from data lineage to impact analysis and more. With this, your team is in a much stronger position to more easily tackle the new and evolving data infrastructure needs necessary to satisfy business needs.
Faster time to value
The partnership between WhereScape and HVR is an exciting one for me, because the ability to provide transactional consistent data and real-time replicated data with no worries of latency or lapsed documentation will enable IT to better serve the business with the information they need, when they need it. And if the expectation of immediacy is a new certainty in our lives, this improved capability to deliver will strengthen the bonds and collaboration between two groups critical to an organization’s success.
To see firsthand the value of pairing HVR with WhereScape data warehouse automation, take a look at this recent webcast or review this HVR-WhereScape solution brief. You can also learn more about WhereScape automation software here.