Repository Tables

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:

• Data lineage and documentation for business analysts in the portal

• Bring back the portal documentation feature

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 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.