Chapter 4. Working with Databases
Databases, specifically relational databases, are at the heart of most modern applications and business systems and it is likely that anyone involved in integrating systems will need to interact with databases in some way.
In this chapter, we'll look at using the Studio to work with databases. We will learn about the following topics:
- Extracting data from a database table
- Joining data across database tables
- Writing data to a database table
- Synchronizing data between databases
- Modifying data in a database
- Dynamic database lookup in an integration job
The jobs we create in the chapter use a simple database which is in the Chapter 4 ResourceFiles folder for this chapter. Let's take a moment to look at the database and familiarize ...
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.
