O'Reilly logo

Getting Started with Talend Open Studio for Data Integration by Jonathan Bowen

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required