Best practices for implementing an SAP data archiving infrastructure

Article

Best practices for implementing an SAP data archiving infrastructure

Frank J. Ohlhorst, Contributor

With a basic plan in hand, compliance requirements defined and goals set, the next steps in the process are product selection, deployment and validation.

Product selection will begin with an assessment of what is already owned and what is needed to enable an SAP data archiving system. In many cases, a consultant or vendor partner will become part of the process, simply because much of the technology under consideration will be unfamiliar to the IT staff and management. In those situations, it pays to bring in a professional services organization with a proven background and documented successes to assess the plan and current environment and to validate goals.

    Requires Free Membership to View

    When you register, you will start receiving targeted emails from my award-winning team of editorial writers. Our goal is to keep you informed on the hottest topics and biggest challenges faced by SAP professionals today.

    Hannah Smalltree, Editorial Director

    By submitting your registration information to SearchSAP.com you agree to receive email communications from TechTarget and TechTarget partners. We encourage you to read our Privacy Policy which contains important disclosures about how we collect and use your registration and other information. If you reside outside of the United States, by submitting this registration information you consent to having your personal data transferred to and processed in the United States. Your use of SearchSAP.com is governed by our Terms of Use. You may contact us at webmaster@TechTarget.com.

More information on SAP data archiving
Learn the prerequisites and action items of building an SAP data archiving solution

Learn how to build a business case for SAP data archiving

Find out how to get started with SAP data archiving 

 If feasible, pilot projects should be planned and then executed on secondary systems, so that live data is not affected during the validation phase. A solid experimental phase will help to avoid problems that could lead to downtime or, worse, data loss.

Most enterprises may not have the resources to approach a deployment in a methodological fashion, however, and they may be forced to work with live data sets. In those cases, replication of the data is a must before proceeding. In turn, it is better to have third-party support involved to proactively identify problems, before those problems affect any operational elements.

SAP enterprise products have created an ecosystem of support products, some of which are ideally designed for archiving and protecting data. What makes those products unique is how they deal with transactional data, which is the lifeblood of an SAP solution. Transactional data has multiple links across data files, tables and indexes and is usually arranged in a symbiotic relationship with other data elements. For example, an invoice will be linked to customer files, inventory files, sales history files and a multitude of other data elements. For archiving to be successful, all of the linked data must be preserved for each and every transaction.

Therein lies the primary requirement for an SAP archival solution. Simply put, can the archival solution recreate the data environment encountered at the time of data entry?

Several products and services have come onto the market that automate archiving and also provide the recovery environment to retrieve data with ease. Most of the vendors playing in that space require the purchase of both software and hardware to enable their solutions, and some work with more exotic technologies such as data virtualization or hosted storage. Administrators must be careful when selecting a product to make sure that there are no requirements (hidden or otherwise) that are not serviceable.

Ideally, a successful SAP implementation will meet several criteria:

 

  • Improve performance of the active transactional database system.
  • Protect data from corruption, loss or unauthorized access.
  • Reduce overall storage costs.
  • Meet compliance, corporate and legislative requirements.
  • Automate most of the process, reducing the administrative burden.
  • Provide reporting capabilities for validation needs.
  • Ease the retrieval of archived data.
  • Handle application upgrades or changes that affect the archived dataset.
  • Automatically retire data that is no longer needed.

Meeting those criteria and the defined goals indicates a successful implementation of an SAP data archiving solution. Of course, regular testing and data validation should be performed to ensure that the solution is delivering the appropriate business value. In the end, SAP administrators will find that two primary goals are met by the solution: improvement of transactional data system performance and reliable storage of archived data.

About the Author: Frank J. Ohlhorst, CNE, MCP, L+, N+, A+, is an award winning technology journalist, professional speaker and IT business consultant with more than 25 years of experience in the technology arena.


Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.