Designing Data Flows and Process Flows

At the core of DataMigrator is the ability to design data flows and process flows, which are types of procedures. The DataMigrator Data Management Console 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.


Top of page

Example: Designing a Data Flow

This Data Flow consists of a data source object, an SQL object in which the columns to be extracted are defined, and a target object that contains the data target you are loading. Double-click these objects to view the columns of each object. In the SQL column selection object, you can add filtering and sorting criteria, arrange columns, insert columns, and create expressions to generate columns of new data. In the target object, you can perform transformations that apply calculations to columns (for example, you can multiply two columns or use functions to perform specialized calculations), edit synonyms, view sample data, and specify mapping logic.

The navigation pane at the left lists available servers and available synonyms for source and target objects.

A data flow typically becomes an object in a process flow. To open a data flow from a process flow, right-click the data flow and select Open. For details about the creation and relationships between data and process flows, see Designing a Data Flow and Designing a Process Flow.


iWay Software