I have the need to store reports for multiple business groups in the Talend DQ data mart. But the requirement also states that in the TDQ portal the a user from one business group should only be able to view the analysis on the data from their own business group.
The simplest approach, I thought was to
How feasible is this approach? How would I create a data source for each data mart? Is it supported?
This post is related to another where I have another possible approach. The subject of that post is "TDQ - Role based report access".
Any help is greatly appreciated.
Yes, I think it's a valid approach.
You could use a context for the datamart in the report editor.
Then each business group would use a different context to store the analysis information in distinct datamarts.
In the DQ portal, you'll need to create a new data source for each datamart.
Then I think you'll need to duplicate the documents in the DQ Portal, put them in differents folders and edit the document template to set the corresponding datamart.
And assign permissions to groups of users.
I guess you will also need to deactivate QBE menu for all users because QBE is on a single datamart.