Thanks for contacting Syncfusion support.
Yes, we can create a single dashboard for all the 150 consumers and only modify datasource in the dashboard based on consumer using shared datasource and user groups in Dashboard server. You can view the dashboard with the consumer’s datasource while login with consumer details in dashboard server. Please follow the steps to achieve your requirement.
- Create users and groups for your consumers , then assign user to the groups in User Management Server. We can assign a datasource to a group, users in the group can view the data. Refer the below links for details
- Synchronize the users and groups created in the User Management Server with Dashboard server enable the allow users in User Management Server.
- Create a dashboard with a datasource and assign the dashboard to all users, refer the below link to assign permission to user.
We can also assign permission to user through api, please refer the below link
- Now, add consumer’s database in dashboard server by following the link.
NOTE: Consumer database should be a different database, table’s names and Column names in the database should be identical with designed dashboard’s datasource.
- After adding the database, you can view the databases under “Datasources” section.
- Now assign user groups to view the datasource by following the below link,
- We can update the datasource alone for a dashboard by using shared datasource. Please refer the below link to update datasource to a group.
For example, I have updated a datasource of “Testing” group to this datasource.
Now, users in the group “Testing” can view the datasource(“DataSoucre2 , DataSource20”) in the dashboard while login with the user details in dashboard server. Likewise you have to assign for your each consumer group with their datasource.
You can assign the datasource through api also, refer the below link.
Please let us know, if you have any queries.
Thanks,
Renuka N.
