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.
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 NetWeaver 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.
Would you like to see this full item?