Cannot See Data Lineage from Report Back to Original Source with MS SQL as Source, SSIS as ETL and SSRS as a Reporting Tool
(Doc ID 2662153.1)
Last updated on MAY 06, 2020
Applies to:Oracle Enterprise Metadata Management - Version 22.214.171.124 and later
Information in this document applies to any platform.
On Oracle Enterprise Metadata Management (OEMM) 126.96.36.199, when trying to do a data lineage from a column in the report back to its original source, nothing is displayed besides the actual field form the report. It seems that OEMM cannot discover the connection between the SSRS report and the SQL database ( The source of the data)
This issue can be encountered when when trying the steps
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document