Testing Sample Data and Process Flows

Once you have verified that all required DM setup tasks have been successfully completed, you can perform three simple tests to ensure that your flows will run properly. We created some sample data and process flow procedures for you to use in testing your setup.

We recommend that you run these tests before you create and attempt to run your own flows.


Top of page

Example: Testing the Sample Data Flow DMVPX
  1. Expand the ibisamp directory in the navigation pane.
  2. Double-click the dmvpx data flow. The data flow opens in the workspace at the right.

    This data flow extracts the department ‘Production’ data from the data source named employe2 and creates a new data target, also named dmvpx.

  3. Click the Run icon on the toolbar and select Submit from the drop-down menu.
  4. When the data flow run has been completed, the following message appears in the Server Console Log:
    (ICM18763) Request ibisamp/dmvpx complete
  5. Right-click the dmvpx data flow from the ibisamp directory, select Logs and then Log and Statistics.

    The Log and Statistics dialog box opens. From the Report Type drop-down menu, select Log and then click the View Report button. The log, which is displayed in the workspace, indicates that the new table named dmvpx has been created and loaded with six rows.

  6. Select Close All from the Window menu to close the log and the data flow window.

Top of page

Example: Testing the Sample Data Flow DMVPY

This example assumes that you have already completed Testing the Sample Data Flow DMVPX, since it uses a table that you create there.

  1. Expand the ibisamp directory in the navigation pane.
  2. Double-click on the dmvpy data flow. The data flow opens in the workspace at the right.

    This data flow extracts the records for the department 'MIS' from the data source named employe2 and adds them to the existing table dmvpx.

  3. Click the Run icon on the toolbar and select Submit from the drop-down menu.
  4. When the data flow run is complete, the following message appears in the Server Console Log:
    (ICM18763) Request ibisamp/dmvpy complete
  5. Right-click the dmvpy data flow from the ibisamp directory, select Logs and then Log and Statistics.

    The Log and Statistics dialog box opens. From the Report Type drop-down menu, select Log and then click the View Report button. The log in the workspace shows that the target table exists and that six records for the MIS department were added to the target.


Top of page

Example: Testing the Sample Process Flow DMVPZ

The data flows that ran separately in Testing the Sample Data Flow DMVPX and Testing the Sample Data Flow DMVPY now run as a combined process flow.

  1. Expand the ibisamp directory in the navigation pane.
  2. Double-click on the dmvpz process flow. The process flow opens in the workspace at the right.

    This process flow sets up the flow of dmvpx followed by dmvpy.

  3. Click the Run icon on the toolbar and select Run from the menu.

    When the process flow runs, the first data flow creates the new table and the second data flow loads it with additional records.

  4. Click the Run icon on the toolbar and select Submit from the drop-down menu.
  5. When the process flow run is complete, the following message appears in the Server Console Log:
    (ICM18763) Request ibisamp/dmvpz complete
  6. Right-click the dmvpz data flow from the ibisamp directory, select Logs and then Log and Statistics.

    The Log and Statistics dialog box opens. From the Report Type drop-down menu, select Log and then click the View Report button. The log in the workspace shows that the two data flows ran successfully.

Next Steps: If you have received these results, you can feel confident that your client/server setup is running correctly and you can proceed to the design phase.

If you are not familiar with DM processing, we urge you to read Planning a DataMigrator Application, before you begin creating flows to ensure that you make optimal decisions about such issues as data structures and security to meet the needs of your site.


iWay Software