Data Integration (Database Integration)
True data integration or database integration implies the ability to access any source of data within or outside your enterprise and use this information in virtually any application or mission-critical system. Data may be stored in relational or non-relational/hierarchical database formats such as Oracle, DB2, SQLServer, MySQL, Essbase, FOCUS db and VSAM. Information may also be stored in ERP systems such as SAP. Access to the data is usually in the form of a query, reporting system or dashboard, but can also include update capabilities, and can happen in bulk, real-time, or near real-time.
Information Builders' iWay Software integration platform offers the broadest range of database integration options available today – empowering you to provide direct access to data in operational systems, stage data in warehouses or marts, and allow dynamic drill through to detail data in real time. iWay enables you to design your architecture to address the unique information needs of all your users. From a comprehensive adapter suite and powerful ETL tools, to intelligent resource analysis and governing solutions, iWay Software provides everything you need to develop an effective, yet economical strategy for accessing, storing, managing, and delivering all your enterprise information assets.
iWay database integration solutions are made possible using our intelligent data adapters. Data adapters provide a relational view of more than 80 different relational and nonrelational databases on 35 platforms. They contain iWay-provided logic and metadata to perform simple or complex SQL-based data manipulation against target systems that include VSAM, Adabas, IMS, IDMS, MUMPS, Model 204, and others. iWay data adapters enable cross-data source joins and two-phase commit capabilities across XA- and non-XA-compliant databases.
iWay adapters can provide statistics on their usage and performance characteristics, and when used in ETL processes a full audit trail can be achieved from source to target. The result is easier data warehousing, ETL process development, EAI, BPM, business intelligence [business-intelligence], and application development. Some of the uses of iWay adapters include:
- ETL using DataMigrator, iWay's ETL tool
- Enterprise reporting and analysis using WebFOCUS, Information Builders' business intelligence tool
- .NET application development
- Java application development using J2EE application servers
- EAI using integration brokers and ESBs
- Custom applications using Microsoft Office
iWay Software accelerates business integration by simplifying it dramatically - eliminating custom integration code, and replacing it with the straightforward assembly and configuration of off-the-shelf components. iWay Software provides everything necessary to achieve real-time, near-real-time, or batch integration more quickly and easily than competing tools and the "roll-your-own" approach.