Skip to main content
Solved

Overview connection tables and fields loaded with ODX server (documentation)

  • June 7, 2023
  • 1 reply
  • 68 views

rogier.helmus
Problem Solver
Forum|alt.badge.img+1

Hi all,

I have a customer at which the data & analytics team has to report which data (tables & fields) is loaded into the data lake with ODX server for a certain source. This is because the source contains GDPR data and the data & analytics team has to prove to the legal team that they aren’t loading GDPR data into the data lake and further upstream.

Unfortunately the TX documentation feature documents from the DSA and onward. The DSA documentation isn’t feasible for this request since we’re renaming fields and adding transformations. 

Is there a workaround to get this overview for a ODX server connection?

Kind regards, Rogier

TimeXtender version: 20.10.39

Best answer by Christian Hauggaard

Hi @rogier.helmus ODX documentation is not supported in 20.10. However it is supported in the new cloud-enabled version. We will soon be releasing a migration tool that allows you to migrate your 20.10 projects to the new version. In the meantime, perhaps you can query a copy of the ODX SQLite local backlog database https://legacysupport.timextender.com/hc/en-us/articles/360054444552-How-to-Query-ODX-local-Backlog-SQLite-database. Please avoid making an extra connection to Backlog.sqlite file in use, since it may interfere with ODX activity in progress.  For analytics, always make a copy of the current backlog file and use the copy for analysis.

View original
Did this topic help you find an answer to your question?

1 reply

Christian Hauggaard
Community Manager
Forum|alt.badge.img+5

Hi @rogier.helmus ODX documentation is not supported in 20.10. However it is supported in the new cloud-enabled version. We will soon be releasing a migration tool that allows you to migrate your 20.10 projects to the new version. In the meantime, perhaps you can query a copy of the ODX SQLite local backlog database https://legacysupport.timextender.com/hc/en-us/articles/360054444552-How-to-Query-ODX-local-Backlog-SQLite-database. Please avoid making an extra connection to Backlog.sqlite file in use, since it may interfere with ODX activity in progress.  For analytics, always make a copy of the current backlog file and use the copy for analysis.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings