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.
Finally, Omni-Gen provides a single platform for generating applications that combine data integration, data quality, and master data management – in a fraction of the time such projects used to require. The benefits are huge: The time for typical projects can be reduced from years to months or even weeks.
Information Builders also offers WebFOCUS – a best-of-breedBusiness Intelligence and analytics solution that will allow you to analyze and report from the data you have cleansed and reorganized using our integration solutions.