Our client is a retailer with stores across the country has shared the following requirements for the Qlik Sense app we are building for them.

- Load data from SQL Server for 18 stores
- Load data from Oracle for 7 stores
- All data should be refreshed once per day
- Users must see details of every transaction
- Most users should only see data for their store
- Some users (management) will have access to all data

Which of these approaches do you recommend we take?
App requirements image