Skip to main content

Good evening,

I have consulted the documentation on OnPremise Celonis Extractor Server (https://docs.celonis.com/en/on-premise-extractors.html), but as far as I can see there is guidance only for SAP and servers with JDBC.

I would like to implement Celonis Extractor Server directly on a SQL Server without JDBC endpoints, is this possible?

Where can I find a guide or documentation?

Thanks

Hi @enrico.pugli12,

 

If your SQL Server database does not have JDBC implemented, it is not possible to extract is using a extractor server. Depending on what your connection possibilities are, you could use the following methods to extract the data:

  • If it has an API EndPoint, use the Extractor Builder to setup a connection
  • If it supports ODBC, write a Python script in the ML Workbench and use the PyCelonis package to insert data to your data pool
  • Enable JDBC connection in you SQL Server setup (:

 

Hope this helps!

 

Kind regards,

Jan-peter


Another question, even i the SQL database is a Azure PaaS instance we need the JDBC extractor?

 


Reply