DV - Connection, selection option to be available while importing Workbook/ Data-flow

Subhakara Netala-Oracle

When we import a Workbook or Data-flow, existing connections are replaced with Workbook/ Data-flow connection(previous exported environment). It is creating an issue(unable to connect to database) in new instance where we import.

Request is while importing Workbook or Data-flow, user should have an option to select a connection from already existing connections. This may avoid existing connection overwrite issue.

Michal Zima

@Subhakara Netala-Oracle Pls, look at Idea, I have created in June 2020 (now in "Under Oracle Review" status): https://community.oracle.com/products/oracleanalytics/discussion/10008/ability-to-easily-change-connection-assigned-to-external-database-data-set-in-dv . It deals with very similar topic as yours, so pls, vote for my Idea as well - thanks.

Subhakara Netala-Oracle

@Michal Zima , thanks for letting me know. I have voted for your idea. Hopefully product development team will work on these issues soon. Otherwise there is no point to have Export/Import options if it overwrites existing connections.

Philippe ROGIERS-Oracle

This is just such a fundamental requirement to use Oracle Analytics in large reporting settings that it should not require voting : just implement it as it is obvious that when a business user moves a DV report to production and this breaks the production connection on which rely hundreds of users we get into problems which are showstoppers : it has happened to us and the customer raised CAPAs to know why. We are trying to cope with this with non professional workarounds currently.