Five Stars

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

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.

  • Data Quality
2 REPLIES
Employee

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

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.

Five Stars

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

Thanks a lot!

 

I will give it a try.