I've been scratching my head trying to figure out how to connect to a different instance (connection) in MySQL and any search/help was fruitless.
I have several Connections in MySQL, several internal and some external. Instead of recreating these connection in Talend I want to be able to connect directly to a particular connection. As an example I have
Local instance MySQL57
BSD (This is an external database)
SDB (This is another internal database)
I want to setup a metadata connection for BSD. How can I do that?
I am trying to overcome a basic issue with the tmysqlconnection component. It gives me an error (Connection failure. You must change the Database Settings. java.lang.RuntimeException: java.sql.SQLException: Access denied for user 'xyz'@'IP Address here' (using password: YES)) when I try setup the connection directly in Talend however I'm still able to connect using MySQL connection and query the database tables. I have tried many different ways to get this working but none of them have worked so far and I'm reluctant to go back to the external company to ask them to make a change that might cause a security issue due to the sensitive nature of the data.
Access denied for user 'xyz'@'IP Address here' (using password: YES))
without pictures - we can only guess what are You make wrong
it common error - I do all same, but have error only there!!!
in fact it mean - something difference in settings. Compare Your MySQL client (as I can guess MySQL Workbench) and Talend settings
as example - MySQL Workbench could connect over ssh tunnel ...
I just can confirm - it work!
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Part 2 of a series on Context Variables
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema