I’m new to Knime and was wondering where I could find documentation for creating db connections to Oracle (as well as Hadoop). I’m also trying to find out if Knime supports in-database processing. What functionality is available without the server?
Let me begin with your last question. Everything that you’re asking about so far is available in KNIME Analytics Platform - a server license isn’t required.
For connecting to Oracle specifically, you have a few options. You could use the Database Connector node as described here: oracle connection. You can also try out the Oracle Connector (Labs) node in the KNIME Database (Preview) extension. Both methods will require registering an Oracle JDBC driver.