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. Salesforce Archiving
  9. SAP Application Retirement
  10. Creating Retirement Archive Projects
  11. Integrated Validation for Archive and Retirement Projects
  12. Retention Management
  13. External Attachments
  14. Data Archive Restore
  15. Data Discovery Portal
  16. Data Visualization
  17. Data Privacy
  18. Oracle E-Business Suite Retirement Reports
  19. JD Edwards Enterprise Retirement Reports
  20. Oracle PeopleSoft Applications Retirement Reports
  21. Language Settings
  22. Appendix A: Data Vault Datatype Conversion
  23. Appendix B: Special Characters in Data Vault
  24. Appendix C: SAP Application Retirement Supported HR Clusters
  25. Appendix D: Glossary

Load External Attachments

Load External Attachments

Use the Load External Attachments standalone job to archive external attachments. When you run the job, the job reads the attachments from the directory you specify in the job parameters. The job archives records from the directory and all subdirectories within the directory. The job creates BCP files and loads the attachments to the AM_ATTACHMENTS table in the Data Vault
The job creates an application module in EDM, called EXTERNAL_ATTACHMENTS. Under the application module, the job creates an entity and includes the AM_ATTACHMENTS table. You specify the entity in the job parameters. The entity allows you to use Browse Data to view the external attachments in Data Discovery without a stylesheet.
After you run the job, assign a Data Vault access role to the entity. Then, assign users to the Data Vault access role. Only users that have the same role assignment as the entity can use Browse Data to view the attachments in Data Discovery. A stylesheet is still required to view attachments in the App View.
You can run the job for attachments that you did not archive yet or for attachments that you archived in a previous release. You may want to run the job for attachments that you archived in a previous release to use Browse Data to view the attachments in Data Discovery.
If the external attachments you want to load have special characters in the file name, you must configure the LANG and LC_ALL Java environment variables on the operating system where the ILM application server runs. Set the LANG and LC_ALL variables to the locale appropriate to the special characters. For example, if the file names contain United States English characters, set the variables to
en_US.utf-8.
Then restart the ILM application server and resubmit the standalone job.
You cannot load files that are larger than 2 GB into Data Vault.

0 COMMENTS

We’d like to hear from you!