Database Integration: Integrate your Enterprise Data with iWay Software

Native adapters to enterprise data and applications provide real-time or near real-time access to over 300 sources of information.

True "Database Integration" implies the ability to access relational and non-relational data sources from back end systems such as Oracle, DB2, SQLServer, Essbase, and VSAM, from a common framework using one tool or set of tools. Access to the data is usually in the form of a query, but can also include update capabilities, and can happen in bulk, real-time, or near real-time.

iWay Software offers the broadest range of data 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 – so you can 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.html], 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.

iWay Software's parent company Information Builders also offers WebFOCUS – a best-of-breed Business Intelligence solution that will allow you to report from and analyze the data you have cleansed and reorganized using iWay's Database Integration solutions.

Glossary of Related Terms

• Adapters (Data Adapters, Application Adapters)
• B2B (B2B Software, Business to Business Integration, Business to Business)
• BI Software
• BI Systems (BI Services)
• BI Technology (B.I. Technologies)
• BI Tools
• BizTalk Server (BizTalk Integration, BizTalk Adapters )
• Business Integration
• Business Intelligence (Business Intelligence Software, Business Intelligence Solution)
• Compliance (Compliance Reporting, Regulatory Reporting)
• Data Analysis
• Database Integration (Data Integration, Enterprise Data Integration)
• Decision Support (Decision Support System, Decision Support Systems, DSS)
• EAI (Enterprise Application Integration, Enterprise Integration)
• e-Business (eBusiness, e-Business Software)
• ERP (Enterprise Resource Planning, ERP Adapters, ERP Systems, ERP Integration)

• ESB (Enterprise Service Bus)
• ETL (Extract, Transform, Load, ETL Tools, ETL Software)
• Extended Enterprise
• Information Delivery
• Integration (Enterprise Integration, Systems Integration, Integration Software)
• IT Infrastructure (Infrastructure Software)
• Key Performance Indicators (Developing KPIs)
• Messaging (Messaging Integration, Messaging Technology)
• Middleware
• OLAP (Online Analytical Processing, OLAP Tools)
• Real-Time Reporting
• Reporting (Web Reporting, Enterprise Reporting, Reporting Tools)
• Sarbanes-Oxley Act
• Sarbanes-Oxley Compliance
• Service Oriented Architecture (SOA, SOA and EAI, SOA and Java, SOA Adapters)
• Web Services (Web Services integration, Web Services EAI)

Java and all Java-related trademarks are the property of Sun Microsystems, Inc. All products and product names mentioned are trademarked or registered trademarks of their respective companies.