topic Re: How to use multiple tmysqlconnection to JOBs in Talend Studio

How to use multiple tmysqlconnection to JOBs

DM2017 — Thu, 28 Dec 2017 09:00:04 GMT

I have a job where I use one tmysqlconnection for source and different connection for target.

source_table(local db table)--------->tfilterrow---------->target_table( other db server table)

How do I manage my connection in this scenario. Without hard coding the target table db connection , how do provide a tmysqlconnection

Re: How to use multiple tmysqlconnection to JOBs

TRF — Thu, 28 Dec 2017 09:32:46 GMT

Hi,

You may have as many tMyssqlConnection components as you need.

So, 1 for the input table (as you have now) and an other for the target table.

However, tMyssqlConnection make sense in 2 cases:

- you have more than 1 component connected to the same db with the same account

- you want to open all the connections when the job starts to be sure everything is ok with that connections before to continue with the process

So, for a simple design as in your example, it is not mandatory to use tMyssqlConnection component (even in my opinion this is a good practice).

Hope this helps.

Re: How to use multiple tmysqlconnection to JOBs

DM2017 — Thu, 28 Dec 2017 11:12:03 GMT

Thanks. But I have 10 tables to load from local to target. I use a single connection for all 10 tables. I need same thing for all target tables too. that's where the problem is! I dont want to hard code on each table for the conn details. can I just create a conn for target? but this is not happening as the target table is output.

Re: How to use multiple tmysqlconnection to JOBs

TRF — Thu, 28 Dec 2017 11:29:08 GMT

Don't really understand your last sentence.

Doesn't matter, definitively you can reuse the same connection for any tMysqlOutput component as soon as you don't use them at the same time (in parallel).

Re: How to use multiple tmysqlconnection to JOBs

DM2017 — Thu, 28 Dec 2017 13:36:15 GMT

Basically, when I am trying to provide a connection string to the tmysqloutput ( right click on tmysqlconnection > trigger > on component ok) this step not happening in designer view , not able to point.

Re: How to use multiple tmysqlconnection to JOBs

TRF — Thu, 28 Dec 2017 13:48:15 GMT

You don't have to connect both components. In tMysqlOutpout, just tick the option "use an existing connection" then select the appropriate one in the list.