OAC - DV Connection Lineage with Dataset

Deepa Mohan

During a DV workbook migration to PROD (with Dataset 'DS' created from DB Table using DV connection 'DVCon') , even though 'Include Data' and 'Include Connection' is unchecked , this gets overwritten in Target instance.
The issue is that there is a separate Connection 'DVCon' with the exact same name with a different owner who did the import.

Upon trying to delete this DV Connection it says, 'Delete all the Dataset that use this connection first and try again'

There could be many datasets floating around unused and there is no way to track this or delete this unwanted DV connection .

Luis E. Rivas -Oracle

Hi - thank you for submitting this idea. We will set this to Needs Votes as this will help us internally prioritize this idea for consideration. But I believe this will be a very popular request.

Branden Pavol

There is no lineage across Oracle Analytics products. I have several connections that I would like to delete because someone created them by accident not realizing there were already some. Now we have duplicates. I can't delete them because some reports use them but there's no indication which reports. Even if I did find them, there's no swap connection option. So the only option is to go one by one through all reports and hope to find them….

RMJ-kpmg

@Luis E. Rivas -Oracle - Can this idea be consolidated with similar on the notion of 'OAC Content Lineage/Dependencies'?

There are several , each with votes, that could push this concept higher up the list :)

https://community.oracle.com/products/oracleanalytics/discussion/23347/provide-a-tool-so-that-users-can-easily-find-which-data-set-is-attached-to-which-workbook

https://community.oracle.com/products/oracleanalytics/discussion/23019/visualise-lineage-of-data-flows-datasets-workbooks