iWay DataMigrator

iWay DataMigrator is a powerful and comprehensive set of fully automated 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 allows users to efficiently:

Key features and advantages that are provided through iWay DataMigrator include:

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

iWay DataMigrator Architecture

iWay DataMigrator is comprised of two basic components and one supplementary component:

DataMigrator Server. A server must be installed and configured to support iWay DataMigrator operations. The server houses and executes data and process flows, which are the key iWay DataMigrator design elements.
DataMigrator Data Management Console (DMC). The main component of the DMC is the DataMigrator graphical user interface. It runs on a Windows PC, where you design, test, and run data and process flows.
Server Web Console. The Server Web Console is installed with the server. It enables you to perform browser-based server administration tasks.

You must install and configure these components before you can begin using iWay DataMigrator to build the data flows and process flows that will build your data targets.

The following image shows the main window of the DMC, where a data flow is being designed in the workspace.

At the core of iWay DataMigrator is the ability to design data flows and process flows, which are types of procedures. The DMC facilitates the design task using two tabs, Data Flow and Process Flow, and provides a Text View tab from which you can see the code generated by the graphical tools.

Data Flow. Normally, you design a data flow from a set of objects that identifies your data sources, your data targets, the columns of data to include in the data targets, and the business rules that govern how the data is extracted from the sources, transformed, and loaded into the targets.
You can join multiple data sources, filter and sort the extracted source data, and specify column mappings from the source to the target.
Process Flow. You structure how the data flow is processed by positioning objects in your workspace and defining their interactions. You can combine:
- A schedule object that defines when to run the process.
- Data flow objects that indicate what data to extract and move from data sources to data targets.
- E-mail objects that notify users about the status of the process at specified points.
- Stored procedure objects that perform a variety of supplementary tasks before or after the extraction and load steps defined in a data flow.
- Variable objects that set values for the variables used in a flow.
- Connector objects, represented as arrows, that specify execution logic for the objects in the process flow (for example, what to do next when a step succeeds or fails).
- Group objects that specify parallel, rather than sequential, execution of a subset of objects within the total flow. Objects that follow are not executed until processing for the grouped objects is complete.
Text View. This tab enables you to toggle between the graphical interface and the underlying code at any point in your design process.