topic Re: How do I define data sources if I have multiple TDQ data marts? in Data Quality

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

Anonymous — Tue, 20 Jun 2017 16:32:05 GMT

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

Replicate the data mart for each business group
Create the same analysis and report for each business group (using a Data Filter)
Save the report for a business group in the corresponding data mart
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.

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

Sebastiao_Qlik — Wed, 21 Jun 2017 13:23:02 GMT

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.

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

Anonymous — Wed, 21 Jun 2017 21:50:31 GMT

Thanks a lot!

I will give it a try.