Defining a data pipeline
When you use the Data Pipeline painter to create a pipeline, you
define the:
-
Source database
-
Destination database
-
Source of data
-
Pipeline operation
-
Destination table
After you create a pipeline, you can execute it immediately. If
you want, you can also save it as a named object to use and reuse.
Saving a pipeline enables you to pipe the data that might have changed
since the last pipeline execution or to pipe the data to other
databases later.
Datatype support
Each DBMS supports certain datatypes. When you pipe data from
one DBMS to another, PowerBuilder makes a best guess at the
appropriate destination datatypes. You can correct PowerBuilder’s best
guess in your pipeline definition as needed.
The Data Pipeline painter supports the piping of columns of any
datatype, including columns with blob data. For information about
piping a column that has a blob datatype, see Piping blob data.