Changing the destination and source databases – PB Docs 150

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:

1. 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.

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:

1. 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.