Testing Sample Data and a Process Flow

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 DMDEMO
  1. Expand the ibisamp directory in the navigation pane.
  2. Double-click the dmdemo data flow. The data flow opens in the workspace at the right.

    This data flow extracts data from the data sources named dmord and dminv and loads an existing table named dmrpts.

  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/dmdemo complete
  5. Right-click the dmdemo data flow from the ibisamp directory, click Logs and then click 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.

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