We have an issue that seems like something others would also be encountering.

Our systems generally have 4 Database tiers, with the same tables etc. in each; Dev, Test, Staging, Prod

Since we embed many OAC workbooks, we want to promote them up our tiers, and test them at each stage with the corresponding DB Connection. However, OAC Datasets do not allow us to change the Connection. We end up having to manually replicate Datasets for each Connection in the promotion sequence, then do the "Replace Dataset" action (when it lets us, and the "Replace" button isn't grayed out... separate issue).

Is there an easier way to do this? If we could switch a Dataset's corresponding Connection, that would do the trick since we could just duplicate and swap. We want to avoid updating our Connection credentials each time to keep pointing to different tiers.

Any suggestions are greatly appreciated! Thank you all.