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

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.

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.

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Enabling Data Governance

Learn how to enable Data Governance

Watch Now

The Definitive Guide to Government Data Quality

Take a peek at the definitive guide to Government Data Quality

Read