Gimmal Blog

Read the latest thought leadership and industry news from the experts at Gimmal!

All Posts

How to Migrate Your SAP Database to SAP HANA

I have spoken before about the parallels of the transition of the SAP Application Database to SAP HANA and the gorgeous and dangerous road to Hana in Maui. The actual road to Hana is listed as last on’s list of “Five most dangerous roads in the world,” but it still made the list! The hairpin turns and the drop-offs are part of the reason, although another large part is the ability to get distracted by the views.

This is what makes it the perfect metaphor for what we at Gimmal refer to as the “Road to HANA.” Without a plan and an understanding of what lies ahead, it is possible to get distracted by the (admittedly exciting) prospect of real-time analytics and improved application responsiveness delivered by a fully in-memory database. In this post I will cover the more general case of what you need to consider before making the move to SAP HANA.

Travel Light and Take Only What You Need

The first thing to consider before setting off with your database on the “Road to HANA” is data volume. This is a concern both for the total size of the database as well as individual tables. The total size is important due to the in-memory nature of HANA. The more unnecessary transactional data you have in your database, the more “luggage” you are carrying and will have to account for in your final HANA system. This is also important for individual tables, as tables with large data volumes (i.e. over 2 billion) must be partitioned before migrating to SAP HANA. See SAP Note 1785057 for more details.

Also, in that SAP Note are details about a conversion needed for pool and cluster tables into transparent tables that will happen as a part of migration. This is important for custom code that refers to these tables, and the SAP Note 1785057 contains details about how to make the adjustment is custom ABAP code.

Make Sure to Check Your “Equipment”

When driving the road to Hana, you need to know your vehicle, and to be able to trust your brakes and tires to operate to spec. Similarly when preparing for the “Road to HANA” you need to have certified solutions for hardware and software.

For SAP HANA-Certified hardware, the easiest option is to consider is using a cloud provider. All the major cloud providers are actively building out their cloud offerings for SAP HANA, and the choice of which to go with is a significant decision dependent on too many factors to get into here. Suffice it to say, SAP HANA in the cloud has attracted the major players: Microsoft Azure, Amazon Web Services, and Google Cloud.

If your organization’s strategy is to take an on-premise approach, then SAP maintains a directory of certified hardware here: Certified and Supported SAP HANA® Hardware.

From a software perspective, it is vital to use an SAP-Certified ArchiveLink solution for data archiving, print list archiving, and archiving of unstructured content. Which solution you choose will have a lot to do with how you want to store this data. For example, for an organization using Office 365 and SharePoint Online for their Document Management, the use of a SharePoint compatible and SAP Certified ArchiveLink solution is vital.

Document Management on the Road to HANA

Another vital preparation on the “Road to HANA” is to look for the content that does not belong in your SAP Application Database to begin with: unstructured content or, as it is known more colloquially, documents. These are the supporting documents to the structured transactional data that should be pushed to ECM as part of your standard business processes. I will re-up my piece specifically on this here because it so vital to SAP Application Database health. It is also important for business process health, as storing document content in your organizational ECM allows this content to be found by users where they expect business document content to be stored. This consistency when applied across business processes helps to realize the promised efficiencies of enterprise-wide systems.

The intersection of ERP and ECM is the Shangri-La of enterprise computing, or perhaps it is the realistic earthly equivalent that is Hana. ERP powered by SAP HANA is the promise of real-time analytics and in-memory performance. ERP integrated with ECM is the key to keeping in-memory database costs down and enabling business process documentation that is visible to the right users where they expect it. Getting there will involve twists and turns but knowing what lies ahead on the “Road to HANA” is the key to navigating it.

 New Call-to-action

By Nathan Hampson
Nathan Hampson is a Principal in Gimmal's Client Success department with a unique, front-line view into concerns facing SAP users.

Related Posts

Why Should Records Management be Important to You

Why should an organization care about records management? When users throughout all departments are creating new records without a thought to how they are cataloged or tagged, the sprawl of records can become a real threat. Unstructured data can lead to compliance issues for highly regulated industries. When proper records management isn’t a top priority, content that should have been disposed of for security purposes is left vulnerable for anyone to find and distribute.  

Creating Compliance in Chaos: A Consultant's Story

Records and Information Management (RIM) is constantly changing and evolving as record managers begin to realize the benefits of automation in their daily operations. In my 6 years of consulting, I have seen everything from heavily manual business processes to automated document management solutions.  Even as time goes by, information professionals continue to face the long-standing hardship of trying to get end users to comply with either internal or external regulations when it comes to records management.  Lately, there has been an apparent shift from ridged business centric solutions to end user centric solutions. 

Gimmal at ARMA International InfoCon 2019

Once a year, members in the records management community come together for ARMA’s annual conference to discuss the latest advancements and best practices for modern information managers.  ARMA, the global authority of information management and governance, hosted this year’s conference, ARMA InfoCon, in Nashville, TN. While attendees were not in the typical “record” industry that Nashville is known for, the location called for a great mix of music and information management knowledge.