Error while connecting MySQL to Talend

Highlighted
Five Stars

Error while connecting MySQL to Talend

Hello guys,

 

I am trying to establish a connection from Talend to MySQL. Could someone tell me the steps to do the same?

 

I downloaded the MySQL 5 Java connector and saved it in C drive. Post that, I used the DB Connections under Metadata to setup my connection! It asks me for login/password/server and I used 127.0.0.1 as the server path. Do I create the login/password there itself or do I need an existing MySQL login/password to establish the connection. If yes, how do I go about doing that?

 

Sorry for my naivety. Pretty new to this thing!

 

This is the error I get!


Accepted Solutions
Forteen Stars

Re: Error while connecting MySQL to Talend

You can download installer and follow instructions

but this is only top of iceberg Smiley Happy 

 

version of mysql - depend from what You need it?

why You create this Job?

 

You are developer of application - You must know all answer already

You are prepare ETL for somebody applications (warehouse or etc) - You must have same version as Your target system

 

I can not teach You to be a DBA or Database developer here

-----------

View solution in original post


All Replies
Forteen Stars

Re: Error while connecting MySQL to Talend

error mean - You do not have installed MySQL Server (no nay relation for MySQL Connect) installed on Your local machine

 

Yes, You need already have name and password - You will setup them when will install MySQL server software

-----------
Five Stars

Re: Error while connecting MySQL to Talend

Thanks for the reply, @vapukov. Would you be able to advise me which version of MySQL would I require for Talend 7.0.?

 

Of all the links here: https://dev.mysql.com/downloads/windows/  - what should I download?

 

Thank you so much for helping me out!

Forteen Stars

Re: Error while connecting MySQL to Talend

You can download installer and follow instructions

but this is only top of iceberg Smiley Happy 

 

version of mysql - depend from what You need it?

why You create this Job?

 

You are developer of application - You must know all answer already

You are prepare ETL for somebody applications (warehouse or etc) - You must have same version as Your target system

 

I can not teach You to be a DBA or Database developer here

-----------

View solution in original post

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 2

Part 2 of a series on Context Variables

Blog

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Best Practices for Using Context Variables with Talend – Part 3

Read about some useful Context Variable ideas

Blog