On Sat, May 26, 2018 at 4:50 AM, Thierry Nivelet tnivelet@foxincloud.com wrote:
Did your vendor and you consider building an ultra-secured interface that would take your SQL commands as input, and deliver the result dataSet into something like JSON that you can convert into the dataSet format that your DW layer uses?
You could just replace the calls to the SQL connection by a function that would identify whether you work local or cloud and call the suitable service.
It is a multi-tenant environment so that is not available. We have a data lake but I am not sure what is there as of yet. Our current data is 1.2 TB now and I hope they take what we have and normalize it finally but we would never know would we. :)
In my mind we just have them create APIs that do what we want and all is good.