Free Articles, Free Web Content, Reprint Articles
Thursday, March 21, 2019
Free Articles, Free Web Content, Reprint ArticlesRegisterAll CategoriesTop AuthorsSubmit Article (Article Submission)ContactSubscribe Free Articles, Free Web Content, Reprint Articles

SAP Business One Integration with External Database

There are tools available through ISV channel however in this small paper we would like to discuss native integration methods such as Data Transfer Workbench and Software Development Kit programming.

We do not pretend here to address this paper to programmers, it is rather for management team to get first exposure to integration methods and tools and initiate their own homework on the future data import project.† Letís begin with Data Transfer Workbench:

1.†DTW is often used as data conversion tool in initial implementation.† Simplest way to bring over master records and limited amount of historical data is to fill out so-called CSV templates.† This works fine in one time deal but CSV templates are difficult to fill out every time when you are doing ongoing data import.† However DTW has ODBC connection option where you have to imitate the same format as CSV file.† This usually is achieved in MS SQL Server View based on Union where you unionize selection statement with column names (text strings) and the second select statement containing real data from your external database table.† There is no need to mark records as imported as you may restrict the view to the records dated the last day or week.† SQL View could be cross platform if you are using Linked Server or Open Row Set constructions where for example you can join tables from MS SQL Server, MySQL or Oracle.† The easy option to launch such data migration is on demand in other words user should initiate DTW import.† We tried to schedule ODBC based import as it is described in user manual but it didnít work on earlier versions (2007A) and in time we got response from technical support that this method is not supported.† So far we had no chance yet to test it with version 8.81.† Letís now switch to Software Development Kit Programming

2.†SDK allows you to login and send documents into SAP B1 in programming projects.† The best results could be achieved if you are coding in C# or VB as here you can lean on code samples.† It is very popular in B2B and B2C ecommerce shopping cart integration scenarios were your ecommerce portal is custom and supported by internal software developers.† Software Development Kit has code sample where you are creating Sales Invoice with options customer deposit in the form of Credit Card payment.† As the topic of this paper is pretty generic we would like to share with you our SDK integration programming experience where consulting firm uses Microsoft CRM for time logging against contracts and when the case is closed it goes to SAP BO invoice via custom programmed integration.† Are there advantages of SDK coding over Data Transfer Workbench?† We think that SDK gives you the option of real time integration and plus it could be associated with such important real time features as Credit Card payment processing, external Inventory allocation and shipping initiation.† However SDK highlights might lead you to the conclusion that it is very simple and you can turn around and begin Software Development Kit programmer overnight.† In reality it requires professional dedication and commitment and SAP requires consulting firm offering SDK programming services to have certified developers in staff

3.†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).†† 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, PortugueseFeature Articles, Russian and Chinese.† One of our experiences is international Corporate ERP and Consolidated Financial reporting

Source: Free Articles from


Andrew Karasev is SAP Business One consultant and Great Plains Certified Master, MVP, MCSE and MSDBA, 1-866-304-3265, 1-269-605-4904. He is also the initiator of eFaru project and founder of Alba Spectrum information space

Home Repair
Home Business
Self Help

Page loaded in 0.184 seconds