Specifications

Modifying the data pipeline definition
136 InfoMaker
Executing a pipeline
with blob columns
After you have completed the pipeline definition by adding one or more blob
columns, you can execute the pipeline. When you do, rows are piped a block
at a time, depending on the Commit value. For a given block, Row 1 is inserted,
then Row 1 is updated with Blob 1, then Row 1 is updated with Blob 2, and so
on. Then Row 2 is inserted, and so on until the block is complete.
If a row is not successfully piped, the blob is not piped. Blob errors display, but
the blob itself does not display. When you correct a row and execute the
pipeline, the pipeline pipes the blob.
Changing the destination and source databases
Changing the
destination
When you create a pipeline, you can change the destination database. If you
want to pipe the same data to more than one destination, you can change the
destination database again and re-execute.
❖ To change the destination database:
• Click the Destination button in the PainterBar, or select File>Destination
Connect from the menu bar.
Changing the source
Normally you would not change the source database, because your pipeline
definition is dependent on it, but if you need to (perhaps because you are no
longer connected to that source), you can.
❖ To change the source database:
• Select File>Source Connect from the menu bar.
Source changes when active profile changes
When you open a pipeline in the Data Pipeline painter, the source database
becomes the active connection. If you change the active connection in the
Database painter when the Data Pipeline painter is open, the source database in
the Data Pipeline painter changes to the new active connection automatically.
Working with
database profiles
At any time in the Data Pipeline painter, you can edit an existing database
profile or create a new one.
❖ To edit or create a database profile:
• Click the Database Profile button in the PainterBar and then click the Edit
button or the New button.
For information about how to edit or define a database profile, see
Connecting to Your Database.