In this section:
How to: |
The first step in building a data flow is to create an empty flow. You will then be able to add objects to this flow and set up mappings and relationships.
or
Click the New button on theQuick Access Toolbar.
An empty data flow appears in the data flow workspace. The Data Flow tab opens by default, with an SQL object in the center of the workspace.
How to:
Reference: |
You can add or delete objects in the data flow workspace. Objects on the left of the SQL object are sources and objects on the right are targets.
Note: When adding objects, there is no limit to the area they can take up. If the number and arrangement of objects exceeds the viewable area of the workspace, a scroll bar will appear.
or
or
or
If you are adding a source or an existing target, the Select Synonym dialog box opens. Select a synonym and click the Select button.
The Select Synonym dialog box has a search feature that allows you to find synonyms by searching their names and descriptions.
The Select Synonym dialog box opens.
The Find dialog box opens.
The first synonym name or description containing the string is highlighted in the Select Synonym dialog box.
Note: After closing the Find dialog box, you can still search for the next match using F3. Shift + F3 will find the next match searching upward.
The Select Synonym dialog box is available by right-clicking in the workspace while working in the Data Flow tab and selecting Add Source or Add Target and then Existing.
The Select Synonym dialog box has five default columns, but this can be customized. The following fields and options available:
Is the name of the application directory where the synonyms are located. Select the server name to see all synonyms in all directories.
Is the name of the synonym.
Is the type of synonym.
Is the description of the synonym.
The following two columns are available if you are adding a source to a Join object that already has a synonym selected:
The join conditions that could be used to join the already selected synonym to a new synonym.
Displays how the join conditions were found. This could be by:
Note: Clicking any of the column headings will sort the list on that field. A column sorted ascending will display an up arrow, while a column sorted descending will display a down arrow.
Allows you to create a new synonym.
Allows you to search the application directories for a particular synonym.
This button is enabled when you already have one table connected to a Join condition and you right click a Join object and select Add and then Source.
When selected, only tables in the selected application directory or server with columns that match key columns are displayed.
When unselected, all tables in the selected application directory or server are displayed.
Adds the highlighted synonym to the workspace.
Allows you to enter a synonym name or shows the name you have selected.
Allows you to select the synonyms by their adapter type. For example, you can display only synonyms for MS SQL Server tables.
Left-click on a column header in the title bar to sort the list of synonyms on that column. Do it again to reverse the order. Right-click a column header in the title bar to open the context menu with the following options:
How to: |
The connections between objects in the data flow workspace allow information to flow between them.
The DMC default User Preferences automatically connects objects.
Note: The Options dialog box provides access to the DMC User Preferences. If the Add Join Object if needed setting on the Data Flow Designer page is checked, source objects are automatically connected to a join object if more than one is dragged onto the workspace. For details, see How to Automatically Add Join Objects.
When objects are deleted, you may need to recreate the connections between some of the remaining objects.
An arrow will appear indicating the connection.
You may also need to create connections if the DMC default settings have been changed.
How to: |
Data flows are saved on the DataMigrator server. The first time you save a data flow, you will select an application directory and assign a name to it. After that, you can save it with the same name or assign a new one.
The following restrictions apply to flow names:
Note: A flow can only be saved once changes have been made to it. If no changes have been made, the button and Save option in the main menu will both be inactive (grey).
If this is the first time a flow is being saved, the Save As dialog box will open. See How to Save a Data Flow with a New Name.
The Save As dialog box opens.
Click Save.
iWay Software |