Real-Time Data Warehousing for the Real World
Our customers have proved it time and again: there's no substitute for real-time data.
One iWay Software customer had a large data warehouse, updated nightly, that was used by about 100 people. In order to get more use out of the data, the data warehouse manager tried to get the 800 people in the contact center to use it. Unfortunately, the contact center personnel couldn't use a system that didn't reflect the actual state of the customer's business dealings with the company.
They turned to iWay Software to tap into business data as it flowed in real-time throughout the company's applications and network. iWay Service Manager captured the events, enriched and correlated them with data from other systems, and transformed them into the form needed to update the data warehouse.
The result? The data warehouse now provides consistently fresh information – two minutes old, 50% less time than their requirements – to the contact center. In addition, iWay Software provides data-oriented Web services to open up the data warehouse to even more users. The cost per user of the data warehouse fell dramatically, and the value of the information skyrocketed.
Working the Tradeoffs
Real-time information requirements force administrators and architects to make serious engineering choices. Should data be transformed at the source, or manipulated after it moves to the target platform? Should it be handled through XML standards, SQL standards, or a combination? Are the larger file sizes of XML justified by the manipulation flexibility that they provide over SQL record sets? Should the data be put into a warehouse in near-real time, or should queries be distributed over multiple operational systems?
Fortunately, iWay Software lets administrators manipulate data in the way that makes the most sense for their environment. Standard ETL technology and real-time iWay Service Manager-based process flows can work in conjunction to feed data warehouses information from Web services, EDI documents, XML messages, flat files, and almost any other document format. And of course, we can access dozens of legacy, relational, and non-relational sources live through our sophisticated enterprise information integration (EII) and data adapter technologies.
In short, no matter what your data integration requirements may be, iWay Software can meet them.
For More Information
No other company provides the kind of sophisticated data integration and SOA-based integration technology that iWay Software does. To find out more, call toll-free (866) 297-4929 or e-mail us at info@iwaysoftware.com.
