Integrate oracle with Apigee

[sunnyhari007]

Hi,

we are planning on using APIGEE and want to understand how we can integrate ORacle DB with APIGEE.

1) are there any connectors that needs to be installed?

2) do we have to install SOA and enable REST to integrate with APIGEE?

Sorry if this question has been already answered. Really appreciate any help on this.

THanks in advance.

[#2]

There is nothing like to directly integrate db from Apigee.

If you have any api to do db operations then it's fine.

Else you by need to use java callout to connect to db.

[sunnyhari007]

Thanks for your response.

We do have oracle API`s to do DB operations, but how do i generate API spec so that i can import in APIGEE ?

[#4]

If you have the api, then the spec is same as other proxies. Just create openapi document using the Oracle api as backend. CRUD operations can be done using POST, GET, PUT, DELETE operations over api.

[sunnyhari007]

We are using APIGEE for the first time, so we dont have any proxies created and new to API integration

[#6]

Then, login Apigee-> create api proxy -> select reverse proxy -> give the proxy name and base path you want -> give the Oracle db api url as the target url -> then click next till the end -> then deploy the revision of proxy and you will get a new url for proxy. Use that to call db api.

[sunnyhari007]

Thank you, let me try these steps