Archiving Process, Phase 1: Setting Up Your System

  • by Ned Falk, Senior Education Consultant, SAP
  • September 1, 2008
Understand how the archiving process has changed in SAP NetWeaver BI 7.0. Find out the three steps you can take for archiving, then see how to go about the first part of the process: setting your system up for archiving using Archive Development Kit.
Key Concept

Every company must address archiving eventually. By reducing the data set both loading and querying run faster. SAP NetWeaver BI 7.0 offers two types of archiving: Archive Development based and Near Line Storage based.

Many companies implement archiving as part of an overall Information Lifecycle Management (ILM) strategy. The lifecycle refers to information that might exist in many forms — for example, in a legacy system, then SAP ERP, then BI DataStore Objects (DSOs), and finally BI InfoCubes. The strategy involves where and when to archive this information and in what technical formats it should be stored for ease of retrieval.

Whether or not you address archiving as part of a strategy or you are just fighting a fire by deleting data to avoid buying more storage, you need to know about the software tools available to create and retrieve the archive data. For SAP online transactional processing (OLTP) systems — for example, ERP and CRM — archiving is normally performed with the SAP Archive Development Kit (ADK). In these systems archiving is supported from the technical side by the Basis team (now called the core SAP NetWeaver team).

SAP NetWeaver BI 7.0 (patch 15 and later) is fully featured when it comes to ILM. You can archive data from DSOs and InfoCubes and access it later in two easy, but technically different, ways. One of these ways is the same ADK that the SAP OLTP systems use. Although this support was available in earlier releases of SAP BW, it is improved in SAP Net­­Weaver BI 7.0.

Support for Near Line Storage (NLS) systems is new with SAP NetWeaver BI 7.0. NLS is a third-party technology that allows direct SQL access to archived data via BEx Query. It stores data in proprietary data storage platforms with links to this data that permit SQL access. For example, if you select “Jan 1980” as a query, the NLS system fetches the corresponding data and returns it to the SAP NetWeaver BI front end seamlessly.

Ned Falk

Ned Falk is a senior education consultant at SAP. In prior positions, he implemented many ERP solutions, including SAP R/3. While at SAP, he initially focused on logistics. Now he focuses on SAP HANA, SAP BW (formerly SAP NetWeaver BW), SAP CRM, and the integration of SAP BW and SAP BusinessObjects tools. You can meet him in person when he teaches SAP HANA, SAP BW, or SAP CRM classes from the Atlanta SAP office, or in a virtual training class over the web. If you need an SAP education plan for SAP HANA, SAP BW, BusinessObjects, or SAP CRM, you may contact Ned via email.

See more by this author


No comments have been submitted on this article. 

Please log in to post a comment.

To learn more about subscription access to premium content, click here.