Skip navigation


Integration with SAP Business One

Throughout 2018, our ONE.Source curriculum will explore monthly themes from across all perspectives of the SAP Business One ecosystem: Customers, Partners, SAP themselves, as well as our Community Evangelist.


In February, we will cover the SAP Integration tools that are at your disposal as well as a number of other tools to manage the flow of data and transactions between SAP Business one and other applications.


Your ERP solution is the backbone of your business operations and SAP Business One is a fully featured solution to build your business on. However, there are scenarios where you need to use other applications, maybe for Marketing Automation, EDI, warehouse management or just simple office productivity solutions like Office365 and so you need to integrate those systems together.


Integration used to be the biggest consumer of ERP project budgets however there are now new solutions available that make this process much more cost effective, easier to build and easier to deploy.


While this curriculum is primarily facilitated through a monthly webcast series, you can also expect regular blogs, videos, and (most importantly) community discussions on this topic. Visit the ONE.Source Activity feed to stay up-to-date on the latest, follow us on Linkedin or Twitter, or like us on Facebook.








It goes without saying that when you are building queries and reports that you need a good reference to the database structure of application and of course SAP Business One is no different.



There are a couple of ways to determine the database structure of SAP Business One but as I was doing my regular trawling around the internet looking for handy resources to share I happened to stumble across this little gem.



SAP Tables - SAP Business One/ERP Table Definitions



This site allows you to select the B1 version and gives you a breakdown of the tables and fields.



A great resource to pin to your Bookmarks Bar in my opinion.



i hope you agree


At the recent BizONE Conference in Anaheim, I had the opportunity to catch up with Rob Burke from McCroskey Mattress Company, a long time user of SAP Business One and we got to chatting about performance tuning SAP Business One on SQL Server and what were the basic things that should be done to keep your SQL Server running at its optimum.



In prior years you would need to set up a number of manual SQL Maintenance jobs to re index and compress the databases as a starting point, not to mention running the regular backups of the data.



The good news is that now, with the Remote Support Platform you can set up those tasks based on downloaded tasks that come in from SAP as well as a number of other repair and system validation checks.



Theres also a number of other things to look at with the setup of your SQL Server deployment that I wrote about a few (actually more than a few) years back so i thought I would post them here as Rob dropped me an email following up on our conversation yesterday.




So here's the links for you Rob and for anyone else that may find them well as some other blogs and contributions from others in the general B1 community



Rob also was asking about the impact of increasing the number of cores on their SQL Server and whether or not this would force them to generate a new license key.

This one is open to conjecture - my understanding is that if all you are doing is allocating more cores to SQL Server (from the SQL Management Console) then it wont impact it - the disabling of the license key when there are major changes was introduced to prevent moving from one machine to another so this shouldn't really have an impact.


But if it does, of course, you can generate a new license key immediately as long as you have an S number and access to the rights to generate a key, which your partner should have given you.


Here's a short video that shows you how to do it