Getting Timeout expired while connecting SQL Server to Anaplan using Talend

jaya1 — Fri, 15 Nov 2024 21:16:54 GMT

System.Data.SqlClient.SqlException (0x80131904): Connection Timeout Expired. The timeout period elapsed while attempting to consume the pre-login handshake acknowledgment. This could be because the pre-login handshake failed or the server was unable to respond back in time. The duration spent while attempting to connect to this server was [Pre-Login] initialization=26; handshake=67979;

System.ComponentModel.Win32Exception (0x80004005): The wait operation timed out.

Re: Getting Timeout expired while connecting SQL Server to Anaplan using Talend

Anonymous — Mon, 06 Nov 2023 04:46:06 GMT

Hello,

How did you parameter an Db Connection while connecting SQL Server to Anaplan using Talend?

As far as we known that you are able to implement the usage of Anaplan Connect api via java library calls in Talend, with authentication by certificate.

For example:

java -classpath "{path_to_library}/anaplan-connect-1.x.x-jar-with-dependencies.jar" com.anaplan.client.Program -k %certificates/Keystore.jks% -ka %KeystoreAlias% -kp %KeystorePassword% -workspace %WorkspaceId% -model %ModelId% %Operation%

And talend tSystem component you can use to execute a command or script file.

Best regards

Sabrina

topic Re: Getting Timeout expired while connecting SQL Server to Anaplan using Talend in Talend Studio

Getting Timeout expired while connecting SQL Server to Anaplan using Talend

Re: Getting Timeout expired while connecting SQL Server to Anaplan using Talend