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). 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
