I am not sure how I can connect my Oracle EBS remote database through ODBC driver. From which ODBC driver we can connect my Oracle EBS remote database? Also, what configuration does it need?
I tried to use Oracle Instant Client ODBC driver, but It is not working.
Oracle EBS is configured by default with IP restrictions - this means that only "trusted nodes" are allowed to connect to the DB (these are listed in tusted.conf).
You can add Admin nodes via an autoconfig variable. See the EBS Security Guide (Protecting Administrative Pages) and the Autoconfig documentation (Document 387859.1, Using AutoConfig to Manage System Configurations with Oracle Applications Release 12) for more information on how to do this. If this is a production instance, your organization should have strict controls on who can be trusted.