Specifications

Users Guide 121
CHAPTER 4
Working with Data Pipelines
About this chapter
This chapter describes how to use the Data Pipeline painter to create data
pipelines, which let you reproduce database data in various ways.
Contents
About data pipelines
The Data Pipeline painter gives you the ability to reproduce data quickly
within a database, across databases, or even across DBMSs. To do that,
you create a data pipeline which, when executed, pipes the data as
specified in the definition of the data pipeline.
What you can do
With the Data Pipeline painter, you can perform some tasks that would
otherwise be very time consuming. For example, you can:
• Pipe data (and extended attributes) from one or more tables to a table
in the same DBMS or a different DBMS
• Pipe an entire database, a table at a time, to another DBMS (and if
needed, pipe the database’s extended attribute system tables)
• Create a table with the same design as an existing table but with no
data
• Pipe corporate data from a database server to a SQL Anywhere
database on your computer so you can work on the data and report on
it without needing access to the network
Topic Page
About data pipelines 121
Creating a data pipeline 124
Modifying the data pipeline definition 127
Correcting pipeline errors 137
Saving a pipeline 138
Using an existing pipeline 139
Pipeline examples 139