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