Forum Discussion
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 creating a mirror db for each customer in fabric?
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.
4 Replies
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.
It depends what your customers intend to do with the data once it is in fabric.
For example, do they intend to keep using the data in a relational database or is the idea now to to move the data for analytical purposes? If it is for analytical purposes mirror db may not be the ideal solution and you may want to consider alternatives.
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 TeamHi DiKi-I
We have not received a response from you regarding the query and were following up to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.
Thank You.
