Want to connect locally installed SQL express to Data Model

Hi @archit.agraw,

what do you mean by connect under data model? Would be great to have some further details?

I would recommend checking whether you can build up a jdbc connection. This is well documented in the help space. Simply search for jdbc connection.

If you require further support, just let me know!

Best,

Justin

Hi @archit.agraw,

As far as I know, this is not possible. Data within Celonis can only be accessed using the Pyhon package 'PyCelonis', where it will be stored as Python dataframes. Even then you have to do some work-arounds, since you can only load data from data models.

Kind regards,

Jan-peter

Hi @archit.agraw 

If your target is to import data into EMS from MS sql server, I will try to set a connection database with jdbc, if you can connect o your mssql server with jdbc, I think it should also work in EMS

Hope it works

Javier

Didn't get the question I suppose, I assumed that you wanted to extract data using a local SQL editor. Please refer to the other anwers if you're looking to upload data.

Hi @janpeter.van.d ,

I am trying to establish new data connection using database option. This will help me to import data from my locally installed SQL express.

Hi @justin.stegm ,

I am trying to establish new data connection using database option. This will help me to import data from my locally installed SQL express. I have tried using JDBC connection but again it's giving me the same error. PFB screenshot for your reference.

Hi @javier.donos ,

I have tired JDB connection as well but it doesn't work.

hi @archit.agraw , have you tried with the port 52188? sometimes is used with sql express instead of the standard 1433

@javier.donos , have configured 55184 as my TCP Dynamic ports but surprisingly in Celonis I got the message that it's not able to connect on port 1433, am I missing something ? FYI I am using training cloud instance for this configuration, does it make any difference ?

Hi @archit.agraw , have you tried to connect to your sql express with jdbc outside celonis?

Hi @archit.agraw, how did it end your case, did you achieved to connect?

@javier.donos : SQL was not resetting TCP port and was continuously using TCP Dynamic port for connection. Had to install another instance of SQL and now it's allowing to set TCP port. In Celonis, still getting the same error.

Will give this a try

Hi Archit, it should be possible with a JDBC connection have you checked the message from the error and checked the firewall + permissions?

If you did and are still receiving an error then please contact our ServiceDesk to help you with the setup.

Best

Kevin

There is also a troubleshooting page for JDBC which might be helpful in your case. https://[team].[cluster].celonis.cloud/help/display/CIBC/Troubleshooting+JDBC+Data+Connections

@kevin.flesc  Thanks for helping with troubleshooting steps, I can see telnet session is working on my Celonis training cloud. However when I perform "telnet MyIP_Address\\MY_SQL_InstaceName 1433" it fails to connect on port 1433. But when I perform "telnet MyIP_Address 1433" it's opening telnet session for me.

Can you please help how can I reach to ServiceDesk for this issue ? FYI I am using training Celonis cloud which was allocated to me as a part of my training.

Hi @Archit,

It is very good possible that the extraction options are limited on the training cluster (it is on the demo environment). Maybe one of the Celonis employees that are involved in this thread can confirm that?

Kind regards,

Jan-peter

@janpeter.van.d  this could be the reason. @kevin.flesc is it the case here ?