Specifications

CHAPTER 4 Working with Data Pipelines
Users Guide 139
Using an existing pipeline
If you save a pipeline, you can modify and execute it any time. You can also
pipe data that might have changed since the last pipeline execution or pipe data
to other databases.
❖ To use an existing pipeline:
1 Click the Open button in the PowerBar.
2 In the Open dialog box, select the Pipelines object type in the Object Type
drop-down list, select the pipeline you want to execute, and click OK.
If you do not see the pipeline you want in the Open dialog box, close the
dialog box and change the current library.
3 If you want to change the pipeline operation, select a new option from the
Options drop-down list in the workspace.
4 Modify the pipeline definition as needed.
5 Execute and/or save the pipeline.
Pipeline examples
Updating data in a
destination table
You might want to pipe data and then update the data often.
❖ To update a destination table:
1 Click the Pipeline button, select an existing pipeline that you executed
before, and click OK.
The pipeline definition displays. Since this pipeline has been executed
before, the table exists in the destination database.
2 Select the Update option in the pipeline definition.
3 Execute the pipeline.
The destination table is updated with current data from the source
database.