Is it possible to integrate data into Dynamics GP when no eConnect Schema is available ! Yes, In-Transit Case Study
Despite the fact that it might be quite rare, but there are certain cases in which you need to integrate data into Dynamics GP with no eConnect schema available to accomplish such requirement. The challenge is to fulfill such requirements when it is business critical and might definitely be the bottleneck of a complete data integration.
At SIROCo, we have recently been working on an integration project. The client receives an invoice through email including the shipment details including the quantities, cost, landed cost, item number and all the associated important details. They used to do manual entry which required not less than a day to get data into GP which was absolutely time-consuming and inaccurate. Afterwards, they have looked for some in-house development in order to automate the process and the result was not much satisfying (less than a day, but still requires human interactions and not less than four hours of work). The developers used Excel and VBA code in order to get the data into SQL … and then manipulate the data into GP through SQL procedures.
– In-Transit Integration
The end result which we’ve thought of is to have the excel file saved in a specific folder, and then run the Smart Connect Map which will handle the whole integration. Although all went well, starting from the excel import into GP to the receiving transaction entry integration, the challenge was to create the In-Transit Integration.
You still need to be a Microsoft Dynamics GP expert to use Node Builder and have a good understanding of the table structure and the business rules from the front end. You do not need the ability to write code, however, it helps to think like a programmer without being one.”