ETL Tools (Extract, Transform, Load)
ETL, which stands for "extract, transform and load," is the set of functions combined into one tool or solution that enables companies to "extract" data from numerous databases, applications and systems, "transform" it as appropriate, and "load" it into another database, a data mart or a data warehouse for analysis, or send it along to another operational system to support a business process.
iWay DataMigrator is a powerful and comprehensive set of fully automated ETL tools designed to dramatically simplify data integration, including the creation, maintenance, and expansion of data warehouses, data marts, and operational data stores. With its intuitive, easy-to-use interface, DataMigrator enables fast, flexible end-to-end ETL process creation involving heterogeneous data structures across disparate computing platforms.
DataMigrator provides greater reach and range than any other ETL offering on the market today. It employs iWay Software’s award-winning adapters to provide seamless access to and migration of virtually any enterprise data. DataMigrator can also utilize ODBC, JDBC, XML, and Web services connectivity for additional database access. And because the DataMigrator integration engine provides complete data structure transparency, all sources accessed by the servers on your network appear as a set of relational tables – so cross-platform, multiple database extractions and joins are just a mouse-click away.
iWay ETL solutions are made possible using our Intelligent Data Adapters. Data adapters provide a relational view of more than 80 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 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's SOA Middleware Suite 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 ETL solutions.