Two Data Sources - On Premise and Azure?

[MattieG72MP]

Hi All

We have an on-premise gateway and it works very well for all of our service reports but I now need to add Azure Database data to some of these reports.

Is there any option in the service to have two gateways or do i need to bring the Azure data into our local data warehouse and then use the on-premise gateway?

Any advice would be awesome, thank you 🙂 

Mattie

[bwhitlocksaxco]

I dont understand the resolution on this. Im having the same requirement. I have an on premise gateway that Im merging data from a local SQL db and an Azure DB. My current gateway refreshes every day but I dont see an option to add the Azure DB to the gateway. Do you have to dump the Azure DB to local tables then use that table in the gateway? If so how is that done. 

[v-jiascu-msft]

Hi @MattieG72MP,

You can use the Azure database directly. Is it a Azure SQL Server Database? You can try it out and post the issues you have.

Best Regards,

Dale

[MattieG72MP]

Hi All

Basically what I am trying to achive in the service is having a report that pulls data from the on-premise gateway and also from Azure but as far as i can see there is no way of setting up the 

dataset subscription to come from an on-premise gateway and a direct connection to Azure?

Thanks

Mattie

[v-jiascu-msft · Accepted solution]

Hi @MattieG72MP,

I tested it successfully with import mode to local SQL DB and Azure SQL DB. Please try it out.

Best Regards,

Dale

[v-jiascu-msft]

Hi @MattieG72MP,

Could you please mark the proper answer as solution?

Best Regards!
Dale

[Greg_Deckler]

Are you using Personal data gateway or Enterprise?

[MattieG72MP]

Hi,

Yes it is an enterprise gateway 🙂

Mattie