Getting Timeout expired while connecting SQL Server to Anaplan using Talend

[jaya1]

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.

[Anonymous]

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