KNIME Server Oracle DB Connection

[KKERROXXX]

Hi everyone,

I have a workflow containing Oracle DB Connector. I wonder that if I deploy this workflow to server, what can i do to run this workflow on knime server?

To sum up, Is there any needed configuration for oracle db connection for knime server?

Thanks,

Kerem,

[ipazin]

Hello @KKERROXXX,

check out this topic:

ORACLE DRIVER ON KNIME SERVER

Hi All, I am using the oracle database on Knime desktop version by adding the driver name in preferences, But now I want to use the Oracle database from Knime server for which we have installed the driver on Server. Now What all other steps do i need to perform in order to run the DB component from Web portal? Also If i need to run any workflow from Linux then what is the exact command for it with arguments??

Br,
Ivan

[KKERROXXX]

Hi @ipazin,

Thanks for the response. I have done the steps shown the below ss

Then, I run my workflow again, knime server throws and error Could not find the [Oracle] database driver.

Is there any other step I forgot?

One more question, do I need to restart the knime server after completing the necessary steps? If yes, how can i do that?

Thanks,

Best,

[ana_ved]

Hi @KKERROXXX

Have you added the information about the profile location in the executor’s knime.ini? Like we explain on the client-side setup part of the documentation.

Are you using linux/windows server? If linux, and you have the server and executor installed as services, you can do systemctl restart knime-server and then systemctl restart knime-executor to restart the services. If on windows, you can just go to the services view and restart the Apache service and executor service.

Best wishes
Ana