There are third party B1 integration tools available on the ISV market but before you take that direction we would like you to review the options available in native modules and coding tools. SAP B1 SDK will definitely do the job but you need reasonably experienced programmer.
Plus in the future version updates SDK related code should be reviewed on the subject of compatibility with the new version and patch and recompiled. Data Transfer Workbench on the other hand is reasonably version neutral and this is why we will try to present it first and then move on to SDK. And before we go to details section we would like to mention typical scenarios where custom integration is needed. These are various cases where you are sending in-house developed ecommerce shopping cart to Sales Invoice, EDI (Electronic Document Interchange) files upload, Custom MySQL, Microsoft Access or Oracle database applications interaction with B1 documents (typically Sales Orders and Invoices) and master records (most likely Business Partners and their Addresses). Let’s now begin with DTW dedicated paragraph:
1. Data Transfer Workbench is often associated with initial data migration via preparing so-called CSV template files. Most of the certified SAP BO consultants should be familiar and ready to do that type of initial data cleansing and migration. Ongoing data import is likely to be not feasible if it requires CSV file export from your external database. However Workbench has also ODBC connection option where you can imitate CSV template file format in SQL View. This View could be even cross platform joining tables from MS SQL Server and non-Microsoft database Oracle or MySQL for example. There are some shifts in MS SQL Server 2008 and 2005 on 64 bit Windows where Linked Server or Open Row Set SQL commands are deemphasized and SQL Server Integration Services packages are recommended. If you got similar issues you could consider scheduled data feeding from your external database into custom SQL Server tables and the view could be based on these tables. CSV file structure limitation requires the view to have its first row contain column names. Workbench is free tool assuming that you own B1 software licenses required for Server deployment. In order to create SQL View you should have SQL DBA in staff or somebody who is certified in SQL Server. There is no need in expensive consulting hours budget as all you need is concept explanation and technical training to create the first ongoing integration in DTW
2. SAP Business One SDK software development. If you are doing Microsoft Visual Studio coding projects then you should have BO client interface installed on the same workstation or server. Software Development Kit has code samples in C# or VB.Net and this enables programming by example concept. SDK libraries could be included into ecommerce web application enabling real time shopping cart integration triggered by customer credit card payment approval event. SDK might look like very open and friendly to even beginning developer but it actually requires exposure and expertise to business processes and objects interactions. SAP requires SDK certification from its resellers to be able to offer SDK programming services. We do not recommend the way to expose your internal programmer to relatively long learning curve and rather contract SB1 technical consulting firm with proven records in Software Development Kit programming and certification
3. What is not recommended? Business One is three tier Small Business ERP application and whatever is recorded in the SQL database should be done via application server. There is temptation to try direct SQL Insert or Update statement especially if you have enthusiastic SQL programmer in IT department staff. Watch Dog service if running should report such activity directly to SAP but even if you shut down this service the chances are high that you compromise data integrity via direct SQL data feed
4. 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
Dexterity Customization for Dynamics GP Evaluation Level Paper
When you are developer it is always a good idea to read technical manuals. But if you was just assigned to the IT team to decide if Dexterity is the right tool to customize your ERP application then first you need something which is in style of ‘easy reading papers’ or FAQ
Planning Dynamics GP Customization in Large Corporation
If you are reading this page then chances are high that you were not able to find ISV add-on and need customization project. Let’s talk about planning, quality assurance and future event such as version updates.
Dynamics GP Invoice Logo Attributed to Specific Company or Crossing the Borders of Three SOP Forms
Initial Great Plains Dynamics architecture had three SOP Invoice forms: Long, Short and Blank. Modern GP is popular in scenarios where you have more than three companies under one business entity umbrella
