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:
- Under Job Designs in the Repository window, create a new folder named
Chapter4 ...
Get Getting Started with Talend Open Studio for Data Integration now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
