Oracle database connector or default database connector
Hi there, I need to connect to an external Oracle database. I’ve seen there is the “Database Connector” module in the App Store, but I see there is an “Oracle Database Connector” module as well. Unfortunately, the latter hasn’t been touched in some years and is still in Beta phase... Question I have, can I also use the normal “Database Connector” to handle an external Oracle database connection?
Yes, you can connect to an Oracle DB using jdbc. You might need to put the correct jdbc driver in the userlib folder to be able to connect. Within the database connector activity, you are able to provide the jdbc Url including the service name and user / password using variables.