Communities
A collaborative platform to connect and grow with like-minded Informaticans across the globe
Product Communities
Connect and collaborate with Informatica experts and champions
Discussions
Have a question? Start a Discussion and get immediate answers you are looking for
User Groups
Customer-organized groups that meet online and in-person. Join today to network, share ideas, and get tips on how to get the most out of Informatica
Get Started
Community Guidelines
Knowledge Center
Troubleshooting documents, product guides, how to videos, best practices, and more
Knowledge Base
One-stop self-service portal for solutions, FAQs, Whitepapers, How Tos, Videos, and more
Support TV
Video channel for step-by-step instructions to use our products, best practices, troubleshooting tips, and much more
Documentation
Information library of the latest product documents
Velocity (Best Practices)
Best practices and use cases from the Implementation team
Learn
Rich resources to help you leverage full capabilities of our products
Trainings
Role-based training programs for the best ROI
Certifications
Get certified on Informatica products. Free, Foundation, or Professional
Product Learning Paths
Free and unlimited modules based on your expertise level and journey
Resources
Library of content to help you leverage the best of Informatica products
Tech Tuesdays Webinars
Most popular webinars on product architecture, best practices, and more
Product Availability Matrix
Product Availability Matrix statements of Informatica products
SupportFlash
Monthly support newsletter
Support Documents
Informatica Support Guide and Statements, Quick Start Guides, and Cloud Product Description Schedule
Product Lifecycle
End of Life statements of Informatica products
Ideas
Events
Change Request Tracking
Marketplace
English
  • Data Archive 6.5.1
  • All Products

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

User Guide

User Guide

Back Next

SAP Application Retirement Process

SAP Application Retirement Process

Before you retire an SAP application, you must verify the installation prerequisites and complete the setup activities.
To retire an SAP application, perform the following high-level steps:
  1. Install and apply the SAP transports. For more information, see the "SAP Application Chapter" of the
    Informatica Data Archive Administrator Guide
    .
  2. Install and configure the SAP Java Connector. For more information, see the "SAP Application Chapter" of the
    Informatica Data Archive Administrator Guide
    .
  3. Copy the
    sapjco3.jar
     file to the
    webapp\web-inf\lib
     directory in Data Archive.
  4. If the SAP application is installed on a Microsoft SQL Server database, enable the following property in the
    conf.properties
     file by setting the value to "Y":
    informia.sqlServerVarBinaryAsVarchar=Y
  5. Restart Data Archive.
  6. Create a customer-defined application version under the SAP application in the Enterprise Data Manager.
  7. Import metadata from the SAP application to the customer-defined application version.
  8. Optionally, run the SAP smart retirement standalone job. For more information, see the topic "SAP Smart Retirement" in this chapter.
  9. Create retirement entities.
    Use the generate retirement entity wizard in the Enterprise Data Manager to automatically generate the retirement entities. When you create the entities, you can specify a prefix or suffix that will help you identify the entities as retirement entities. If you ran the SAP smart retirement job, select "Group by SAP Module" when you configure the retirement entities.
  10. Create a source connection.
    For the connection type, choose the database in which the SAP application is installed. Configure the SAP application login properties. You must correctly enter the SAP host name so that the SAP datatypes are correctly mapped to Data Vault datatypes during the retirement process.
  11. Create a target connection to the Data Vault.
  12. Run the Create Archive Folder job to create archive folders in the Data Vault.
  13. If the SAP application is installed on a Microsoft SQL Server database, enable the following property in the
    conf.properties
     file by setting the value to "Y":
    informia.sqlServerVarBinaryAsVarchar=Y
  14. Create and run a retirement project.
    When you create the retirement project, add the retirement entities and the pre-packaged SAP entities. Add the attachment link entities as the last entities to process. Optionally, add the Load External Attachments job to the project if you want to move attachments to the Data Vault.
  15. Create constraints for the imported source metadata in the ILM repository.
    Constraints are required for Data Discovery portal searches. You can create constraints manually or use one of the table relationship discovery tools to help identify relationships in the source database.
    The SAP application retirement accelerator includes constraints for some tables in the SAP ERP system. You may need to define additional constraints for tables that are not included in the application accelerator.
  16. Copy the entities from the pre-packaged SAP application version to the customer-defined application version.
  17. Create entities for Data Discovery portal searches.
    Use the multiple entity creation wizard to automatically create entities based on the defined constraints. For business objects that have attachments, add the attachment tables to the corresponding entities.
    The SAP application retirement accelerator includes entities for some business objects in the SAP ERP system. You may need to create entities for business objects that are not included in the application accelerator.
  18. Create stylesheets for Data Discovery portal searches.
    Stylesheets are required to view attachments and to view the XML transformation of SAP encoded data.
  19. To access the SAP Archives, verify that your login user is assigned the SAP portal user role.
    If you installed the SAP retirement accelerator, you can use pre-packaged data visualization reports to access retired data in the Data Vault. You can access the reports through the SAP Archives under the Data Visualization menu.
  20. Optionally, validate the retired data.
    Use the Data Validation Option to validate the data that was archived to the Data Vault. Because SAP applications contain thousands of tables, you may want to validate a subset of the archived data. For example, validate the transactional tables that were most used in the source application.
After you retire the application, use the Data Discovery portal, SAP Archives, or third-party query tools to access the retired data.
0 COMMENTS
We’d like to hear from you!