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,600 points
2,938 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.

Hope this will help!

Join the Talend course today to know more about and become expert.

Thanks.

answered Apr 18, 2018 by code.reaper12
• 3,500 points

Related Questions In Talend

0 votes
0 answers

How can I use talend to extract data from Oracle and import the data into a MSSQL database?

We currently have around 100 Oracle tables ...READ MORE

Nov 4, 2020 in Talend by umesh
• 150 points
2,157 views
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 4, 2020 in Talend by Gitika
• 65,910 points
1,756 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 11, 2018 in Talend by geek.erkami
• 2,680 points
2,148 views
+1 vote
1 answer
0 votes
2 answers

Closed loop in Talend

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

answered Aug 23, 2019 in Talend by vinceall
1,867 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 17, 2018 in Talend by code.reaper12
• 3,500 points
5,668 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,500 points
7,252 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP