iWay’s New CDC Feature Supports Active Data Warehousing
When an extract-transform-load (ETL) tool can identify source data that has recently changed, it can update data warehouses quickly. Such warehouse updates that work in near real-time updates are key to “active data warehousing,” which combines rapid data retrieval with up-to-date information that’s much more timely
than conventional data warehouses can provide. Companies that achieve active data warehousing can gain valuable benefits like better decision-making, problem solving, and opportunity discovery from existing data warehouse systems and investments.
The secret of efficient new active data warehouses is “Changed Data Capture,” or CDC for short. CDC detects and reports only the changes that occur in a data structure – it can eliminate expensive, long-running ETL jobs and literally save hours each time such a process executes. Not surprisingly, CDC technologies
have become an important feature for ETL users.
iWay CDC Powers Both ETL and e-Business Applications
iWay Software’s new CDC engine was developed by iWay partner Lakeview Technology. The CDC engine works with iWay ETL Manager to make near real-time ETL a reality for major warehouse platforms and relational databases, as well as over 200 data sources accessible through iWay’s integration middleware
architecture. It can also provide changed data to the iWay XML Transformation Engine (iXTE), to drive highly efficient new e-business processes based on standards such as HIPAA, HL7, SWIFT, or FIX.
iWay’s CDC solution utilizes robust data replication from Lakeview’s OmniReplicator engine. It runs on MVS, Unix, AS/400, and NT, and its change detector covers all major relational databases on those platforms. The CDC engine is simple to install and configure with iWay ETL Manager, providing a flexible and highly
efficient solution whether the target is a data warehouse, data mart, or an operational data store.
For more information on iWay’s new Changed Data Capture engine, visit www.iwaysoftware.com or call your local iWay Software branch office.
iWay and Lakeview Technology Form Strategic Alliance
Lakeview Technology and iWay Software have joined in a strategic partnership to dramatically improve available solutions for extract, transform, and load (ETL) and enterprise data manipulation and movement. The strategic partnership will join Lakeview’s OmniReplicator changed data capture technologies with
iWay’s ETL and XML Transformation products in a series of solutions that span all industries.
The alliance aims to help users minimize the time, cost, and network impact of extracting data from very large databases and legacy systems for use in warehouses or e-business applications.“ We are enthusiastic about our alliance with iWay because it expands and extends our customers’ abilities to optimize
their business operations,” said Eric Robinson, vice president of Sales and Marketing for OmniReplicator. “Converging our change-based data replication with iWay’s leading ETL Manager solution provides our customers with the ability to vastly improve performance when extracting data from their legacy
systems.”
“Lakeview’s OmniReplicator delivers a cost-effective and efficient change data capture solution that covers all major relational databases,” added Roger Panfil, iWay’s vice president of Marketing. “Our combined solution is flexible and highly efficient – whether the target is a formal data warehouse, a data
mart, or an operational data store.”
|
 
|
|
