How do we export a Dataset in OAC?

Jahnavi-Oracle

Summary:

How do we export a Dataset in OAC?

Content (required):

Is there a way we can export a dataset in OAC, to migrate it from one environment to another.

My scenario is specifically related to a Dataset created from an ADW Table in OAC. And also need to migrate only the dataset but not the whole snapshot.

Version (include the version you are using, if applicable):

OAC January 2023

Bharath Raghupathi-Oracle

Hi @Jahnavi-Oracle

You can export and import a project/workbook built using this data set. It will migrate the underlying data set as well.

Thanks,

Bharath

Jahnavi-Oracle

Yep, was trying the same option, Thanks @Bharath Raghupathi-Oracle .

But that confirms that we can't migrate just the dataset alone right as of now?

Michal Zima

@Jahnavi-Oracle No, unfortunately this is not possible to "migrate" just data set (or couple of data sets) separately. The only way is to create "dummy" DV workbook, in which you include all data sets you want to migrate between environments and then export it via DVA package (which will include definitions of all data sets included in this DV workbook). DevOps (deployments, migrations) in Data Visualization is area, which is very much neglected by Analytics Product Management (in favor of more "shiny" and visible features) and I am trying to point this out, that this should be of much more relevance in every contribution in Analytics idea labs, discussion, hoping that customer voice will be heard.

Jahnavi-Oracle

Thank you @Michal Zima .

Agreeing with your concern on DevOps enhancements. My customer was surprised today to see that we don't have this feature of migrating just the dataset.

Joshua C. Stewart

Is this process as easy as exporting & importing a workbook with the underlying dataset?

I imagine if you're moving a dataset built on an ADW table across instances you would have to make sure your secondary instance is configured to connect to the respective ADW instance (i.e. Uploading the wallet, creating a connection to the ADW, etc...).

Jahnavi-Oracle

Hi Joshua, Yes I have tried to maintain the same ADW connection name across instances and changed the wallet file accordingly as well.

So you are right, this is an additional step we need to keep in mind while exporting a workbook with dataset created from DB tables.