how to expose sql data as an api using apigee ?

[#1]

could you please let me know how can I expose my sql data as an api using apigee (is there an exmaple as i could not find one) ?

also can I develop an appication using c# and asp.net then publish it on apigee or does the coding has to be done using node js ?

thank you for your help.

[williamspaul-1]

Generally speaking, Apigee is a wrapper around a service that provides data, not a framework for publishing services. The typical pattern would be that you would create your service in C# or .NET and deploy to an internal server that only accepts connections from Apigee. Your Apigee proxy would be used to apply common security and monitoring to that and other services.

Node.js is the exception -- you can deploy a service using NodeJS as a target, and any interactions (including database queries) that are supported by the Apigee NodeJS runtime are fair game, so long as the Apigee processor has network access to your SQL server.

[#3]

Can I use sql to improve website's performance like, for example here , or is that only for Java and SSL?

[itravindrasingh]

Hi @Salam Al-hakami,

As @Paul Williams stated, APIGEE is a wrapper for your backend API.

The backend you can choose on which techstack you are comfortable with. I take an examople of NodeJS based service you as you mentioned that you want to use c# with asp.net. you are free to use it on your backend its completly independent of APIGEE. APIGEE will just proxy your backend API.

You can take a ref for asp.net apis - https://dotnet.microsoft.com/apps/aspnet/apis

Also, I would suggest understanding the fundamental of APIGEE. so go here - https://docs.apigee.com/api-platform/get-started/what-apigee-edge