Oracle Analytics Cloud and Server Idea Lab

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

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

Planned
842
Views
19
Comments
2»

Comments

  • Banjo
    Banjo Rank 1 - Community Starter

    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
    Mike Constanza Rank 1 - Community Starter

    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
    Michal Zima Rank 7 - Analytics Coach
    edited May 2024

    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
    Greg Faris Rank 5 - Community Champion

    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
    Greg Faris Rank 5 - Community Champion

    @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!

  • @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.

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

  • Dorothy Joseph-Oracle
    Dorothy Joseph-Oracle Rank 4 - Community Specialist

    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
    Bhaskar Konar Rank 7 - Analytics Coach

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