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.
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.
