Create proxy to SQL Server?

[#1]

Hi everyone !!

I need to do Proxy that exec store procedures or querys in rest services. some Examples said that it is possible with Volos connector or npm module but i dont know what is the better form or if it is posible.

Some example for this ???

Thanks !!!

Regards.

[dchiesa1]

Yes, it is possible, you should use the Hosted Targets option.

Basically you will build a nodejs server app that queries SQL Server. Then you'll wrap that (via a Hosted Target) into an API Proxy and import it and have Apigee host it for you.

I have succeeded doing this with a nodejs module called "seriate". Enclosed is a toy app that worked for me.

mssql-bridge.zip

Ignore the volos connector.

[#3]

Hi Dino,

I understand the idea but you have any proxy example from this because i saw different libraries in the js and im not sure that how to do some policies for exec all functions

Thanks