How could I handle security in a multi-tenant enviroment using azure analysis? All the demos have the URL hard coded in the client.
..to add to this I have a tenant Id and this will be saved in the JWT.
So I somehow need to filter by tenant Id everyime I make a call to the Azure analysis service.
I noticed you had the accelerator, but not sure how to wedge that in.
Hello, Marty!
Thank you for reaching out to us.
Kindly note that when connecting Flexmonster to the Asure Analysis Services, the report should always include the URL to the Accelerator. When talking about connecting to multiple Asure Analysis Services instances, each one will require a different Accelerator instance, and different users will have different Flexmonster reports.
Let us provide more details about connecting Flexmonster to Azure data source.
The only way to connect Flexmonster to Azure Analysis Services data source is by using Flexmonster Accelerator.
Here is the starting guide for Flexmonster Accelerator: https://www.flexmonster.com/doc/getting-started-with-accelerator-ssas/.
And the additional Azure configurations: https://www.flexmonster.com/doc/accelerator-configurations-reference/#azure-analysis-services-configurations.
When connecting Flexmonster to Azure, the Accelerator and your data are located on different servers. As a result, the data loading speed might be slower than expected. We recommend testing if the performance in this setup works well for you and, if not, considering other data sources.
Looking forward to hearing from you.
Kind regards,
Solomiia
Hi Solmiia,
I only have one database and model. However I want to create global filters because different tenants are going to be logging in.
Regards,
Marty
.. My other question is there is a share feature. Is that caching from the accelerator? So if I did have multiple tenants on a single database they would be able to share reports?
Hello, Marty!
Thank you for getting back to us.
For the multiple tenants that are referencing one database, we recommend configuring the subqueries in the report.dataSource
object.
Here is the JSFiddle sample for reference: https://jsfiddle.net/flexmonster/83q6atsu/.
Regarding your question about sharing reports, please note that this feature is available only for Flexmonster Data Server data source.
Hope you will find our answer helpful.
Kind regards,
Solomiia