How do I define data sources if I have multiple TDQ data marts?

[Anonymous]

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

1. Replicate the data mart for each business group
2. Create the same analysis and report for each business group (using a Data Filter)
3. Save the report for a business group in the corresponding data mart
4. The in the TDQ portal
   • Create a data source for each data mart
   • Create a role for each business group
   • Create the document template for each business group that uses the corresponding data source
   • Control access to the document templates by role (One for each business group)

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.

[Sebastiao_Qlik]

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.

https://help.talend.com/reader/hAtXOOO5XruHpJ3b4mOhpQ/3b2BkUpHMeNFtKXzOJ10WQ

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.

https://help.talend.com/reader/hAtXOOO5XruHpJ3b4mOhpQ/2Gc7F~jW8E2LUycJ0xpLdQ

And assign permissions to groups of users.

https://help.talend.com/reader/hAtXOOO5XruHpJ3b4mOhpQ/THzYZCba3mSQCRvQPzHDfQ

I guess you will also need to deactivate QBE menu for all users because QBE is on a single datamart.

[Anonymous]

Thanks a lot!

I will give it a try.