Administration and Implementation Tips for SAP Near Line Storage (NLS) Based on Sybase IQ

  • by Gary Nolan, SAP BI Strategic Architect, Sapiex Associates LLC
  • July 8, 2014
There are challenges to implementing the Near Line Storage (NLS) solution using Sybase IQ, and pitfalls to look out for during implementation. Learn tips for how to determine what to archive, how to segregate data, changes to the dataset, and understanding some features of the overall solution.
Learning Objectives

Reading this article, you will:

  • Develop an archiving strategy for Near Line Storage (NLS) using Sybase IQ
  • Understand what data works best with NLS
  • Determine how to distribute and segment data to NLS
  • Learn methods for bringing data back from NLS into SAP BW
  • Discover some workarounds for NLS challenges
Key Concept
Near Line Storage (NLS) using Sybase IQ allows data to be offloaded from the SAP BW HANA system and therefore saves on expensive HANA hardware and maintenance costs. However, there are several important things to understand about implementing this product before proceeding.

Near Line Storage (NLS) using Sybase IQ allows data to be offloaded from the SAP BW running on HANA system onto the NLS system. Sybase IQ is the database optimized for BI and NLS that is run by Sybase, a company purchased by SAP in 2010. Sybase IQ provides slower query access but does allow data that is not often used to be moved to the NLS system, thus freeing up the HANA system for newer, more dynamic data.

By offloading the data onto the NLS system, it is possible to still have access to this data for query purposes but it takes the data out of the costly HANA nodes which stores data hot in memory. This move typically results in big cost savings for companies. As the NLS tool using Sybase IQ is rather new, there are some important tips to understand how to optimize its use. Here I discuss what you need to consider when administering and implementing SAP NLS based on Sybase IQ.

For more information about Sybase IQ, see my article, “Understanding SAP NetWeaver BW Near-Line Storage (NLS) Based on Sybase IQ.”

Gary Nolan

Gary Nolan is an SAP NetWeaver BW-certified consultant and author of Efficient SAP NetWeaver BW Implementation and Upgrade Guide and Efficient SAP NetWeaver BI Implementation and Project Management. Gary specializes in gathering and evaluating requirements, configuring SAP NetWeaver BW, and providing project management, performance management, and data architecture and data modeling expertise. A former platinum consultant with SAP America, Inc., Gary has more than 20 years of SAP experience, working with SAP NetWeaver BW since version 1.2B.

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.