Simplified Enterprise Information Integration (EII)
It has been a headache since the second computer was created: the information you need is available, but it's on more than one system.
Many business intelligence solutions force you to move information from application databases to data warehouses or data marts. Just answering one-off questions can require throw away databases that only exist because the BI tool's query capabilities are too weak. Unfortunately, the modeling, selection, preparation, extraction, transformation, transport, and load can be complex, time consuming, and costly.
As you deploy business intelligence solutions to more personnel, the problems get even more acute. The data usually takes its time to move – hours if you're lucky, and a day or more if you're not. High-latency data just doesn't help people who are interacting with customers, suppliers, and partners in real time.
Information Builders' enterprise information integration (EII) capability offers a better way. Instead of requiring physical data movement, it enables WebFOCUS users to issue distributed queries that correlate and manipulate data from disparate relational databases, packaged applications, structured data files such as XML and EDI documents, and legacy databases and files. Instead of waiting for the warehouse to load, users gain immediate insight into information as it changes – from any one of the over 300 information systems that Information Builders supports. Data federation technology allows integration and access of virtualized data from multiple sources while keeping the original data in place.
iWay Data Hub
For general-purpose EII operations, the iWay Data Hub leverages the iWay Universal Adapter Framework to access disparate data sources through a single, federated query. The iWay Data Hub and Universal Adapter Framework, together, provide location transparency, ensure that non-relational data sources are made to look relational, ensure that databases receive well-tuned SQL (or other query language), and deliver well-formed result sets. Information consumers can use a variety of interfaces to submit the query, including ODBC, JDBC, web services, and others.
- Shortens project timelines, reduces dependency on proprietary skill sets, reduces cost, and facilitates reuse and maintenance by eliminating much of the complex design and code requirements normally associated with complex query development
- Provides comprehensive access to legacy systems and packaged applications, without hand coding
- Reduces deployment time and cost by one half to one third that of other EII technologies