Testing Sample Data and a Process Flow

Once you have verified that all required ibi Data Migrator 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.

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. From the Flow tab, in the Run group, click Run.
  4. Click Submit from the dropdown menu.
  5. When the data flow run has been completed, the following message appears in the Server Console Log: 
    (ICM18763) Request ibisamp/dmdemo complete
  6. Right-click the dmdemo data flow from the ibisamp directory, point to Logs, and then click Log and Statistics.

    The Log and Statistics dialog opens. From the Report Type dropdown menu, select Log and then click the View Report button. The log, which is displayed in the workspace, indicates that the table named dmrpts has been loaded with 178 rows.

  7. From the Home tab, in the Windows group, click Windows and then click Close All 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.