1. Visualizing Data and Building Reports in Oracle Analytics Cloud
  2. Visualize Data
  3. Import, Export, and Share
  4. Export a Workbook or Folder as a File

Export a Workbook or Folder as a File

You can export a workbook or folder as an archive file (.DVA) for backup purposes or to provide to another user for import into their instance of Analytics Cloud or Oracle Analytics Desktop.

Exporting is a way to share workbooks and files with other users or move workbooks and files between Analytics Cloud and Oracle Analytics Desktop. The .DVA file is for export and import, and you can't open it with an application other than Analytics Cloud or Oracle Analytics Desktop.
The .DVA file includes items that you specify such as the associated datasets, connection strings, connection credentials, and stored data.
  1. On the Home page, click Navigator, and then click Catalog.
  2. In the Catalog page, highlight the workbook or folder that you want to share, click Actions, and select Export to open the Export dialog.
  3. For Name, keep the default name or enter a new name for the export file (.DVA file).
  4. Enable the Include Data option to include the data when sharing a workbook or folder.
  5. Enable the Include Connection Credentials option so that users can open the workbook without having to sign in. Use the following guidelines to set this field:

    • Excel, CSV, or TXT data sources - These data sources don’t use a data connection, therefore you can clear the Include Connection Credentials option.

    • Database data sources - If you enable the Include Connection Credentials option, the users must provide a valid user name and password to load data into the imported workbook.

    • Oracle Fusion Cloud Applications Suite, Oracle Analytics Cloud – Essbase or Oracle Essbase data sources - make sure that you also select the Always use these credentials option in the Authentication field on the Create Connection dialog.

      If you clear the Include Connection Credentials option or specify the Require users to enter their own credentials option in the Authentication field, then users must provide a valid user name and password to load data into the imported workbook.

  6. If you enable Include Data or Include Connection Credentials, enter and confirm a password that the user must provide to import the workbook or folder and decrypt its connection credentials and data.
  7. Enable Include Permissions to include access permission details so that shared connections work when users import the workbook.
  8. Click Save to export to a .DVA file.
  9. Click OK to specify that you want to save the .DVA file rather open it in your browser.
  10. Browse to a folder where you want to save the .DVA file.
  11. Click Save to save the .DVA file to the folder that you specified.