SAP Business One - Transitioning to Hana – The Time is Now!
Blog Hana

SAP Business One – Transitioning to Hana – The Time is Now!

The time has come for SAP Business One customers who have been running their ERP on Microsoft SQL to make the bold move to SAP Hana.

Given what I personally know about the differences between MS SQL and SAP Hana it’s imperative that we understand this move for what it is.  It is a very, very meaningful change.  You may notice that I do not refer to this as an “upgrade”.  While there will be elements of an upgrade in this overall project, there will be more work required, more modifications to digest, and a steeper learning curve.  It will also require more significant investments to be made in consulting services and very strategic investments related to infrastructure be they on-premise or cloud focused.  I firmly believe that this is not just a tactical project to keep my system up to date.  This is a strategic business decision.  A decision to remain relative and not be left behind in an every increasingly competitive world of global business.

Here are two reasons why the time is now:

The Value Proposition
First and foremost it is no longer possible to look at the SAP Hanaversion of SAP Business One side-by-side with the MS SQL version of SAP Business One and see them as equals. They are no longer the same product.  The Hana version delivers an array of new features and deliverables that SAP has made available only to the customer running their Hana solution.  These features will not be replicated in the MS SQL Version.
These features add significant value to the organization.  While focused primarily on analytics such as Dashboards, KPI’s, Interactive Analysis, and Excel-based Ad Hoc Reporting, all of which are customizable.  In addition, the feature set is expanded beyond the SQL version with Enterprise Search, Cash Flow Forecasting, Inventory Forecasting, Advanced Delivery Management, Mobile Sales App and soon to be released Mobile Service App and Chat Bot.  This added value is now beyond obvious.  So much so that in my own company 2017 saw a shift in sales of SQL systems vs. Hana.  Hana Systems now account for 75% of all recent sales of SAP Business One.

The Promise of Productivity
We are in the age of Big Data. We work in a time in integrated systems where IoT, Machine Learning, and Artificial Intelligence have already begun to shape business on a global basis.  Even the smallest of businesses must connect to this global experience and will face the impact of ever increasing numbers of transactions and all the associated record keeping.  Database sizes will grow exponentially and ERP Systems like SAP Business One will be the storage locations for all a company’s data.  It is the fulfillment of the phrase ERP as a platform.
This requires an in-memory database that like Hana reads data many times faster than traditional ERP databases that stored data on hard drive technology.  Real-time analytics and up-to-the-moment business decision making require the speed that Hana delivers.

This also requires the ability to transact data faster, import data faster (like EDI), and integrate systems into one central data repository without impacting the systems performance for routine users.  Everything must be real-time!  While SAP has not yet re-written the SAP Business One code to take full advantage of the Hana Service Layer, they have announced their full intention to do so.  It will be a multi-year endeavor with tremendous payoffs to those who are operational on Hana.

A recent investigation by one of the few SAP Business One customers who have already made the transition to Hana will demonstrate.  I asked my friends at HTRI (Heat Transfer Research Institute) to help me share with other customers the promise of the Hana Service Layer.  I proposed a project to import 10,000 Business Partner Master Data Records into a Business One Data Base.  My buddy Daniel Phelps from HTRI did this in 5 separate tests.  We normalized the data by projecting (based on how long it took to import 10,000 records).  How many records could we import in one hours’ time.

While these results are not different than what one might hear directly from SAP, it’s significant that the test was conducted by a Business One customer:
SAP Business One On Hana Test

Here are the results –  clearly the Hana Service Layer delivers far greater capability for real-time, high volume transactions.  Hana is fulfilling the promise of productivity.  It is a platform for the future!

SAP Business One On Hana Performance

* Please note that it is very hard to create systems (HANA vs SQL) that are 100% similar in every respect. Our investigation led us to believe that we could potentially achieve results as high as 160,000 records inserted per hour with additional threads.

How do you get there? – Three paths to Hana.

Path 1: Do It Now – Go for it.
There are SAP Business One customers who should make this move immediately. They are simpler than some and may have no addons for SAP Business One, or maybe just one or two small addons that bring convenience to business processes.  For the most part they run SAP Business One out-of-the-box.  They do not for instance have a large manufacturing or Warehouse Management addon.  These candidates have SAP Business One implementations with a distinct sense of simplicity.  Customers who meet this criterion should stop procrastinating and at their next up grade opportunity make the move to Hana.  Yes, some Queries, Crystal Reports, and Formatted searches will need to be modified and adapted to the Hana Syntax, but there is a database conversion utility that for a simple straightforward implementation will do the job to a very high degree.

At the same time these customers should be making an infrastructure decision.  You can place you new Hana system on-premise or in the cloud.  There are many cloud providers certified by SAP to properly source your SAP Business One Server(s).  My own company uses Amazon Web Services for our global deployment of multiple SAP Business One databases and we advocate Amazon Web Service to our customers.  I recommend that SAP Business One customers consult with their reseller regarding their specific cloud recommendation.  This type of transition project is not at all unlike a normal SAP Business One upgrade to a new server configuration.  You should do it now.

Path 2: Analyze Carefully – Then Flip the Switch – B1A then B1H
The illustration below gives you an idea of this approach. Even if you run several addons and have multiple integrations and customizations the B1A (Business One Analytics) approach provides time to make certain that all your business processes are working on the Hana side before you flip the switch to B1H (Business One on Hana – fully transactional).  In this approach, the Linux server is installed and about 80% of the MS SQL data is replicated to the HanaServer database.  Lookups, queries, reports and more are able to use the new in memory database to increase productivity.  You are also able to take advantage of many (but not all) of the Hana Analytics features.  Your addons are still operational and running on the MS SQL side of the equation.  This gives the company time to test everything completely against the Hana database while immediately delivering some of the Hana value to users.  Best of all, it takes just one day or less to be operational.  When ready you just flip the switch and move to fully transactional Hana system, but in the meantime enjoy:

  1. Gain some immediate features and benefits
  2. Time to modify queries, Report, Formatted Searches
  3. Time to prove addons are compatible
  4. Time to move integrations (such as EDI) from the DIAPI to the Service Layer
  5. Time to deploy new SAP Business One and Hana specific features
  6. Reduce the risk and potential disruption
  7. Reduce the frustration of slow reporting

