Enterprise Vault™ Discovery Accelerator Administrator's Guide
- Introducing Discovery Accelerator
- Introducing the Discovery Accelerator client
- Setting up and assigning roles
- Working with cases
- Setting up review marks and tags
- Using rules to mark and tag items automatically
- Using Custodian Manager
- Searching for items
- About searching with Discovery Accelerator
- Defining email targets with Address Manager
- Building Discovery Accelerator search schedules
- Manually reviewing items
- About reviewing with Discovery Accelerator
- Searching within the review set
- Deleting items from Enterprise Vault archives
- Working with research folders
- Exporting and producing items
- About exporting and producing items
- Performing an export or production run
- Creating and viewing reports
- Appendix A. Customizing Discovery Accelerator
- Setting Discovery Accelerator system configuration options
- Appendix B. Importing configuration data from an XML file
- Appendix C. Enterprise Vault properties for use in Discovery Accelerator searches
- Appendix D. Troubleshooting
- Issues with Custodian Manager
- Issues with Discovery Accelerator reports
Using the OData service with Microsoft Excel
The following instructions are for using the OData service with the following Microsoft Excel versions:
Microsoft Excel 2010 and 2013
Make sure that you have installed the Microsoft Power Query add-in for Excel. You can download the add-in from the following page of the Microsoft website:
Microsoft Excel 2016, 2019 and O365
To use the OData service with Microsoft Excel 2010 and 2013
- Open Microsoft Excel.
- Create a new, blank workbook.
- On the Power Query tab, in the Get External Data group, click From Other Sources, and then click From OData Data Feed.
- In the OData Feed dialog box page, in the URL box, specify the website address for the data feed as follows:
http://server_name/DAReporting/OData/dataset_name(parameter=value)
For example:
http://da.mycompany.com/DAReporting/OData/CaseHistory(customerID=1005,caseID=5)
Note:
Take care to specify the mandatory parameters that are required to view the dataset. Except for the Customers dataset, all the datasets have mandatory parameters. For information on them, see the online Help for each dataset.
- If you are prompted for your credentials, enter them and then log in. The Query Editor opens.
- In the Query Editor, view the records available for the dataset. Edit the queries as required.
- Click Close & Load to import the dataset information in Excel in tabular format.
To use the OData service with Microsoft Excel 2016, 2019 and O365
- Open Microsoft Excel.
- Create a new, blank workbook.
- On the Data tab, in the Get External Data group, click Get Data, click From Other Sources, and then click From OData Data Feed.
- In the OData Feed dialog box page, in the URL box, specify the website address for the data feed as follows:
http://server_name/DAReporting/OData/dataset_name(parameter=value)
For example:
http://da.mycompany.com/DAReporting/OData/CaseHistory(customerID=1005,caseID=5)
Note:
Take care to specify the mandatory parameters that are required to view the dataset. Except for the Customers dataset, all the datasets have mandatory parameters. For information on them, see the online Help for each dataset.
- If you are prompted for your credentials, enter them and then log in. The Query Editor opens.
- In the Query Editor, view the records available for the dataset.
- Transform the records by clicking on the Transform Data button. This will open the Power Query Editor where you can edit the data to meet your needs. Note that the original source remains unchanged.
- Click Close & Load to import the dataset information in Excel in tabular format.