O'Reilly logo

Talend Open Studio Cookbook by Rick Barton

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 7. Working with Databases

This chapter contains recipes that show some of the techniques used to read and write data to databases. It also contains recipes that show techniques to manage tables within a database. In this chapter we will learn:

  • Setting up a database connection
  • Importing the table schemas
  • Reading from database tables
  • Using context and globalMap variables in SQL queries
  • Printing your input query
  • Writing to a database table
  • Printing your output query
  • Managing database sessions
  • Passing a session to a child job
  • Selecting different fields for insert, update, and delete
  • Capturing individual rejects and errors
  • Database and table management
  • Managing surrogate keys for parent and child tables
  • Rewritable lookups using an in-process database

Introduction ...

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