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

Database to database transfer

In a lot of the examples we have seen so far in the book, we have used files of different sorts to be the conduit for the data. Specifically, data is extracted to a file or imported from a file. However, it is perfectly possible for data to be passed directly from one system to another, which often means from one database to another. We will look at an example of this database-to-database transfer in this section. The job we will build will transfer data from our example database to a second database named DB2DB (there is a script to create the database and an associated table in the ResourceFiles folder of this chapter). The new database contains a table named order_data containing the following fields:

  • order_date ...

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