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 ourselves with the data it contains.
There are four tables in the database: products, brands, orders, and order lines. The entity relationship diagram in the next screenshot shows the connections between the tables:
As we go through this chapter...