SAP Business One Analytics Powered By Hana

Path 3:Reinvent and Redeploy
Customers fitting best into this approach see themselves as more complex. They may be larger SAP Business One implementations with multiple databases, multiple addons, many customizations and integrations or perhaps a customer that wants to reinvent their SAP Business One deployment – the right way.  Experience is a great teacher.  Some SAP Business One customers have been running the software for over a decade..  The manner in which they architected and configured the system ten years ago might not be the way they would do it today.  The chart of accounts they designed back them is no longer adequate, so this is an appropriate time to change it.  Use  the knowledge gained about how SAP Business One works to reinvent and redeploy.  Did you know that since 2009 SAP Business One has added released seven new versions?  In just under a decade there have been 300+ new features function additions to SAP Business One.

My own estimates are that although many of these changes are behind the scenes efficiencies that 137 of these changes directly impact the user experience and that 30 of them are what I consider major modifications.  The chances are really excellent that some work-arounds can be eliminated.  Even some once believes imperative addons can be eliminated.
A 100% new Hana (B1H) system should be installed.  This again requires a strategic decision regarding on-premise or cloud deployment.  You should redeploy SAP Business One on this new platform taking full advantage of the new technology, along with feature and benefit enhancements delivered by SAP.  Perhaps even more importantly these users will leverage their experience to configure SAP Business One better than ever before.  Once everything is built, configured, integrated and fully tested in the new system, the last thing you do is copy over the existing data abse and start using the new fully transactional Hana version of SAP Business One.  Here us what to focus one:

  1. Fix what’s wrong with your current configurations
  2. Make it better
  3. Leverage your SAP Business One experience
  4. No rush – Just get it right
  5. Insure lots of user acceptance testing
  6. Reduce Addons if possible
  7. Take advantage of B1H features and benefits
  8. Take advantage of SAP Business One new features
  9. Make Hana required edit to Queries, Reports, Formatted Searches
  10. Insure required addons work 100% in Hana
  11. Update integration (like EDI ) to the Hana Service Layer

SAP Business One Version For SAP Hana


You may be asking the question, “Why should I stay with SAP Business One?  Maybe I should shop other solutions, after all it’s been a decade already.”  Keep in mind, you already own some of the best software in the world.  Did you know that Gartner had reported SAP Business One as a Front Runner for manufacturing Software in 2017?  As an SAP Business One customer you already own and know how to use what many people believe to be the very best of the very best.  That is value you can’t easily replace.  However many years it has been since you made the decision to purchase SAP Business One, you made a great decision.  I recommend you stick with it.

The fact that you already own the software licenses is also no small matter.  If you were to go shopping for a new solution you would find that the cost of deploying a new solution would be far greater that the transition to Hana from MS SQL.  You would also lose all the leverage made possible by way of the experience your organization has gained about SAP Business One.  Experientially you would be starting over at ground zero.  The numbers below are nothing more than estimates but give you an idea regarding the value of owning the SAP Business One software. They are intended to help you understand the value of your current software.   If you were to choose to go out an shop for a new solution you could expect to pay at least twice (maybe 3-4 times more) than the cost to transition to Hana:

Transition To SAP Hana Cost

*These estimates should in no way be used as an official cost estimate for your transition project. Make sure you get an individual offer. 

So, given the fact that you already own some of the very best software in the entire world, and that SAP will continue to help their customers take the lead, you are in a great place.

You just need to get on with it.  Start planning your transition to Hana today.  Reach out to your SAP Business One Partner and start planning –  the time is now!


Vision 33

About the author

Carl Lewis, Vision 33

Carl Lewis is the Chief SAP Business One Ambassador for Vision33, the global leading SAP Business One Partner, and the primary author of the recent SAP Business One : Business User Guide published by SAP Press in December of 2016. In 2010 he founded the ASUG SAP Business One Summit, which this year transitions to the Biz.One Conference. One of the most prolific educational resources for SAP Business One, he has hosted over 600 YouTube videos about the software in the past 7 years. Few people have impacted the SAP Business One community on this scale.


Click here to post a comment

  • A great question regarding “server costs” from my friend Richard Duffy. In my experience most of my HANA users are deployed in a private cloud environment. Although there might be a on-time setup fee of perhaps 1,000.00 US Dollars, the round number for an estimate is 100.00 per month per user. It is possible to decrease or increase the per user
    Costs depending on numbers of users and other strategic decisions.

    Keep in mind this is private cloud and the software licenses are previously purchased in a traditional manner. SAP now offers a true cloud version of SAP Business One and this new paradigm offers new pricing implications.

    Something for everyone.



  • Hi Carl,

    A good review of the status of the SQL vs HANA play.

    I am not seeing where you have factored in the cost of replacing the hardware that the SQL Server is running on with an SAP Certified Server to run HANA…this is in many cases a big component of the cost structure as well that is missing from your costings…any thoughts what this would be?

Sign up for e3zine´s biweekly newsbites

Please do not use administrative mail adresses like "noreply@..", "admin@.." or similar as these may get blocked for security reasons.

We use rapidmail for dispatching our newsletter. By signing up, you agree that the data you have entered will be transmitted to rapidmail. Please take note of their terms and conditions and privacy policy.termsandconditions.

Our Authors