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:
tLibraryLoadcomponent 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
tMySQLInputcomponent, 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