One datamart with combination of onprem and cloud sources

[gwuhm]

Hi,

is it somehow possible to combine data from onprem sql (via onprem gateway) and from cloud (azure tables etc) in single datamart? If I select onprem gateway in project options, then all data, even from azure tables, are loaded via onprem gateway. This makes huge traffic on local internet connection.

I'm unable to find any way how to set query1 to use onprem gw and query2 to connect directly to azure in single datamart, which makes it little bit useless for me.

Thnak you

Pavel

[gwuhm]

Hi @GilbertQ ,

yes, but I am unable to select onprem gateway for query1 and "no gateway" for query2 in single datamart. All queries have to had same gw.

Pavel

[GilbertQ]

HI @gwuhm 

You would need to create 2 seperate queries when creating the datamart. And then merge or append the queries into a table to get them together?