Hi there,

I want to be able to bring data from an on premise Oracle database into external objects within a Salesforce Org.

Can the OData connectors be used to connect to an on premise Oracle database?
If not, is there a type of connector that will allow me to connect to an on premise Oracle database or will I have to write an Apex solution or use Heroku?

Any help appreciated. I understand the concept of using external objects, its just determini g the best way to connect to the Oracle database.

Many thanks

Jon