Extracting data from a database

One of the most common integration tasks is to take data from an application database and write it to a file where it might be processed by another system or converted to a report. In this first example, we'll take data from a single database table and export it to a delimited file.

If you're following the examples using the source code provided for this chapter, have a quick look at the tables provided. You'll see that there are two tables, products and brands. The tables are joined by a product ID that is present in both tables. For the first example, we will simply extract the data from the products table.

Perform the following steps:

1. Under Job Designs in the Repository window, create a new folder named Chapter4 and, within this, create a new job named DBExtract.

2. Expand the DEMO_DB metadata we created previously to show the Table schemas. Click on the products table and drag this onto the Job Designer. You will be presented with a window which shows lots...