In this section:
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.
Click the New button on the Quick 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.
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.
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 while working in the Data Flow tab, right-click the workspace, select Add Source or Add Target, and then click Existing.
The Select Synonym dialog box has five default columns, but this can be customized. The following fields and options are 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:
Are the join conditions that can be used to join the already selected synonym to a new synonym.
Displays how the join conditions were found. You can find join conditions using:
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, select Add, and then click Source.
When this option is selected, only tables in the selected application directory, or server with columns that match key columns, are displayed.
When this option is not selected, 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:
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 selected, 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 that a connection has been made.
You may also need to create connections if the DMC default settings have been changed.
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, both the button and Save option in the main menu will 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 Procedure As dialog box opens, as shown in the following image.