topic Re: Time lag while connecting from Talend-SalesForce using tSalesForceConnection component in Talend Studio

Time lag while connecting from Talend-SalesForce using tSalesForceConnection component

ManadaUser — Sat, 16 Nov 2024 01:07:22 GMT

I am trying to connect to SalesForce using SalesForce connector in Talend. Now when I send the connection request, I can see that the connection is established after ~2 seconds and as soon as the connection is established to SalesForce url, the response is in milliseconds. I am using tSalesForceConnection to establish the connection to SalesForce from Talend but there is a time lag in that process.

I am using oAuth2 authentication type to authenticate with SalesForce server.

An example using tsttatcacter logs we see between begin and end it is taking ~2 seconds.

2020-10-22 13:52:38|CgqWpf|CgqWpf|CgqWpf|16220|sample|samplelog|_PF7PIBPKEeuGlI4APhARAg|0.1|Default||begin||

2020-10-22 13:52:38|CgqWpf|CgqWpf|CgqWpf|16220|sample|samplelog|_PF7PIBPKEeuGlI4APhARAg|0.1|Default|tSalesforceConnection_2|begin||

1515 milliseconds

2020-10-22 13:52:39|CgqWpf|CgqWpf|CgqWpf|16220|sample|samplelog|_PF7PIBPKEeuGlI4APhARAg|0.1|Default||end|success|1515

Note: The above time example is just from a very BASIC job that only uses this component to connect to SalesForce. We are not performing any CRUD operations in the above job and despite that the lag persists.

Does anyone have any idea why is there a time lag in establishing connection via Talend using tSalesForceConnection component and if there are ways to improve it? This is a problem because there are some jobs that require a round trip to SalesForce and everytime this lag occurs during connection, the time increases which leads to longer waiting time. Sometimes we have to wait 20-25 seconds for a job to complete that has round trips to SalesForce.

Please assist in this matter.

Thanks

Re: Time lag while connecting from Talend-SalesForce using tSalesForceConnection component

Anonymous — Tue, 17 Nov 2020 08:56:30 GMT

Hello,

What's the issue are you getting? There is regularly a connection time lag. Are you making a new connection for each task? It would be better if you could post your job design screenshots here.

Best regards

Sabrina

Re: Time lag while connecting from Talend-SalesForce using tSalesForceConnection component

ManadaUser — Tue, 17 Nov 2020 09:46:26 GMT

The issue is that during the connection, it takes on an average ~1.5-2 seconds for the connection/authentication to SalesForce and since there are some operations that require multiple SalesForce calls, this connection lag causes a lot of time gap from start to end to complete the entire process. I am showing you the job that is only calling SalesForce once and in this case the entire process is taking ~5-6 seconds in which the connection lag is 2 seconds. Please check it and provide your input on this. I am using oAuth-2 authentication to connect to SalesForce: