Skip navigation

Between 2009 and 2013 I had the opportunity to build a lot of videos designed to introduce the various functional capabilities of SAP Business One - I started when Version 8.8 was the current release and continued through until Version 9.x.

 

In that time, I built quite a lot of content covering the majority of  functions in SAP Business One and over time, I got a lot of feedback that the videos were helpful not only for learning about B1 when deciding if the solution was the right one but partners and SAP Business One users all around the world used the videos to help them learn SAP Business One and deploy the solution.

 

So that's why in a lot of these videos, I refer to myself as a member of the SAP Business One Global team...

 

 

SAP Business One Video Content Central

iStock-186581431.jpg

So now that I am here helping out the ASUG team with the SAP Business One Community, we thought it would be a great idea to bring all these videos in and centralise them into a single access point - that's the purpose of this page - over time all of the various videos I have built will be indexed and catalogued here for you so that you can use them as a resource to find the answers you need and the guidance on using and deploying the solution.

 

 

A quick point to note, even though some of these videos go back as far as Version 8.8 they are all still relevant - in fact in many instances the functionality is exactly the same, only the look and feel of the Business One menus and cockpits have changed as well as some background plumbing that of course made the solution more robust and faster.

 

So there's a very strong chance that even though the "skin" of B1 may look different these videos will still apply - so we hope you enjoy having access to these and of course, give me your feedback if theres a topic that is missing - if its not on the drawing board to produce already i'll see what I can do to get it there for you!

Video TitleVideo Link
Quick Synopsis
Date Published
General Topics
SAP Business One IntroductionIntroducing SAP Business One

A quick introduction to the background of SAP Business One

and the overall solution

SAP Business One CloudSAP Business One CloudAn introduction to SAP Business One Cloud using Ericom Connect as the web client
SAP Business One Workflow and ApprovalsSAP Business One Solution - Workflow, Approvals, & AdministrationAn overview of the Workflow and Approvals features of SAP Business One
SAP Business One AlertsSAP Business One Alerts Functionality (Overview Video) Alerts are now standard in most solutions - here's how it works in B1
SAP Business One AuthorisationsSAP Business One Authorization Functionality (Overview Video) Limiting access to functionality is a key requirement for many businesses and this video explains how
CRM Topics
SAP Business One Campaign ManagementSAP Business One - Campaign Management An underappreciated area in SAP Business One - build marketing lists and execute campaigns via B1 or external tools
SAP Business One Service ManagementSAP Business One Solution Service Management Service management is about more than just servicing equipment - if you have customers you can use this module
SAP Business One Sales Opportunity ManagementSales Opportunity Management Why buy Salesforce when you have Sales Opportunity Management inside SAP Business One?
Logistics and Production Topics
SAP Business One MRPSAP Business One Solution - Material Requirements Planning (MRP)MRP can be complex and hard to understand - but in SAP Business One its straight forwards once you get the basics
SAP Business One InventorySAP Business One Solution Inventory Management More than 60% of all SAP Business One customers buy and/or sell inventory so its a key component of the solution - heres the basics

SAP Business One Light Manufacturing

SAP Business One Production Management A growing function in SAP Business One, this video looks at the basics of the manufacturing functions in B1
SAP Business One InvoicingSAP Business One Automated Invoice Management (Overview Video)
SAP HANA Topics
SAP Business One HANA
SAP Business One Analytics powered by SAP HANA

SAP Business One HANA: Interactive Analysis

SAP HANA Studio

SAP Business One HANA: Dashboard 1
SAP Business One HANA: Dashboard 2

SAP Business One HANA: Dashboard 3

Purchasing Topics
SAP Business One Purchasing Management
SAP Business One Purchase Request
Finance Topics
SAP Business One Finance OverviewSAP Business One Financials Module (Overview Video)Almost every transaction ends up in the Finance module - this overview video explains the components of the module
SAP Business One BankingSAP Business One Solution Banking Management (Overview Video)Managing and recording cash and banking transactions is critical for all businesses - we'll take a look at the functions in SAP Business One
Reporting Topics
An overview of SAP Business One ReportingSAP Business One Solution Reporting Management (Overview Video)Reporting is always a hot topic for any ERP solution. Here's the core of reporting in SAP Business One
SAP Lumira: BI for SAP Business OneSAP Lumira (Overview Video)SAP Lumira allows you to prepare and visualize your SAP Business One data


And more...

 

Here is a list of other videos that we will add into the matrix above with more details:

 

iStock-623273520.jpg

Often times you need to track different activities in SAP Business One, manage KPI's or generate ad-hoc data sets for further analysis. The SAP Business One Query Tools are great to do this but sometimes it can take a while to master the process of building queries and understanding the different concepts of table joins asnd also the data structures in SAP Business One.

 

This is where the assistance of your peers can be invaluable to help you understand how something is achieved. If you are like me, when you are trying to understand how a technology works it's helpful to have examples to refer to and its even better when those examples can be leveraged in day to day operations of the solution.

 

 

Fortunately I found a recent scenario on the Facebook group I moderate ehre a member of the group wanted to find out  which suppliers were late with their deliveries and two other members stepped up and provided the necessary queries to assist and they agreed to share them with you here.

 

 

Heres the first that shows the deliveries that were late written by John Eduardo Alfaro Vivanco from Cartagena in Bolivia

 

 

SELECT A.DocEntry , A.DocNum , C.DocDueDate AS FechaEntrega , A.DocDate
FROM OPDN A INNER JOIN PDN1 B ON A.DocEntry = B.DocEntry
INNER JOIN OPOR C ON B.BaseEntry = C.DocEntry

WHERE A.DocDate > C.DocDueDate
GROUP BY A.DocEntry , A.DocNum , C.DocDueDate , A.DocDate

 

And another variation that shows deliveries not yet received that are running late written by Joerg Aldinger from SAP Business One partner Consultoria in the Dominican Republic

 

SELECT T0."DocNum", T0."CardCode", T0."CardName", T0."DocDate", T0."DocDueDate" FROM OPOR T0 WHERE T0."DocDueDate" < CURRENT_DATE AND T0."DocStatus" = 'O'


For MS SQL instead of HANA exchange the string CURRENT_DATE for GETDATE()..

 

Thanks to both John and Joerg for their willingness to share their work.

One of the core challenges that many organisations face is managing their SAP Business One implementation in a cost effective and time efficient manner.

SAP are continuing to focus on this area and I will talk more about that in my upcoming webinar on the SAP Business One Roadmap and you'll see this as we drill down in to the new 9.3 release.

I wrote a couple of LinkedIn posts on the SAP Business One Cloud Control Center and I got the feedback that people would like some detailed training on how to deploy the technologies behind that and so I have gone down that path and built the sessions (and continue to do so).

So here are the sessions that I have built and I would encourage you to come along to my Moving to the Cloud session at the upcoming Biz.ONE Conference to learn more about how you can continue to leverage these technologies.

iStock-848533082.jpg
Session 1Session 2

For many small businesses, the deployment of an ERP system is done in response to a specific set of challenges that exist in the business at a given point in time.

 

With the problem solved, they then move on to other pressing issues but in my experience there is a big opportunity that is going begging and that is around the concept of what the Japanese call Kaizen - constant improvement.

iStock-584860400.jpg

A great approach is to stop and review what has been achieved as the result of deploying SAP Business One and what are the other ways that you can utilise the solution to help drive efficiency in your business.

 

 

Often times, it's an area that you may not want go to as there's a concern that there will be additional money that needs to be spent on licenses and consulting services and of course, thats an option and you'll do a cost-benefit analysis to determine if it makes sense but there are many ways that you can potentially utilise your existing investments to greater effect.

 

 

A big area is the under-utilisation of the CRM and sales force automation capabilities of the solution - quite a few organisations have gone out to market looking for a best of breed CRM solution to plug in to their SAP Business One solution because they may not have really mapped out what they are looking to achieve and end up focusing on the tools that are available and what they claim they can do.

 

 

 

Many times, particularly with organisations that deploy Salesforce as an example, they end up only using 25% of the available functionality - and apart from some of the benefits of the web and mobile UI of Salesforce, the functionality that gets deployed is already existent inside SAP Business One.

 

This coming November, we are going to have a focus month where we'll deliver a few sessions and a focused webinar designed to specifically help you build  your strategy and systems alignment plans for 2018 so mark your diary to attend the sessions and if you're heading to the upcoming Biz.ONE conference in Anaheim, make sure you plan to attend my 2 sessions on moving to the cloud and reporting as both of these sessions will align to this concept of mapping your systems, strategy, skills and staff to drive better business outcomes.

 

 

I am a big fan of the McKinsey 7S Model for business planning and alignment of strategy and tactics - we used it at Great Plains Software in the 90's and the approach helped to contribute to the exponential growth of the company and the team's ability to adapt to and drive that growth - so I would encourage you to take a look at this document that talks in more detail about the model - I'll be referring to this quite a lot as we discuss this process and its a good primer to focus your thoughts and start the 2018 planning process.

Basic Training - But without the yelling, mud and pain!!
iStock-657428672.png

As previously announced, one of the benefits of your ASUG membership is access to all the new content that we are building including our series of 15 Minute Fundamentals sessions, offering basic training sessions for SAP Business One users.

 

These are primarily focused on new users, but should also be helpful to experienced users if you need a quick reminder of how the core functionality in the solution works.

 

Bookmark this page,  because as the sessions are published they will be added on to this page so you have a single place to go to get access to all the sessions grouped according to the functional area.

 

If you have any questions or would like to see a session done on a particular topic in more detail, remember to ask your questions in the Q&A forum of our community site.

Introductory Sessions for all users

 

 

Session Title

Video LinkSummaryDate Published
User Interface and Navigation - Part 1SAP Business One 15 Minute Fundamentals - User Interface, Cockpit and Navigation- Part 1In this session you'll get an introduction to the basics of navigation and working with the SAP Business One User InterfaceAugust 25th 2017
User Interface and Navigation - Part 2SAP Business One 15 Minute Fundamentals - User Interface, Cockpit and Navigation - Part 2In this session we'll continue the introduction to the basics of navigation and working with the SAP Business One User InterfaceSeptember 1st 2017
Reporting BasicsSAP Business One - 15 Minute Fundamentals - Reporting BasicsIn this session you'll get an introduction to the basics of accessing, running and editing reports with the SAP Business One Print Layout designer and we'll touch briefly on Crystal Reports.September 8th 2017
Business PartnersSAP Business One - 15 Minute Fundamentals - Business PartnersBusiness partners are one of the core building blocks of your SAP Business One solution and in this session we'll look at the process of creating and maintaining themOctober 31st 2017
Sales QuotesSAP Business One -15 Minute Fundamentals - The Sales Process - Part 1In this session we'll look at the Sales Quotation Process and using and tweaking the User Interface in all the sales screensSeptember 26th 2017
Sales Quotes to Sales OrdersSAP Business One 15 Minute Fundamentals - The Sales Process - Part 2In this session we'll finish the Sales Quotation Process and start to look at the Sales Order ProcessSeptember 27th 2017
Sales Orders - DetailedSAP Business One 15 Minute Fundamentals - Sales OrdersYou'll find a slightly more detailed look at the Sales Order process where we start from the Sales Order and not from a Sales QuoteOctober 9th 2017
Delivery and a quick look at the Pick and Pack ManagerSAP Business One - 15 Minute Fundamentals - Delivery Process and the Pick/Pack ManagerIn this session we'll push the Sales Orders in to the Delivery Process, look at the Document Generation Wizard and the Pick and Pack managerOctober 9th 2017
Inventory Master DataSAP Business One -15 Minute Fundamentals - Inventory Master File BasicsIn this session on Inventory Management we'll look at the basic block of Inventory - the Item master fileNovember 12th 2017
iStock-639820888.jpg

Often times, it seems like people in the SAP world use a completely different language, full of esoteric and important sounding acronyms like ABAP, iDocs, FICO, PLM and others.

 

 

In fact when I was at SAP I often heard it referred to as SAPanese.

 

 

But when someone uses it on you, it's no laughing matter as its usually as part of an explanation on how to solve a problem and your stress levels are already high enough with people adding to it.

 

 

So as time progresses I will try to explain some of these that you may encounter as an SAP Business One user to help clear the confusion and give you something to talk about at parties.

 

 

So, many of the systems and portals at SAP are locked down so that only Authorised users can access them.

 

 

 

The codes that are provided can be a number of different ones - for example if you are an SAP employee in Germany, you are given a D-number, International employees get I-numbers, contractors get C-numbers and customers and partners get S-numbers.

 

If you need to access the SAP Help Portal and many of the Customer only documents, you'll need an S number and the place to go to get that is your partner - as an SAP customer you are entitled to access these resources (don't let anyone tell you differently) as long as you are current on your SAP annual maintenance.

 

Once you have an S-number you can access the areas that SAP have determined are appropriate for you as an SAP Business One customer including the software downloads area.

 

To make it easier you can also apply for an SAP Passport which is a digital certificate that you can install in your browser and use instead of remebering your S-number and password.

 

I'll cover that process in another blog shortly - oh and by the way I was only joking about talking SAPanese at parties - unless its an ASUG party, if you do it you'll most probably not get invited back  

iStock-540109164.jpg

On August 28, 2017, SAP announced that the Early Adopter Care Program for SAP Business One 9.3 (both on SAP HANA and MS SQL) has started.

 

 

Submit your nominations for the Early Adopter Care program via your partner or via this link

 


SAP's recommendation is that you should participate in the Early Adopter Care program if you plan to implement SAP Business One 9.3 or SAP Business One 9.3, version for SAP HANA in a productive environment.

 

As has been the case with previous Early Adopter releases you will benefit from accelerated problem resolution and special attention from SAP.

 

 

 


What can you expect with release 9.3?

  • With core expansion, SAP Business One will support new business processes and round out key areas such as:
       - simple production routing,
       - return merchandise authorization management (RMA),
       - project management updates,
       - simplifying and streamlining CRM processes,
       - authorization management,
       - price list enhancements.
  • Leveraging the SAP HANA platform and building on the semantic layer, SAP plan to offer new cockpit templates. With a new analytics portal, end users will be able to schedule and consume reports without the need to log into SAP Business One.
  • With add-on solutions playing a key role in shaping the SAP Business One solution, SAP have also announced plans to make it easier for partners (and customers) to develop add-ons with the support of XML methods for user defined tables and the latest visual studio 2015 suite.
  • Deployment and management of SAP Business One will be simplified with a centralized approach. SSO will be utilized for apps for SAP Business One, version for SAP HANA making partner and self developed add-ons easier to manage and consume.
  • SAP have also re-committed to continuing to focus on building for optimal performance, making SAP Business One 9.3 more stable and easier to support.

You can learn more in the ASUG upcoming webinars focusing on the SAP Business One Product Roadmap and the 9.3 In Focus sessions due shortly as well as reviewing the 15 minute fundamentals sessions built using SAP Business One 9.3
Note: All enhancements mentioned are subject to change Software Download & Technical Prerequisites
For SAP Business One 9.3, version for SAP HANA, ensure that the following components are installed on the Linux server:
  • Operating System: SUSE Linux Enterprise Server (SLES): 11 SP3, 11 SP4, 12 SP1
  • SAP HANA Platform Edition: 1.0 SPS 12 Revision 122.05

For SAP Business One 9.3, install one of the following Microsoft SQL Server versions:
  • Microsoft SQL Server 2012
  • Microsoft SQL Server 2014
  • Microsoft SQL Server 2016

 

Please refer to the Administrator’s guide for SAP Business One 9.3  and the Administrator’s guide for SAP Business One 9.3, version for SAP HANA in this recent blog post -
Get a Jump Start on deploying SAP Business One 9.3 with the Administrators Guide .

Note
: SAP Business One 9.3 is delivered together with remote support platform 3.2, which must be installed if you wish to avail from support services such as GoToAssist.
iStock-639198068.jpg

Integration tools are a critical component of most ERP solutions - in fact, as the functionality to automate the business processes inside your organisation become commonplace in most solutions there are really only a few remaining areas where products can differentiate themselves.

Some integration tools are designed to be used by your existing end users and in SAP Business One these are tools like the Query Designer, Formatted search and the Data Transfer Workbench or DTW.

Other tools require a greater level of technical skill and capability such as the DI-API (Data Interface Application Programming Interface) which enables you to write your own software with tools like Microsoft Visual Studio and languages such as Java but these are definitely tools for the experienced programmer.

Other tools exist such as the SAP Business One Integration Framework which is designed to enable consultants and experience technical users to build workflow based integrations between SAP Business One and a number of other solutions - these are commonly referred to in integration scenarios as "endpoints".

 

But how do you learn these tools without spending large sums of money to gain the pre-requisite knowledge to make them work their magic?

 

Well, for some time SAP have been publishing courses on their HANA technology on their Open Learning site at open.sap.com - now the very first SAP Business One related course has been published and its focused on the SAP Business One Integration Framework and its a free course available to anyone that wants to sign up.

 

You can find it at https://open.sap.com/courses/ifb1 and its a great place to learn about the technology and how to apply it.

 

Of course you'll need some pre-requisite skills and for this course they are :

  • General understanding of IT
  • Basic knowledge of SQL
  • Knowledge of XML/XSLT
  • And of course, SAP Business One knowledge is useful

 

The course runs over a 5 week period and requires you to attend 4 hours of course content each week so its not overwhelmingly time consuming and you'll need access to an SAP Business One deployment with the B1if components installed.

 

Take a look at the course, learn the Integration Framework and then go out and apply your new skills to build an even better SAP Business deployment for your organisation - its free and the functionality is robust and that makes it a great tool to use.

iStock-474293523.jpg

At the upcoming BizONE Conference in Anaheim, I will be presenting a workshop entitled Taking your SAP Business One deployment to the Cloud - Why the discussion should not be if but when and how

 

We'll be covering a number of SAP Business One specific topics relating to utilising the cloud as part of your deployment as well as looking at various technology options but this session isn't a sales pitch.

 

 

It will be your opportunity to understand the different factors that will impact on your business and whether or not cloud computing will be a part of your IT mix.

 

 

As a hands on session, you should also come along prepared to do some work - I'll be leading you through a couple of exercises (mental not physical) that will help you build your business strategy and determined when you should move to the cloud, what components you'll put in the cloud and what cloud models are best for you.

 

 

To get you started - here's a nice little explainer video from the team at Common Craft on cloud computing that will help you get the basics straight in preparation to dive deeper at the Conference as well as a preview of what we'll cover at the Conference

 

 

 

A Cloud Computing Primer from Creative CommonsTaking your SAP Business One deployment to the Cloud - BizONE Conference Session Preview

The onboarding process in many organisations is a well structured process where you are led through all the things you need to know in order get productive in your new role as quickly as possible.

 

However when it comes to learning the business applications that are in place, often times it can be a challenge to get to know the basics and find someone with the time to take you through the fundamentals of using those systems.

 

As a member of ASUG, you are in luck though if you are using SAP Business One as we will be delivering a complete set of sessions delivered in 15 minute blocks covering the fundamentals of SAP Business One from system navigation to journal entries - from sales order processing to reporting with the Print Layout Designer and Crystal Reports Basics.

 

These sessions will be called (funnily enough) 15 Minute Fundamentals and we'll be delivering these over an extended period of time starting this Friday and every Friday until we have delivered a complete set.

 

Of course, remember that you can also ask any questions about using SAP Business One in the Q and A Forum and I'll endeavour to answer them as quickly as possible.

iStock-621371400.jpg

You can learn more by watching this introductory video

*but were too afraid to ask

iStock-530562263.jpg

Whilst it's not the most exciting topic to discuss, it's still an important one and warrants regular updating to make sure that you are keeping on top of your obligations and staying compliant with your software licensing requirements.

 

 

Many organisations that find themselves in violation of the licensing agreements don't do it deliberately, in most cases its a sin of omission, not commission. The responsible people inside the company aren't always up to date with what licenses they have, who is using them and what the rules are.

 

Thats one of the reasons why I like the new Licensing Guide that SAP have published for SAP Business One - it explains not only the basis of licensing (the named user concept) but also the process for auditing usage, acceptable use and the the license management process.

 

 

A common complaint in the past was that SAP Business One documentation wasnt always easy to understand nor was it complete...from what I have seen already SAP Business One 9.3 is definitely fixing that challenge.

 

 

Here's the 9.3 Licensing Guides for HANA and SQL - they do refer to earlier versions and when some changes were implemented to the licensing model but as always, if you have any doubts about the status of your licensing, check with your partner and if you have any questions, feel free to ask here on the SAP Business One Community area on the ASUG site...I'll be happy to help!

 

 

 

License Guide for SAP Business One 9.3, version for SAP HANA

License Guide for SAP Business One 9.3 (SQL)

HANA – High-Performance Analytic Appliance is the official four letter acronym translation but these days it can be a little bit of a misnomer as SAP are positioning HANA as a more of a platform than just a database server, particularly when it comes to SAP Business One.

 

Delivering transaction processing and analytics already in the core SAP Business One version for SAP HANA product, there’s a lot more to the HANA story than meets the eye these days.

 

SAP technical evangelists (also called Solution Architects) spend a lot of their time showing partners how to start building new applications on top of the SAP HANA architecture using a component called the Service Layer, which is a way of describing the data and transactions and providing a number of industry standard ways to integrate with SAP Business One as I mentioned in part one of this article.

HANAvSQL.jpg

 

 

There are a few examples of partners doing this today such as Achieve IT Solutions with their Resolv Logistics Suite of applications for SAP Business One and more will be coming to market as time progresses but for now the majority of solutions still utilise the DI-API (Data Interface Application Programming Interface) and they work just fine with SQL or HANA – even new solutions like Enterpryze that delivers mobility and a simplified web client for SAP Business One

 

But for many folks the primary driver to deploy on HANA will come down to the availability of the Analytics components of SAP Business One built to take advantage of HANA.

 

Tools like Pervasive Analytics, in many respects, negates the need to go out to look for additional tools for building KPI dashboards and visualising their data – particularly for those users that have been provisioned with an SAP Business One license as they can consume these directly from inside the SAP Business One client. Plus there are a number of features that need the HANA speed and data crunching capabilities to really work like the Cash Flow Forecast and the Customer 360 view (video below) as well as the Enterprise Search facility.

 

However, for those who require read only data access to SAP Business One, you’ll still require a full/limited SAP Business One user license as the Indirect Add-On Access user only allows for external app use and doesn’t permit use of the SAP Business One client – a major drawback for those users that want to consume the analytical views provided with SAP Business One or built using the Pervasive Analytics tools.

 

I spent a lot of time reading and studying SAP licensing documents and agreements and when using the heavily discounted HANA runtime that is bundled with SAP Business One you definitely need the additional licenses to stay compliant with the SAP agreements you are subject to.

 

In addition, you'll need to invest some significant money into a HANA Server as well as the associated support and Linux O/S support you'll need to buy - the Linux operating system is free but you'll need to purchase support but those costs are coming down each quarter and soon SAP will be offering SAP Business One in the Cloud running on HANA on SAP hosted and managed infrastructure which will allow you to take the solution on a pay as you go model (subscription pricing).

 

But there are other advantages of SAP HANA that many people are just beginning to wrap their heads around as the SAP channel and ecosystem becomes more familiar with the Service Layer and what can be done.

 

Take a look at this example of integrating Amazon Alexa and SAP Business One using the HANA Service Layer that was being shown recently at the SAP SMB Innovation Summits…it’s a little impractical as demonstrated but it is a great introduction to what can be imagined with the new tools.

So in summary, for my money, if you need to process large amounts of data or transactions, you don’t want to venture outside the standard SAP delivered Analytics or you have a compelling business need for one of the new applications built on the HANA Service Layer then HANA makes sense but if dollars are tight and data access for everyone is critical from external applications then SQL Server may be a great fit and will deliver all you need to have a great SAP Business One deployment.

 

In case you missed it, here's Part1:SAP Business One - HANA vs Microsoft SQL: Understanding the differences and making the right choice

A little bit of SAP Business One History (for context)

When SAP Business One was first built in Israel in the mid 90’s as a product for the Mac OS called OCEK (Practitioner in English) it was designed to run on a database called Codebase 5.0.

 

(By the way, this is the reason that most of the Database files in SAP Business One start with O (OINV, OCRD, etc.) – you can learn more about the History of SAP Business One in this excellent series of posts from Ilan Tal)

 

In the late 90’s the product was moved to Windows and SQL Server was adopted as the database platform for Windows but was still available on the Mac on Codebase.

 

Market forces spoke and the product moved to Windows only and SQL Server and that was the platform that SAP acquired the product on and this continued to be the only database platform for many years until the release of SAP HANA back in 2011.

HANAvSQL.jpg

 

SAP Business One first adopted HANA as the database for running a new generation of analytics with – the product was called SAP Business One Analytics for SAP HANA or B1A and it was based on the replication of data from SQL Server to HANA and a set of dashboards built on the HANA data structures because it was possible to do more and built optimised data structures with large data sets because of the way that HANA stored the data and the fact that all the data was compressed and stored in volatile RAM which made accessing and manipulating the data lightning fast.

 

And then as HANA improved over time the transaction processing was also moved across to the in-memory platform.

This allowed for 2 scenarios, a single database for both transactions and analytics and the ability to handle even larger volumes of transactions with the core SAP Business One applications.

 

Fast forward to 2016 and SAP released what is known as the HANA Service layer for SAP Business One – this is a new way to integrate with SAP Business One using a new set of standards like OData which allows web services to communicate easily with SAP Business One transactions and allows developers to build new integrations with these newer standards.

 

So, that’s the history of SAP Business One as it relates to the database technologies but you are probably asking yourself, why would I want Hana or SQL server, should I move to HANA if I am already using Sap Business One and if I am a new user about to purchase SAP Business One, should I run on HANA or SQL?

 

So, putting aside any agendas or vendor preferences I want to share a few thoughts for you.

hana logo.jpeg

First of all its very clear that SAP would much rather have you running on SAP HANA rather than Microsoft SQL Server, even if just for economic reasons as you need to buy HANA from SAP whereas obviously Microsoft SQL Server generates revenue for Microsoft.

But if you are a smaller business there are good reasons to choose SQL Server over HANA and by the same token there are good reasons to choose HANA over SQL Server if your business has grown larger or has plans for rapid growth.

The main thing to bear in mind with HANA and SAP Business One is speed, if you are a smaller user running a small to medium size volume of transactions and not overly concerned about accessing the SAP Analytics that comes with SAP Business One for HANA, then it makes sense to go with SQL Server. It actually runs faster than HANA with smaller transaction loads and is much more cost effective.

 

 

You can acquire additional Business intelligence tools that work with SQL Server exceptionally well such as Power BI, SAP Lumira, the SAP Business Objects products or tools like QlikView that many SAP Business One partners have in their selection of products.

 

On the cockpit front, the SQL product comes with a set of SAP supplied cockpits and widgets which you cane extend and BoyumIT offer a great selection of dashboards and a dashboard builder as part of their product called B1UP Dashboards – also sold by almost every SAP Business One partner in business today.

The other big advantage of using SQL Server is the simplified licensing model that allows you to access the data with any one of these read only tools without having to purchase additional SAP Business One Add-On user licenses which the HANA solution requires – even to access the data in read only mode.

 

The tools and support resources for SAP Business One on SQL Server are also very broad and deep so should you encounter any technical challenges you can go to a number of sources for help – HANA is still relatively new and the skills are still expensive and a little hard to come by.

sql server.png

In the next post, I will look in detail at why SAP HANA makes sense for many businesses that are running SAP Business One today and into the future.

 

Don’t forget that if you have any questions, you can drop me a note here, start a discussion or post a comment on this post and I’ll endeavour to get back to you post haste!!

 

Part 2: SAP Business One - HANA vs Microsoft SQL: Understanding the differences and making the right choice

One of the most important documents that you'll need when managing your SAP Business One deployment is the Administrator's Guide.

 

 

It covers a lot of the key things you need to know when deploying the solution as well as system requirements and explanations of "under the hood" components of the solution.

 

 

The 9.3 Administrators Guide is no different and its packed full of good information - but remember, as 9.3 is in Early Adopter Program right now all the details are still subject to potential change

 

SQL Server:Administrator's Guide for SAP Business One 9.3 on MS SQL.pdf

HANA:Administrator's Guide for SAP Business One 9.3, version for SAP HANA.pdf

iStock-507804698.jpg