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,620 points
1,513 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,470 points

Related Questions In Talend

0 votes
1 answer

How to loading flat file from configuration in Talend?

Hey, @There, Regarding your query you need to ...READ MORE

answered Jun 3 in Talend by Gitika
• 37,940 points
107 views
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,430 points
1,506 views
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,680 points
731 views
0 votes
1 answer
0 votes
2 answers

Closed loop in Talend

Hi, Talend specifies that tUnite cannot be ...READ MORE

answered Aug 22, 2019 in Talend by vinceall
713 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,470 points
1,709 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,470 points
3,097 views