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

Prerequisites

Prerequisites

Before you can run a Data Visualization report, you must first retire the Oracle E-Business Suite application.
When you archive data from Oracle applications, the ILM repository must be an Oracle repository.
To retire a Oracle E-Business Suite application, perform the following high-level tasks:
  1. In the Enterprise Data Manager, create a customer-defined application version.
  2. Import metadata from the Oracle E-Business Suite application to the customer-defined application version, along with user-defined views.
  3. Create retirement entities. Use the generate retirement entity wizard to automatically generate the retirement entities.
  4. In the Data Archive user interface, create a source connection. For the connection type, choose the database in which the Oracle E-Business Suite application is installed.
  5. Create a target connection to the Data Vault.
  6. Define a new data type mapping to handle VARCHAR2(0) length columns that exist in the views.
    1. In the Data Archive user interface, click
      Administration
      Data Type Mappings for File Archive
      .
    2. Click
      New Data Type Mapping
      .
    3. For Connection Type, select All Connections.
    4. For Data Type, select VARCHAR2.
    5. For Operator, select Equals.
    6. For Length, enter 0.
    7. For Precision and Scale, enter 0,0.
    8. For File Archive Data Type, select VARCHAR.
    9. For Source Length, enter 40.
    10. Click
      Save
      .
  7. Run the create archive folder standalone job to create archive folders in the Data Vault.
  8. Create and run a retirement project.
  9. In the Enterprise Data Manager, create constraints for the imported source metadata in the ILM repository. Constraints are required for Data Discovery portal searches. The Oracle E-Business Suite application retirement accelerator includes constraints for some tables in the Oracle E-Business Suite system. You might need to define additional constraints for tables that are not included in the accelerator.
  10. Copy the entities from the pre-packaged Oracle E-Business Suite application version to the customer-defined application version. To copy the entities, perform the following high-level steps:
    1. Right-click the customer-defined application version where the metadata is imported and select
      Copy entities from Application Version
      . The
      Copy Entities from Application Version
      window appears.
    2. Select the application version from where you need to copy, which is typically Oracle Applications Retirement 1.0.
    3. Provide the prefix that will be appended before the entity while copying. The Copy All Entities option is not required.
    4. Click
      OK
      .
    5. After you submit the background job, you can view the job status from the Data Archive user interface. Once the job successfully completes, you can view the copied entities in your customer-defined application version. You can use these entities for Data Discovery.
  11. Before you run the reports, copy the report templates to the folder that corresponds to the Data Vault connection. You can use these pre-packaged Data Visualization reports to access retired data in the Data Vault. When you copy the reports, the system updates the report schemas based on the connection details.
  12. Optionally, validate the retired data.
  13. After you retire and validate the application, use the Data Discovery Portal, Data Visualization reports, or third-party query tools to access the retired data.

0 COMMENTS

We’d like to hear from you!