DataMigrator, formerly ETL Manager, represents a broad category of tools designed to facilitate and automate the extraction and integration of data from various sources. At various points during the process, from source extraction through target load, data is transformed through the application of business rules. Once the transformation is complete, the data is loaded into table structures that have been optimized for a particular application.

DataMigrator, which is a component of the iWay Integration Suite, automates this process.

DataMigrator is a suite of software components that automates the process of building and maintaining a data warehouse or data mart. Using DataMigrator, you can:

• Access source data in numerous formats and operating systems.
• Integrate multiple data sources into a single target or multiple data targets.
• Apply powerful data cleansing rules and transformation logic.
• Aggregate data and create roll-ups to aid decision support.
• Use specialized high-volume data loaders.
• Schedule data updates at user-defined intervals, triggered by events, or based on conditional dependencies.
• Load a Star Schema with Slowly Changing Dimensions.
• Monitor and manage key server functions.
• View comprehensive logging and transaction statistics.

Since DataMigrator is a true client/server middleware solution, underlying communications protocols and data source subsystems are transparent.

Functions provide a convenient way to perform certain calculations and manipulations. They operate on one or more arguments and return a single value that is assigned to an output_format. The returned value can be stored in a field, assigned to a Dialogue Manager variable, used in an expression or other processing, or used in a selection or validation test. These functions can be used in source and target objects.