How to connect to oracle db and execute stored procedure from Apigee proxy

[ilavarasanmuthi]

How to connect to oracle db and execute stored procedure from Apigee proxy? How to configure Oracle connection parameters?

[deniska]

It can be achieved with extension policy (mainly, java or node.js):

https://github.com/apigee/trireme-jdbc

See example for oracle:

var jdbc = require('trireme-jdbc');

var db = new jdbc.Database({
  url: 'jdbc:oracle:thin:@//oraclehostname:1521/ORCL',
  properties: {
    user: 'scott',
    password: 'tiger',
  },
  minConnections: 1,
  maxConnections: 20,
  idleTimeout: 60
});

Also read this: https://community.apigee.com/answers/54896/view.html

I personally can recommend you to move the JDBC logic to some middleware and focus with Apigee on API Management

[ilavarasanmuthi]

@Denis Kalitviansky Can you please elaborate the configuration steps in details? i don't have java and node.js knowledge. How to get the jdbc driver?

[dchiesa1]

OK if you don't know Java or nodejs, then you should follow Denis' recommendation: use some other middleware between Apigee and Oracle.

Apigee is a smart, configurable reverse HTTP Proxy. That means it can receive inbound HTTP requests and send outbound HTTP Requests. To connect Apigee to Oracle DB, the best way is via HTTP.

Here are some concrete suggestions on how to do that.

https://www.google.com/search?q=oracle+db+http+listener