1. User’s Guide for Oracle Analytics Desktop
  2. Import, Export, and Share
  3. 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 archive file is for export and import, and you can't open it with an application other than Analytics Cloud or Oracle Analytics Desktop.
The archive 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, select the item to share. Click Actions, and select Export to open the Export dialog.
  3. Click File.
  4. For Name, keep the default name or enter a new name for the export file (.DVA file).
  5. Disable the Include Data option to exclude the data when sharing a workbook or folder.
  6. Disable the Include Connection Credentials option so that users must sign in to open the workbook. 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.

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

  7. 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.
  8. Click Save. Select a location for the file, and then click Save.