Azure api gateway for external calls

Question

Hi,

I have a scenario which I think I can use Azure API capability but I'm not sure whether it will work because I have not used it before.So, we have an external SaaS application that our organisation is using, we need to copy a bunch of information (few database tables ) to our on-premise database from that SaaS application database.The SaaS application endpoints are exposed via Soap/Rest API calls. we don't have API capability in the on-premise environment. Can I use Azure API gateway/portal to make an API call to that SaaS database endpoint to copy the database tables ? Is this a valid use case for using Azure API portal?

Answer 1

While APIM is a perfect choice for exposing services, doing so to just copy the database tables is not required. This would of course depend on how often you need to copy the database tables.

For bulk transfers, you could just make do with a simple script and/or program (any language) that could perform the move.

For periodic transfers, you could run the same script on a loop (keeping track of the last record synchronized) or use Logic Apps along with the On-Premises Data Gateway to transfer this data.

If your scenario would still benefit from exposing the APIs, you could leverage APIM by deploying into a Virtual Network that has access to your on-premises data via a VPN Gateway or ExpressRoute.