Skip to main content
Question

Can we Install Celonis Extractor in same machine as of Data source ?

  • July 22, 2021
  • 9 replies
  • 16 views

We have installed Celonis extractor in a virtual machine where Oracle database is already placed. We are experiencing a error in connection now. I would like to know whether if we can place extractor in same machine as that of Data source and have jdbc connection.

9 replies

joos.buijs
Level 10
Forum|alt.badge.img+2
  • Level 10
  • July 23, 2021

Interesting question, as this is something we might encounter as well when we move to EMS.

 

Did you check whether the database accepts local connections? And providing the exact error details might help others in finding a solution for you :)


Interesting question, as this is something we might encounter as well when we move to EMS.

 

Did you check whether the database accepts local connections? And providing the exact error details might help others in finding a solution for you :)

Yes. Database is accepting local connections. But we are facing an error as below.

 

Cannot load JDBC driver class 'oracle.jdbc.OracleDriver'

 

We have performed all steps which is provided in Celonis help page. But when we are trying to connect to database from IBC, its showing error as above.


janpeter.van.d
Level 12
Forum|alt.badge.img+26

Hi Gaurav,

 

This should be possible, we have one of our connectors installed which has a localhost connection with the databoase.

 

It looks like the driver for the database cannot be found. You could do two things:

  • Test if the database is accessible using on the local machine using a data base tool, like DBeaver. If it is accessble without installing drivers, the driver is probably set up correctly.
  • If the driver isn't or can't be installed, you could always specify it explicitly in you extractor installation. Please refer to the Celonis help documentation at: https://help.celonis.cloud/help/x/AoUeAg .

Forum|alt.badge.img

Hello Gaurav.

Just adding some options here.

Check your java versions as well.

I used to get different errors when not using JDK11 from https://adoptopenjdk.net/

Tks. Dan.


janpeter.van.d
Level 12
Forum|alt.badge.img+26

Good addition Daniel, for the full list of requirements, please see https://help.celonis.cloud/help/x/3YVRAQ.


Hello Gaurav.

Just adding some options here.

Check your java versions as well.

I used to get different errors when not using JDK11 from https://adoptopenjdk.net/

Tks. Dan.

We are using Linux for extractor and database connection. All the prerequisites are as per the requirement given in Celonis Help Portal. Still we are facing the error.


janpeter.van.d
Level 12
Forum|alt.badge.img+26

We are using Linux for extractor and database connection. All the prerequisites are as per the requirement given in Celonis Help Portal. Still we are facing the error.

Unfortunately, I don't have experience with the Linux extractor. Hope that someone else can help you with this!


  • Author
  • Level 2
  • January 10, 2022

Thanks all for your Help. I was able to solve the issue.


  • May 18, 2022

Thanks all for your Help. I was able to solve the issue.

Hi, I'm having same issue, how did you solve it? Thank you in advance