JD Edwards, Peoplesoft, and Oracle E-Business Suite SYNC

JD Edwards EnterpriseOne (E1) Integration with Salesforce via Commercient SYNC

We were referred to Commercient by our implementation partner, Summit Technologies. We were in need of a middleware-type solution that would allow us to pass large amounts of data from our ERP (JD Edwards EnterpriseOne (E1)) to Salesforce. We had previously been using a more manual export/import process using DataLoader and a series of commands that “automated” this process. We were, however, plagued with errors that went unnoticed with no notification capabilities and constant monitoring and correcting. Various searches on the Salesforce AppExchange and elsewhere did not reveal any obvious/out-of-the-box API-type integration options for E1 to Salesforce. It was at this time that Summit Technologies referred us to Commercient with the intention of using their SYNC tool to connect E1 and Salesforce. SYNC, we were told, was capable of connecting a wide range of ERP and accounting-type systems to CRMs, one of the most popular being Salesforce. Commercient did indeed deliver on this front. We are bringing over a massive amount of data as accounts, sales orders, and products. Commercient was very patient with us as we worked through our desired outcomes and the best path to achieve them. Specifically, the Commercient representative we worked with was very diligent in learning more about the JDE E1 back-end tables to help determine how E1’s data is structured and how it should be loaded. Post Go-Live, Commercient has been very responsive to any inquiries and/or issues we have encountered and quickly resolved them. Overall, the Commercient SYNC solution has saved us a lot of time and improved our success rate in getting the needed data into Salesforce. Though implementation was no doubt complex and required a lot of communication and trust between our team and theirs, the results have been well worth it.

JDEdwards integration using Commercient Sync

We engaged Commercient for their Sync capability to support our JD Edwards system. We utilized Sync to synchronize Account, Sales, and Product records to Salesforce. We also use their feature that supports exporting records that can be imported into JDE. They synch from JDE to Salesforce is a managed package. You work with Commercient to define exactly what data you want brought into Salesforce via a query definition. These records are then created and maintained in Salesforce. The export is somewhat more complicated to design, but the interface once built is straight forward creating export CSV files from Salesforce that can be used for importing into the JD Edwards system via additional software development on the JDE system. We created Account and Quote exports for our system. I don't want to downplay the complexity in some of these design integration activities, but Commercient was a great partner who worked patiently with us to get our system functioning properly. Once you have both sets of these features setup you have the technical basis needed to support 2 way round trip synchronization between these systems.