My Oracle Support Banner

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 12.2.1.2 and later
Information in this document applies to any platform.

Symptoms

On Oracle Enterprise Metadata Management (OEMM) 12.2.1.3, 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

  

 

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.