Skip to main content
To homepage To homepage

Hello,

 

 

I’m looking for a query/view/stored procedure that can be used to query the data lineage / data flow.

I would like to have the source to target mapping etc in a report/overview instead of in the GUI.

So, I can easily report on the tables that are used to build the table in the next layer.

 

Anyone an idea?

 

Thank you,

Gert

 

 

 

 

Hi,

in TX 20.10.x you can query this from the repository with some effort, in TDI you do not have direct access to that data yet. 

There are some Ideas posted in this area, upvoting those would help:

 

 

Hello Rory,

 

Thanks for your answer. I upvoted as well the suggestions.

We are running TX 20.10 - legacy. 

Indeed, I noticed some useful tables in the repository, so I was looking for “ready-to-use” queries or views, instead of re-inventing the wheel … 😃

 

 

Gert

 

Hi,

that would come dangerously close to consultancy :-)

You have to know quite precisely what your needs are, as you will quickly discover you need to add a lot of tables and logic in to be sure you get the complete view. There might be some information on the legacy support site and hidden in posts here, but I can't remember anyone posting a complete query.

Hi ​@gertwuyts_umicore please try to download and adjust the TX dictionary project for your use case https://legacysupport.timextender.com/hc/en-us/articles/115004020826-How-to-Configure-the-TX-Dictionary-project

Hi Christian,

 

I dowloaded the TX dictionary project already, but it gives multiple errors when deploying it … (invalid column names etc)

But, I can use it so have a look in the project, and get some info on which tables are used etc 

 

 

 

Depending on whether you are running on SQL Server on-prem or in Azure, you may need to tweak some syntax here and there. The project is also not always perfectly in synch with repository structure. It's been a while so I don't know what the current state is.

Reply


Terms and ConditionsCookie settings