Hi, We are facing issue in importing activity table from GCP to Celonis. Please note that the connection has been established between GCP & EMS & also able to add certain tables in CElonis. But for the activity table , getting below error as att

Thank you for reaching to us.

In order to be able to assist you further, we would suggest to send an email to servicedesk@celonis.com with detailed description.

We will gladly assist you.

Thank you in advance.

Best regards,

Hi Ashish,

Add the timeout of 3600 in the JDBC connection string to connect to GCP BQ, this solves my timeout issue.

Timeout=3600

Thanks

Muthappan

Already raised a request, pls assist at the earliest. Thanks

Thanks, Please let me know where do define it. A screenshot with exact details on connection string will work

Check this blog which has step by step on GCP connection and JDBC string with timeout parameter.

https://muthappan.medium.com/celonis-and-bigquery-integration-cf05647faf17

Thanks

Muthappan

Appreciate the prompt reply. However, please note that the connection typs is Direct & not Uplinked. So, in this case how to proceed , where to define the timeout parameter as in Celonis we can assign maximum value as 300seconds in advanced settings. Still, waiting for a reply with a hope to get this fixed. Thanks a ton!

Even with direct you can use custom JDBC connection string. How are you configuring your connection?

Please find atatched the images, it describes the direct connection made. Please assist how to increase & where to define the additional timeout parameter in this tyoe of set up. Thanks

Have added 2 images for reference, it describes the direct connection made. Please assist how to increase & where to define the additional timeout parameter in this tyoe of set up. Thanks