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.

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 .

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.

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

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!

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