user56690 user56690 - 2 months ago 21
Node.js Question

Connect to Database from Apigee

Can anyone let me know if it is possible to connect to a Microsoft database from Apigee oncloud? We have a requirement to perform get and post operations from the database.

I tried to search it on internet, but did not get any information.
Thanks in advance


It depends on your license, since you might be able to use Java for this, but this requires a Developer license:

My best bet would be to add a thin API layer on top of your database for the CRUD operations. Probably a good idea as well to decrease the latency as much as possible or perform an async operation (if possible) towards the database API. From an architectural point of view the MSSQL database should be 'close' to your backend systems, while your API should be pointing 'outside'. Ensure to secure the connection between your Apigee layer and your Database API layer (firewall, SSL).

Hope this helps.