Exporting and importing data to a MySQL database

As you can imagine, exporting data using Sqoop will be pretty easy with Talend, so easy that it will require only the following components:

  • A tLibraryLoad component to load our database library JAR file. Some components in Talend Palette are dedicated to a specific database, so when you use them in a job, all the required drivers are loaded without the need of thinking about it. For example, if I want to read a table in MySQL, I'll use the tMySQLInput component, which loads the MySQL JAR driver.

    Here, with Sqoop, as it's a generic component, we don't know in advance what kind of database we want to work with; that's why we have to manually load the JAR file with the tLibraryLoad component.

  • A tSqoopExport ...

Get Talend for Big Data now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.