I have a business need to take the results of an API, in realtime / when queried (as opposed to using a scheduled action to do this periodically) and make them accessible via a SQL view.
An application that I need to integrate with another application can perform some functionality via SQL integrations with SQL views that it just can't do via results of a web service call.
So my question to the public here is whether they are aware of a product or solution that can be customized to take the results of a JSON / XML collection of a web service query - that the product or solution must execute on it's own when queried via SQL - and format / return them via a sort-of emulated SQL view, assuming said product can emulate a SQL server.
Is this possible, or am I day-dreaming?
I've attempted to do some research on this on my own, but have only found articles showing how to do the opposite - host an API that returns SQL results via REST/SOAP.