Using extractor or directly from Celonis cloud ?

Some ideas:

• Firewalls or similar between you and the SQLserver ?
• The SQL server has ACLs to allow connection only from some IP's ?

Thanks for the response, Guillermo.

Below are the steps I followed:

1. Login to Celonis EMS environment.
2. Go to Data Integration.
3. Create a Data Pool and open it.
4. Select "Connect to Data Source".
5. On the Add Data Connection pop-up window, select "Connect to Data Source".
6. Select categories Cloud and select Database.
7. On the New Database Data Connection window, provide
   1. Name
   2. Database Type: Microsoft SQL Server (native)
   3. Provide other details such as host, port, username, and password.
   4. Test Connection
8. At step 7, when I test the connection, it throws the error that I mentioned in the post. I have tried checking all Windows Firewall settings and enabling all other settings.

Ok, that's a direct connection from the Celonis Cloud. So, from the Internet to your internal servers - your SQL Server.

The most likely explanation is that your SQL server is not reachable from Internet, specifically from Celonis Cloud IP's.

BTW... you said you tested Telnet and Beaver... from which machine/server? Because if it was from your laptop... well it doesn't mean anything as your laptop probably will sit in the internal network and can reach the SQL Server.

HTH

Thanks for bringing up this internal / same-machine test criterion.

Yes, I was doing all stuff using one machine.

But then, Today I installed DBeaver on another separate machine and tried the same test (providing port, host, and other details).

The connection test passed although the time to connect was higher.

Could it be something else or any workaround to get it connected using Celonis?