topic FROM MySQL DATABASE to POSTGRES DATABASE - POSTGRES using an existing connection doesn't work in Talend Studio

FROM MySQL DATABASE to POSTGRES DATABASE - POSTGRES using an existing connection doesn't work

Anonymous — Tue, 09 Oct 2018 10:17:00 GMT

Hello folks,

I want to read a table from MySQL and write to PostgreSQL. Setup 1 works fine. But Iwant to use the tDBConnection in Setup 2 and this doesn't work. Can please someone help? NO ERROR or WARNING

in Setup 1 I can see in DataGrip the table and in Setup 2 it doesn't appear.

Setup 1:

Use:

tDBInput MySQL -- Row (Main) -- tDBInput PostgreSQL

Explanation:

works fine. Use Repository for both.

Setup 2 (same Database):

Use:

tDBConnection MySQL -- Trigger (On Component OK) -- tDBConnection PostgreSQL -- tDBInput MySQL -- Row (Main) -- tDBOutput PostgreSQL -- Trigger (On Component OK) -- tDBClose PostgreSQL -- Trigger (On Component OK) -- tDBClose MySQL

WORKS NOT

Explanation:

tdBConnection MySQL |- Repository (Connection successful)

tdBConnection PostgreSQL |- Repository (Connection successful)

tDBInput MySQL |- Use existing connection

tDBOutput PostgreSQL |- Use existing connection; give table a name; Drop table if exists and create; Action on data Insert; Sync columns ...

-- DOESN'T WORK BUT NO ERROR NO WARNING

Job XXX ended at 10:28 09/10/2018. [exit code=0]

Need Help PLEASE

Re: FROM MySQL DATABASE to POSTGRES DATABASE - POSTGRES using an existing connection doesn't work

Anonymous — Thu, 11 Oct 2018 05:29:50 GMT

Hi,

Could you please share a screen shot of your job for better clarity of your issue?

One quick thing I could recommend is to use OnSubJob Ok rather than On Component Ok in your flow. But a screen shot will help us to understand your job flow better.

Warm Regards,

Nikhil Thampi

Re: FROM MySQL DATABASE to POSTGRES DATABASE - POSTGRES using an existing connection doesn't work

Anonymous — Tue, 16 Oct 2018 11:48:21 GMT

Hello,

thank you for response. I tried with OnSubJob Ok. But was not successful. It works with MySQL fine but not with Postgres.

Übersicht - Kopie.jpg

Re: FROM MySQL DATABASE to POSTGRES DATABASE - POSTGRES using an existing connection doesn't work

Anonymous — Tue, 16 Oct 2018 12:18:23 GMT

Hi,

Thanks for the detailed screenshot. I couldn't follow the description written in the screenshot but I believe you are trying to explain the issue.

Could you please change your job like below and let me know whether it is working? I would recommend to use tSubJobOk instead of tComponentOk for your use case.

If my answer has helped to resolve the issue, could you please mark the topic as resolved and closed? Kudos are also welcome 🙂

One last note is that you can easily attach your screenshots to Talend forum by using the camera icon shown above.

Warm Regards,

Nikhil Thampi

Re: FROM MySQL DATABASE to POSTGRES DATABASE - POSTGRES using an existing connection doesn't work

Anonymous — Wed, 17 Oct 2018 10:44:21 GMT

Hi,

Problem is solved. Thank you!