Ability to easily change connection assigned to external (database) data set in DV

Banjo

Our organization needs this desperately too.

I just promoted 8 workbooks up through our 5 database tiers, ending in Prod. Since I cannot repoint Datasets to different (identical in table structure) Connections, I had to MANUALLY recreate Datasets 32 times. It was super error prone, and I think my brain died a little in the process.

How can I recommend Oracle analytics to anyone if this essential feature, that practically all companies need, has not been addressed in several years since the issue was raised?

🤕

Mike Constanza

Going to chime in to say that this feature is absolutely crucial to our organization. It is impossible to maintain a meaningful development cycle without the ability to easily change connection information without losing all dataset changes. This basically forces us to recreate datasets multiple times and makes having multiple instances of OAC almost completely pointless. I've been documenting possible workflows for our upcoming implementation, and they are so insecure and cumbersome that I am having trouble conceiving how Oracle even imagines it should work.

We currently use Tableau and their data sources are extremely easy to migrate because you can just edit the connection without losing any metadata. If OAC is supposed to be a competitor for groups that aren't 100% self-service, then it needs to support more than just self-service in a production environment.

Michal Zima

Can somebody from Product Mgmt/Development shed some light on what status "Option for Future Release" mean ? How long it will take to have it implemented ? Apparently this feature (and also other features, around deployment/Dev2Prod  in DV) are not of high priority - despite the fact, that they are terribly missing in the product, very much complicating live for real enterprise deployments of DV where governance plays important role (not just couple of users, having complete freedom to do what they want…). So I would really expect here more "focus" and "goal kick" and prioritize those features to be implemented ASAP in product - please…..

Greg Faris

I agree with Michael. This is very problematic when you have 1000s of datasets in an enterprise deployment. What can we do to get this fast-tracked?

Greg Faris

@Benjamin Arnulf-Oracle @Gabby Rubin-Oracle Could we please get an update on the delivery timeframe? This has been a need for quite some time, and it shows Option for Future Release. Thanks!

Benjamin Arnulf-Oracle

@Greg Faris Checking with @Alan Lee - Oracle-Oracle and @Bret Grinslade - Oracle Analytics-Oracle . They might directly answer here or I will get an update.

Bret Grinslade - Oracle Analytics-Oracle

The improvement is on the roadmap. We don't have a target release date yet.

Dorothy Joseph-Oracle

This feature will be extremely useful for us as well as we do testing with data in one environment and then change the connection point as we go live. Appreciate any update on the timeline.

Bhaskar Konar

Much needed feature. It'll add so much values. Upvoted.