Simple Data Flow at a Glance

You can use DataMigrator to build data flows ranging from the simple, where data is moved from one source into one target, to the complex, which employs multiple sources and targets and a variety of data extraction techniques.

This simple data flow consists of a data source, an SQL object, and a data target, as shown in the following image.

Simple Data Flow

To create a simple data flow:

  1. Open a new flow.

    The Data Flow tab opens by default, with an SQL object in the center of the workspace.

  2. To add a data source object, drag a data source object from the list of synonyms in the navigation pane into the workspace, to the left of the SQL object.
  3. Select the columns that you want to extract from the source and copy into the target.

    Note: If Automatically select all columns is selected in the Data Flow Designer user preferences tree from the Options dialog box, you do not need to manually select columns.

  4. To add a data target object to the data flow, right-click the workspace to the right of the SQL object, select Add Target, and then click New.
  5. Save and submit the data flow.

    Note: Flow names can be up to 64 characters.

  6. View the log file for data flow details.

iWay Software