Browse Data enables you to use the Data Discovery portal to search and examine application data from specific tables in the Data Vault. The Data Discovery portal uses the search criteria that you specify and generates a SQL query to access data from the Data Vault. After you search the Data Vault, you can export the search results to a CSV or PDF file.
When you specify the search criteria, you choose which table columns to display in the search results. You can display all records in the table or use a where by clause to limit the search results. You can also specify the sort order of the search results. Before you run the search, you can preview the SQL statement that the Data Discovery portal uses to access the data.
You can also use Browse Data to view external attachments for entities that do not have a stylesheet. You can view external attachments after the Load External Attachments job loads the attachments to the Data Vault. You cannot search the contents of the external attachments.
When you search for external attachments, enter the entity that the attachments are associated to. The search results show all attachments from the AM_ATTACHMENTS table. The table includes all attachments that you archived from the main directory and also from any subfolders in that main directory. The search results show a hyperlink to open the attachment, the original attachment directory location, and the attachment file name. To view the attachment, click the hyperlink in the corresponding ATTACHMENT_DATA column. When you click the link, a dialog box appears that prompts you to either open or save the file.