Global teams need access to a Single-instance DB, what should I consider?

I have 5 global teams (Australia, Japan, USA and France, Germany and Italy) that need access to a single-instance DB for Power BI and SSRS reporting. We have looked at the Azure DW, but it is cost prohibitive. I was thinking of creating a schema in a single instance, and then have Azure Data Factory push data in.

The only concern that I now have is performance and availability. It has to be performant and available 24/7 for global teams to access. What should I consider?

submitted by /u/amit1998
[link] [comments]

Leave a Reply