How to load data into MySQL database from an Excel File using Talend

0 votes

I am trying to import data from an excel file into my MySQL database. For that, I have successfully established the database connection but when I am trying to retrieve the schema of my table Talend is retrieving the schema of the default CATALOG database. Please suggest how can I retrieve the schema of the required table to carry out the further process.

Apr 18, 2018 in Talend by 93.lynn
• 1,550 points
685 views

1 answer to this question.

0 votes

I think the problem lies somewhere in the database selection. Can you once make sure, you have created the required table in the connected database?

If you don’t know how to do that, I am adding few snapshots of the steps. Make sure you properly follow them.

  1. Right-click on the database connection name

  2. Select Retrieve Schema

  3. Click on next
    imageimage

  4. Now select the required table from the connected databaseimage

  5. Click on nextimage

  6. You can change the table name and the schema from here. If not then click on Finish.
answered Apr 18, 2018 by code.reaper12
• 3,450 points

Related Questions In Talend

0 votes
1 answer
0 votes
1 answer

Using tHiveRow to execute multiple Hive queries in Talend

In order to execute multiple queries, you ...READ MORE

answered Apr 14, 2018 in Talend by misc.edu04
• 1,380 points
566 views
0 votes
1 answer
0 votes
2 answers
0 votes
1 answer

tWaitForFile component insufficiency in Talend

Regarding your first issue, tWaitForFile component provides ...READ MORE

answered Apr 10, 2018 in Talend by geek.erkami
• 2,320 points
218 views
0 votes
1 answer
0 votes
1 answer

Closed loop in Talend

As you might know,  in Talend all ...READ MORE

answered Apr 19, 2018 in Talend by code.reaper12
• 3,450 points
256 views
0 votes
1 answer

How to load a set of files into database using Talend

Using tFileList component,  you can read all the files present ...READ MORE

answered Apr 16, 2018 in Talend by code.reaper12
• 3,450 points
424 views
0 votes
1 answer

How to generate multiple rows from a single row in Talend?

I think using tJavaFlex, tMap and tFlowToIterate ...READ MORE

answered Apr 18, 2018 in Talend by code.reaper12
• 3,450 points
916 views