We have an issue where we are using TDV (Tibco Data Virtualization). It uses a subset of SQL with some specific datatype changes and a physical path to the stored views of the data. We need to model this as part of the data lineage. It goes through multiple transforms and results in a normalized layer and eventually a denormalized business view. It is important that we capture all of this. Is there a way to create a custom language transform that allows the user to automatically reverse engineer based on the TDV language. We have almost 4 years worth of data and hundreds of models.
Any direction other than do it all manually would be appreciated.
We ended up creating an Alteryx macro that processed through the TDV Data and gave us what we wanted. No feedback from IDERA