Creating a Process Flow

Once you have the flows working you may want to automate the process. You can do this by adding each data flow into a process flow, and entering the run time parameters.

  1. Right-click an application directory and select New, then Flow.

    A data flow opens.

  2. Click the Process Flow tab.
  3. Drag your data flow that creates a delimited flat file in the workspace.
  4. Repeat for each of the following flows:
  5. Right-click start and drag a line to the next flow and release. Repeat this until all the flows are joined together, as shown in the following image.

  6. Right-click create_job_batch and select Properties. Click the Parameters ellipses and click OK.

    The Parameter Editor opens. Select the Show all Parameters checkbox. Enter the values for INPUTFILE as the location of your input file and OBJECT as Opportunity, as shown in the following image.

  7. Click get_batch_results. Click the Parameters ellipses.

    The Parameter Editor opens. Select the Show all Parameters checkbox. Enter a value for OUTFILE, then click OK.

  8. Click the Run button and select Submit.

    The Save Procedure As dialog box opens. Enter a name, such as create_opportunities and click Save. Wait for the flow to complete.

  9. Click the View Last Log button to confirm that all of the data flows completed successfully. The blue lines are hot links, and you should be able to drill down to see the individual logs, as shown in the following image.

  10. In the browser, right-click jobresp and select Sample Data. View the results to ensure that the job completed successfully.
  11. In the browser, right-click batchresults and select Sample Data. View the results to ensure that all records were loaded.

WebFOCUS