Wednesday, December 11, 2013

SugarCRM Integration with JD Edwards: Never the twain shall meet?

“East is East and West is West and never the twain shall meet!” is the line most remembered from Rudyard Kipling’s Ballad of East and West. It is an apt metaphor for the syntactic dissonance between most enterprise software systems regardless of how well-crafted their APIs might be.   The Application Programming Interfaces (API) of SugarCRM and JD Edwards EnterpriseOne are based on very different technologies. While JD Edwards utilizes a Dynamic Java Connector to provide Business Functions (BSFN),SugarCRM offers Web Services in either sugarsoap or SugarREST formats based on the SOAP protocol and Representational State Transfer (REST) methods. But never the twain shall meet? I hardly think so.  Magic Software offers the Magic xpi Integration Platform to intermediate these and other APIs for optimal business process integration that is highly secure, reliable and scalable.

Magic xpi Integration Platform is well-known for its ability to deliver code-free, enterprise-grade integration, business process automation, and data synchronization. Special editions of Magic xpi Integration Platform are available for extending the capabilities of the most commonly used ERP and CRM systems including JD Edwards EnterpriseOne and SugarCRM.

Building on Magic’s status as a Gold Partner of Oracle and the Quest International User Group for JD Edwards users, Magic xpi for JD Edwards extends the capabilities and usage of Oracle’s JD Edwards EnterpriseOne and JD Edwards World ERP systems, opening up a manageable way to control integration with the entire range of business processes.

In addition, Magic xpi extends the capabilities and usage of your SugarCRM system, simply and intuitively integrating it with your company's entire range of business processes and enterprise applications, such as SAP, JD EdwardsIBM i, Lotus Notes, accounting, ERP, supply chain management, HRMS, logistics, and more.

Magic xpi provides you with an accurate and real-time view of your corporate information, and eliminates the need to manually update on-premise systems when changes occur in SugarCRM. Magic xpi Integration Platform utilizes Open Source Web Services from SugarCRM and has an out-of-the-box Web Service service for use with SugarCRM sugarsoap.

Magic xpi SugarCRM Web Services let you work with your SugarCRM implementations. They can be implemented as a trigger or as a step in a flow. SugarCRM sugarsoap integration and SugarCRM SugarREST integration is supported.

Web services are the standard way to interoperate between applications on different platforms or frameworks. Web services enable access to your application from external sources. Various types of applications, written in different languages, located anywhere in the world, can interface with your application in real time.
Magic xpi makes all of the SugarCRM WebServices available using the required sugarsoap binding and all available schemas.

SugarCRM Service
Description
get_entry() 
Retrieves a single SugarBean based on the ID.
get_entries() 
Retrieves multiple SugarBeans based on IDs. This API is not applicable to the Reports module.
get_entry_list() 
Retrieves a list of SugarBeans.
set_relationship() 
Sets a single relationship between two beans where items are related by module name and ID.
set_relationships() 
Sets multiple relationships between two beans where items are related by module name and ID.
get_relationship() 
Retrieves a collection of beans that are related to the specified bean and, optionally, return relationship data for the related beans.
set_entry() 
Creates or updates a single SugarBean.
set_entries() 
Creates or updates a list of SugarBeans.
login() 
Logs the user into the Sugar application.
logout() 
Logs out the user from the current session.
get_server_info() 
Obtains server information such as version and GMT time.
get_user_id() 
Returns the user_id of the user who is logged into the current session.
get_module_fields() 
Retrieves the vardef information on fields of the specified bean.
seamless_login() 
Performs a seamless login. This is used internally during synchronization.
set_note_attachment() 
Adds or replaces an attachment to a note.
get_note_attachment() 
Retrieves an attachment from a note.
set_document_revision() 
Sets a new revision to the document
get_document_revision() 
Allows an authenticated user with the appropriate permission to download a document.
search_by_module() 
Returns the ID, module_name, and fields for the specified modules as specified in the search string.
get_available_modules() 
Retrieves the list of modules available to the current user logged into the system.
get_user_team_id() 
Retrieves the ID of the default team of the user who is logged into the current session.
set_campaign_merge() 
Performs a mail merge for the specified campaign.
get_entries_count() 
Retrieves the specified number of records in a module.

Most people forget how Rudyard Kipling’s Ballad of East and West ends: “But there is neither East nor West, Border, nor Breed, nor Birth,   When two strong men stand face to face, tho’ they come from the ends of the earth.” Machine boundaries between SugarCRM and JD Edwards are real and require intermediation. Magic xpi is about as good a solution to this requirement as one can find, East or West.



Glenn Johnson is a Senior Vice President at Magic Software Enterprises, Inc. Active in the software industry since 1984, he frequently speaks at industry conferences and writes for numerous publications.