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 the section called “Using database profiles” in Connecting to Your Database.