Programming SAP Business One or how to make it talk to External Application or Data File

Sep 15
07:47

2011

Andrew Karasev

Andrew Karasev

  • Share this article on Facebook
  • Share this article on Twitter
  • Share this article on Linkedin

Custom coding is typically done in Microsoft Visual Studio C# or VB projects where you are linking SDK libraries. Technically speaking you have to have SAP B1 user workstation installed on your development computer.

mediaimage

Software Development Kit has code samples,Programming SAP Business One or how to make it talk to External Application or Data File Articles objects and methods descriptions.  Code samples are in VB and C# and this is why we are recommending these programming languages however if you are comfortable to read code sample and translate them to your preferred language such as Delphi for example we do not see the problem.  Let’s take a look at generic customization and how it is typically designed:

1. User defined tables and fields in settings.  SAP BO is catching new trends in Small Business ERP and accounting software where you can modify existing tables by adding user defined fields.  Plus you can introduce new tables.  What is amazing and could be categorized as innovational is the fact that these user defined objects automatically receive user interface.  We recommend you to design custom tables and new user defined fields to existing tables and use these objects as the base for custom integration

2. Software Development Kit.  Now is the time to animate user defined objects with custom logic.  Modern days modifications are programmed by example and we recommend you to open SAP B1 SDK Help Center and review code samples, getting started, developer guide and customization tools

3. Programming cross platform integration.  In late 1990th the battle between Microsoft Windows and UNIX and such popular directions as Java, EJB, Linux was in full swing.  However with invention of XML and SOAP Web Services the difference was deemphasized and if you are generic programmer you should not probably be attached to one platform or programming language.  Think about creating web service from Windows 2008 hosting server and calling it from Linux box where you may have ecommerce portal hosted in MySQL

4. What is not recommended?  If you are experienced Microsoft SQL Server DBA and versatile with advanced level SQL Stored procedures and Insert statements we could respect the temptation to program integration directly via SQL data update or feed. This is not recommended as SB1 has three tiers architecture including application server responsible for interaction with database.  Better idea is to communicate with database via SDK methods.  If Watchdog service is running it will report direct DB intervention to SAP

5. Alternative to SDK.  It is possible to setup integration directly in Data Transfer Workbench either by filling CSV templates or imitating them via ODBC connection in SQL View.  DTW is very simple and straightforward migration tool which is typically deployed in initial data conversion.  ODBC option is a good chance for this tool to demonstrate itself on the ongoing integration market

6. Third party integration modules.  Each Corporate ERP platform is trying to keep ISV channel robust and friendly.  If you feel that your customization needs are not addressed feel free to search through that channel

7. Please call us 1-866-304-3265, 1-269-605-4904 (for international customers, where our representatives pick up the phone in Naperville and St. Joseph, MI call centers).  help@efaru.com.  We have local presence in Atlanta, Chicago, Southern California, South West Michigan, Houston and Dallas areas of Texas. We serve customers USA, Canada, Mexico and Brazil nationwide and internationally via web sessions and phone conferences (Skype is welcomed). Our consultants speak English, Spanish, Portuguese, Russian and Chinese.  One of our experiences is international Corporate ERP and Consolidated Financial reporting