Forum Discussion

DiKi-I's avatar
DiKi-I
Icon for Post Partisan rankPost Partisan
10 months ago
Solved

Multiple Customer Solution in fabric

Hi , We have 100 of customers and there data is stored in azure db, our plan is to bring the data to fabric. Each customer will have separate workspace. How feasible will this be if we are creatin...
one lake
  • tayloramy's avatar
    tayloramy
    10 months ago

    Hi DiKi-I, 

     

    I think this really depends on the business requirements here. I would not make a new mirrored DB for each user, that seems to be a little much. 

     

    What's the security requirements? Are all users access the same data, or are they each accessing different data from the same database? 

    Where my mind immediately goes for this is to have one workspace that contains the database, and then the users all connect to that same database in their workspaces. 

     

    What could also work is one mirrored DB and then a lakehouse with shortcuts to the mirrored database. 

     

    If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution.

v-karpurapud's avatar
v-karpurapud
Icon for Community Support rankCommunity Support
10 months ago

Hi DiKi-I 

Thanks for reaching out to the Microsoft fabric community forum. 

 

I would also take a moment to thank  tayloramy and KevinChant  for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.

I hope the below details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We’re always here to support you 

 

Best Regards, 
Community Support Team