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