Table of Contents

Search

  1. Preface
  2. Introduction
  3. Accessing Data Archive
  4. Working with Data Archive
  5. Scheduling Jobs
  6. Viewing the Dashboard
  7. Creating Data Archive Projects
  8. SAP Application Retirement
  9. Creating Retirement Archive Projects
  10. Retention Management
  11. External Attachments
  12. Data Archive Restore
  13. Data Discovery Portal
  14. Data Visualization
  15. Oracle E-Business Suite Retirement Reports
  16. JD Edwards Enterprise Retirement Reports
  17. Oracle PeopleSoft Applications Retirement Reports
  18. Smart Partitioning
  19. Smart Partitioning Data Classifications
  20. Smart Partitioning Segmentation Policies
  21. Smart Partitioning Access Policies
  22. Language Settings
  23. Data Vault Datatype Conversion
  24. Special Characters in Data Vault
  25. SAP Application Retirement Supported HR Clusters
  26. Glossary

Browse Data

Browse Data

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.

0 COMMENTS

We’d like to hear from you!