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.
Each DBMS supports certain datatypes. When you pipe data from one DBMS to another, InfoMaker makes a best guess at the appropriate destination datatypes. You can correct InfoMaker'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”.
