Specifications

About data pipelines
122 InfoMaker
• Upload local data that changes daily to a corporate database
• Create a new table when a change (such as allowing or disallowing
NULLs
or changing primary key or index assignments) is disallowed in the
Database painter
Source and
destination databases
You can use the Data Pipeline painter to pipe data from one or more tables in a
source database to one table in a destination database.
You can pipe all data or selected data in one or more tables. For example, you
can pipe a few columns of data from one table or data selected from a
multitable join. You can also pipe from a view or a stored procedure result set
to a table.
When you pipe data, the data in the source database remains in the source
database and is reproduced in a new or existing table in the destination
database.
Although the source and destination can be the same database, they are usually
different ones, and they can even have different DBMSs. For example, you can
pipe data from an Adaptive Server Enterprise database to a SQL Anywhere
database on your computer.
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, InfoMaker makes a best guess at the appropriate destination
datatypes. You can correct InfoMaker’s best guess in your pipeline definition
as needed.