Connecting Apigee to Microsft SQL Server

[isaudalsaeed]

Hello everyone.

I have found some questions answered but there was so many deprecated stuff. We have on-premise

Apigee and we still have Node.js App as a proxy type. We will be querying the DB using apigee and run stored procedures.

• Is there a sample for connecting to Microsft SQL Server?
• Could you give me a general idea of how to do this?

Thank you.

Best regards

Saud

[sidd-harth]

We can make use of Hosted Targets to make calls to SQL server.

I do not have a sample but, I guess you can google and check how to connect with Sql server using Nodejs and the same can be used in Apigee as well.

https://docs.apigee.com/api-platform/hosted-targets/hosted-targets-overview

[isaudalsaeed]

I have created one and it works in my local machine. How do I wrap it and use it in the proxy? Do I need to download the modules?

[sidd-harth]

Please check this,

https://docs.apigee.com/api-platform/hosted-targets/hosted-targets-tutorials#deploy-node.js-from-you...

Follow the steps shown here and create a Hosted Target proxy in Apigee.

[isaudalsaeed]

My server doesn't have internet access. How can I tell nodejs to use local modules that I have downloaded.

[dchiesa1]

Wat. No. You cannot use Apigee with a server that has no internet access.

[isaudalsaeed]

Maybe I’m wrong but I think it has connection to the router and the router. Sends requests to it. So the server itself doesn’t have direct connection to the internet. I mostly work on the development side. So I’m not sure. I saw one proxy on the internet that has modules zipped in the same folder as the nodejs files. Is that ok? Is thier a size limit on the proxy?