topic Re: How to implement connection retries for tMSSqlConnection? in Talend Studio

How to implement connection retries for tMSSqlConnection?

rp2018 — Tue, 13 Nov 2018 16:28:11 GMT

Need to implement 10 retries when a job doesn't connect to the database using tMSSqlConnection component. How can I accomplish this?

Re: How to implement connection retries for tMSSqlConnection?

Anonymous — Tue, 13 Nov 2018 17:08:22 GMT

Hi,

You can catch the error when DB connection is not happening and do some looping to accomplish it theoretically.

But could you please advise why you are facing issue in getting connection to DB at first place?

Warm Regards,

Nikhil Thampi

Re: How to implement connection retries for tMSSqlConnection?

rp2018 — Tue, 13 Nov 2018 17:23:02 GMT

Sometime from Talend cloud it is not able to make connection to on premise database. Would you have sample job that does retries using tloop?

Re: How to implement connection retries for tMSSqlConnection?

Anonymous — Tue, 13 Nov 2018 17:30:58 GMT

Hmm... Could you please raise a service case for this issue?

Creating a loop is just trying to escape from the current situation. But it might eventually be a performance problem for you.

We need to detect whether the lag is due to Talend cloud component or due to network lag or something else when the cloud is trying to make connection to DB behind your firewall. I have not heard about this issue by other customers.

So my recommendation will be to raise a support ticket so that they can quickly analyse and fix it for you.

Warm Regards,

Nikhil Thampi

Re: How to implement connection retries for tMSSqlConnection?

rp2018 — Tue, 13 Nov 2018 21:33:27 GMT

Nikhil,

For the database connection issue, I'll open up a ticket with Talend Support, but I'm also having an issue with tRest component connecting to CRM sometime. I've opened up a ticket with Talend Support but they don't have any option for retries, etc... So, I was thinking about looping 10 times, if it doesn't connect for this scenario too. I'm very new with this product and not sure how I can implement this. A sample job will be very good help for me.

Re: How to implement connection retries for tMSSqlConnection?

Anonymous — Wed, 14 Nov 2018 05:52:39 GMT

Hi,

You can use tloop component for any looping related tasks.

Below is the link from Talend help document which contains the properties of the components and also sample job. Could you please check it?

https://help.talend.com/reader/mjoDghHoMPI0yuyZ83a13Q/iL2h45sTpz~InS1_0iOj5w

If the answer has helped you, could you please mark the topic as resolved? Kudos are also welcome 🙂

Warm Regards,

Nikhil Thampi