So far this journey with SAP has been interesting, the B1 API is flexible enough that we can mold it to pull data our of SAP somewhat “cleanly”. Pushing data back to it is even more fun, but as long as you create compliant XML data it usually is happy and consumes the data with little complaints.
So to recap we interface with SAP (B1 API) over the web, snag the XML document parse the XML document using HappyMapper which digest the document pretty quickly (even if its 50,000+ records) and then dumps the data into our local database for speed and ease of use on the web.
How has this experience been so far -> enjoyable to a point and at times stressful (which is how programming can be at times). One of the fun things with SAP is that EVERY installation is different. Since SAP is plugged into a client’s environment and then modified to meet the clients needs and during this process this creates a challenge when dealing with multiple installations at different clients. Its the Square Peg being shoved into a round hole issue, it can work with some force but is it the best solution?
If your company is in need of SAP integration for an upcoming web project feel free to contact us.