Tag Archive for: Oracle

This post was updated to reflect current trends and information.


More and more, companies are seeking to optimize their workflows as much as possible, by using different IT solutions.

The fact is, more software applications that are “heterogenous” are deployed on a company premises. It is common to see for example a CRM (Customer Relationship Management) software, being leveraged along with different business applications and systems such as ERP (Enterprise resource planning), EDI (Electronic Data Interchange), e-commerce store and others. Companies need to optimize and improve their processes by integrating as much as possible all different apps and software solutions being used to run their day to day operations.

Before we start talking about integration, let’s have a quick overview of CRM.

What is CRM?

If you refer to Wikipedia, you find the following definition: “Customer-relationship management (CRM) is an approach to manage a company’s interaction with current and potential customers. It uses data analysis about customers’ history to improve business relationships with customers, specifically focusing on customer retention and ultimately driving sales growth”.

In other words, a CRM is a tool for managing clients and their related information, as well as a way to speed up and streamline sales processes.

CRM market

According to Statista, Global CRM software revenue increased from $ 13.93 billion in 2010 to $ 39.5 billion in 2017. The market was driven by strong software as a service (SaaS) growth.

“In 2018, CRM software revenue will continue to take the lead of all software markets and be the fastest growing software market with a growth rate of 16 percent,” said Julian Poulter, research director at Gartner.

There are a lot of companies in the CRM system market, but the four largest vendors of CRM system offerings are:

Salesforce: is a leader of the CRM software market. American developer of the CRM system, provided only the SaaS model. Technical experts mark the company as the “main players in the cloud computing market” along with Oracle, SAP, Google, Microsoft, Amazon.com


Suggested Readings: How to get more out of Salesforce with EDI Integration


SAP: is a European multinational software corporation that develops enterprise software to manage business operations and customer relations. SAP provide new generation of CRM tools and customer engagement solutions. SAP Hybrid solutions are more than traditional CRM software, they provide in-memory technology and Big Data insights to help companies drive contextual, personalized customer engagement in real time – across any channel or line of business.


Suggested Readings: How To Successfully Complete SAP/R3 EDI Integration Projects Using iDoc


Oracle: is an American multinational computer technology corporation. Oracle CRM is one of the leading products in the CRM market. It has a robust and intuitive interface and a variety of product lines and deployment models:

a) Oracle CRM On-Premises: is a traditional on-premises deployment where the customer needs to buy or lease his own hardware, operating systems and databases, and install a packaged Oracle CRM system on it.

b) CRM On Demand and Oracle Sales Cloud are cloud CRM solutions which are accessible over the internet and paid for by a monthly subscription fee.


Suggested Readings: Oracle JD Edwards Integration: the key to Digital Transformation


Microsoft is an American multinational technology company. One of the leading companies in the CRM space with its Microsoft Dynamics 365. Dynamics 365 platform offers companies an exceptional set of productivity tools across sales, marketing, and customer service. Microsoft Dynamics 365, is unique of its kind in the CRM marketplace, and leading the way in innovation, usability and user experience.


Suggested Readings: The main reasons why you need Microsoft Dynamics Integration with your business Systems


What does CRM integration mean?

Today, it is very common to see enterprises running different types of systems, to run their business. It is common for example to see a company adopting JD Edwards Enterprise one as an ERP, while at the same time, having their sales and marketing department, leveraging Salesforce.com for as their CRM software.

Natively, both branded software systems (JDE and Salesforce), do NOT connect together “out-of-the-box”. However, both of these solutions, offer an API or web service to read/write data.

Integration of a CRM with an ERP helps automate the processes, reduce human errors and maintain a better quality of data for the enterprise.

Additionally, integrating a CRM system to another ERP software, aims at creating an omnichannel (unified) system to collect data about the client from all sources: call center, store, online store, website and social networks. The company must have complete information about its client — this will make the most advantageous offers and provide the best support. Analysis of CRM systems shows that the effect of integrating CRM with other corporate applications can significantly increase company productivity.

Thanks to the integration, data into a CRM system can be visible and transferred to other applications.

Here are some use cases of integration of a CRM

Integration of CRM with the e-commerce site(s): This is very common integration, that allows to synchronize data from an eCommerce site into a CRM system. On the e-commerce site your customers can register and make orders and at the same time, customer contacts are sent from the e-commerce site to your CRM systems. Next, with these contacts, the work can be done already in the CRM system. Namely, the initial call to the customer, the appointment, the second call and so on.

Integration of CRM with accounting and finance: Most often this method is used to upload customer data to accounting programs. Back from the accounting program can be taken in CRM information about payments and receivables from customers.

Large companies that use ERP systems can integrate applications even more closely. For example, orders are initially sent from the e-commerce site to CRM and processed by sales managers, then, automatically transferred to the ERP system. In ERP, further work will be done with the customer’s order (production, logistics, etc.). The status of the order will be returned to CRM.

Benefits of CRM Integration

Integration of CRM with other business applications and systems used by the business will allow:

  • spend less time on search and exchange of information between departments;
  • reduce personnel costs;
  • reduce the risk of losing contacts and other important information about the clients;
  • see full statistics of company activity and configure the end-to-end analytics;
  • migrate workflows into a single interface;
  • reduce paperwork to the minimum;
  • configure automatic data exchange with partners and contractors — for example, a delivery service, bookkeeping outsourcing company or coalition loyalty programs;

Overcoming Integration Challenges with Magic xpi

Using the Magic xpi Integration platform, you can easily integrate enterprise-level solutions due to Magic xpi code-free, business process automation, and data synchronization solutions.

Magic xpi has pre-build, optimized and certified adaptors for most branded CRM systems such as Microsoft Dynamics, Salesforce, SugarCRM, and other.

Magic xpi extends the capability and usage of your CRM system. You can achieve simply and intuitively integration with your company’s business applications, like IBM i, JD Edwards, SAP, Lotus Notes, accounting, ERP, supply chain management, HRMS, logistics, and many more.

Magic xpi, using its visual and intuitive design tools, can simplify and unify the interfaces of your CRM, as well as other business systems in use, while not using any custom coding.

For learn more about Magic xpi integration platform, watch this video

Magic xpi Integration Project Lifecycle

  1. Analysis: Analyze your business processes.
  2. Design: Design and build your business processes and integration flows in the Magic xpi Studio.
  3. Connection: Quickly connect all your existing enterprise applications using Magic xpi built-in certified connectors and adaptors.
  4. Testing: Test the integration flows on simulated business processes, without Interrupting real business activity.
  5. Optimization: Before full deployment, perform risk-free optimization of your business processes and integration flows.
  6. Deployment: Deploy your new integration solution using the Magic xpi server.
  7. Monitoring: Monitor the integration of your business processes.

Click here to download our free White Paper on Magic xpi Integration Platform


The main key to the success – is digital transformation.

Change the usual workflow and introduce new technologies is not easy. Often employees are unwilling and fear of change. However, as you may already know, or have learned from this article, there are many arguments in favor of automation and integration of your business application and systems.

Moreover, if you do not engage new technologies, this does not mean that your competitors are not doing so: competition is ahead. Do not lose customers, develop faster with new technologies. Contact us today for free IT consultation.

Free CRM Intergation consultation

This post was updated to reflect current trends and information.

Article written by Pierre Namroud, EDI Integration Specialist & Business Consultant

I had the pleasure of attending Collaborate17, a Technology and Applications Forum for the Oracle community. This opportunity brought together Oracle professionals, integrators, project managers and IT experts from around the world, who all work in different spaces of integration. It was such a great experience speaking with so many Oracle experts and attending educational sessions.

One of the main points of discussion during the various speaking engagements was on the challenges that professionals were facing when it came to integration projects involving EDI (Electronic Data Interchange) as well as eCommerce data to JDE (JD Edwards). The opinions were unanimous in the sense that Oracle still has more work to be done in order to strengthen and simplify integration with legacy EDI protocols and build simpler integration flows for protocols such as X12, EDIFACT, Rosetta Net, etc.

I’m writing this article, in order to share my own expertise as a data and EDI integrator, where I had the chance to be involved in several eCommerce and EDI integration projects with Oracle JDE. Hopefully it will help inform other Oracle professionals looking to overcome some of these integration challenges.

Challenges currently being faced by Oracle JDE professionals

There are many challenges that any JDE professional might see when it comes to data and systems integration with Oracle ERP software in general, whether for on-premises or cloud systems. [As a side note, Oracle’s cloud systems have their own specific limitations that I recently learned about during one of the Collaborate Sessions].

Below, I have listed some of the most common challenges that not only have I experienced in my own projects with Oracle customers but that others have expressed during the Collaborate conference;

  • Oracle’s JDE does not have a seamless built-in integration with all EDI X12 documents “out of the box”.
  • The current integration process for EDI X12, EDIFACT, HL7 or any other data format now happens by writing into transition tables (or Z files) and then triggering a business function to process those incoming data.
  • Even though Oracle’s JDE system supports business functions, some older versions do not support new API functions, which can cause some headaches.

    Looking to integrate your EDI or eCommerce processes with Oracle JDE enterprise one, look no further, since we have the best integration option where we turn your Oracle JDE system into a modern REST API, that receives https requests and acts accordingly. Learn More>


Integration Project Checklist

Before starting an integration project with your Oracle JDE system, I recommend that you go through the following list of questions. This way, you’ll be able to make the best decisions to move forward with development efforts as efficiently as possible.

  • Who are the Business or Trading Partners you want to exchange electronic data with?
  • Which documents (or types of data) are you requested to exchange from your Business Partners? In normal circumstances, they’ll provide you with the necessary documentation and specifications as a road map and for compliance reasons.
  • The exchanged data will be sent under what format or standard/version? (X12, EDIFACT, RosettaNet, XML, custom format…?)
  • What is the protocol of communication used to send the data back and forth between you and your Business Partner? Is it point-to-point, such as AS2 or sFTP?
  • Is a VAN required in order to transport the data?
  • Do you have the necessary expertise to select the appropriate certified communication software (for first time project implementation)?
  • Do you have the necessary expertise in your development team to decrypt and understand the terminologies of legacy EDI formats?
  • Has your team ever done an EDI integration project, that includes a full certification process?
  • How many partners will you be exchanging with? The more partners you have, the more complex the project can become.
  • Check the specs of all of your partners (when possible) to verify the differences in their requirements. It is well known in the EDI integration world that there can be many distinctions and exceptions found per Business Partner and per document. Every EDI project can be unique.
  • What is the lead-time to complete the certification and testing phase with your business partner before going live?
  • What is the volume of exceptions that your development team can currently handle in the project in order to be on time and within budget?
  • Do you have the necessary integration tools to simplify the EDI syntax in order to work with one format regardless of the format of the data you receive from different sources?
  • Is your team coding directly in Oracle JDE native framework, or are you using any efficient integration tool available today?
  • Will you be doing end-to-end integration using Z tables of Oracle JDE, or you are going to use API (or business functions) of JDE?

Recommendations for a Successful Integration Project

As you might have noticed, data integration projects involving legacy EDI protocols or custom data format exchange are not simple. They are projects that need a lot of expertise and experience in data communication and transportation, data mapping and systems integration into Oracle’s JDE system.

Moreover, at most enterprises that we’ve completed EDI integration projects for, it was evident how stretched and overwhelmed the internal JDE development team was in their own day-to-day operations, support and maintenance of the application and were incapable of learning new standards to respect the strict timeline given by Trading Partners. In these cases, they looked for help from an outside Service Provider, such as EDI2XML.

My recommendations for such projects are as follows:

  • Outsource the EDI part of the project to a reliable Service Provider, who is highly focused on service availability and quality, since EDI is quite sensitive. This will allow your team to continue working on their daily tasks and keep doing what they do best (JDE support and maintenance, for example). This way, you’ll have a simplified and streamlined EDI integration process; you build one tunnel between your EDI provider, where they deal with the exceptions, and your own process.
  • In case your company policy requires you to deploy the EDI integration solution on-premises, make sure to use an efficient EDI conversion tool such as our EDI2XML technology that has the capability to turn the EDI documents from X12 format to a human readable XML format, for example.
  • Equip your team with the right tools for data integration such as Magic xpi, which we have been using for many years in our data and systems integration projects. Leveraging such technologies allowed us to integrate anything-to-anything (JDE to SAP, SAP to Salesforce, EDI to any system as examples).

I sure hope I was able to expose the most common EDI integration challenges and complexities and help you to overcome these obstacles with the above checklist and recommendations.

If you are interested in learning more about this topic or any other issue related to EDI integration projects, please click on the image below and I will be more than happy to contact you personally for a FREE consultation.

 

Free consultation ecommerce JDE integration

 

We are excited to share with you that we will be attending Collaborate17, in Las Vegas, Nevada, from April 2nd to the 6th. This Technology and Applications Forum for the Oracle Community is presented by IOUG (Independent Oracle Users Group), OAUG (Oracle Applications User Group) and Quest International Users Group, and will be held at the Mandalay Bay Convention Center.

Along with our Magic Software partner, we will be participating in education sessions and demos to teach Oracle users about the latest products, services and technologies that can accelerate and enhance their current Oracle Applications and help them overcome EDI challenges.

Visit us at booth 909 to learn more about how EDI2XML, partnered with Magic Software’s xpi platform, can be your efficient and affordable solution.

To learn more about this EDI integration solution, read our latest blog on “How to solve EDI integration challenges with Oracle’s JD Edwards”.

Click on the image below to join us in Las Vegas at Collaborate17!

EDI2XML at Collaborate 2017 for Oracle JDE integration

EDI integration project

This post was updated to reflect current trends and information.

What is Magic xpi

Magic xpi is a business integration platform proprietary technology for Magic Software. This business integration suite is very powerful and comes loaded with tons of built-in components to build workflows and orchestrate an entire business flow:

  • Database gateways: to connect “natively” to the most common databases used within an enterprise (i.e. SQL server, Oracle, DB2, Pervasive, MySQL, ODBC…).
  • Connectors: to directly connect to JDE, SAP, Dynamics, SalesForce.
  • Triggers and Data mappers: whether to monitor a folder content or to parse and map from one file format to another
  • Connectivity and messaging: through FTP, SOAP, MSMQ, etc.

And the list goes on…

Read: How to Solve the Biggest EDI integration Problems With JDE

How EDI2XML works within Magic xpi

As you might already know by now, EDI2XML is our own technology to convert an X12 EDI transaction to XML. When doing the conversion from EDI to XML, EDI2XML is able to generate the FA 997 (Functional Acknowledgment) as a response to the incoming EDI transaction. In the meantime, EDI2XML installer comes with all the xml schemas (.xsd) of the EDI2XML format.

Since Magic xpi is missing a component to transform X12 EDI to XML, EDI2XML can fill this gap. By creating a custom component and inserting the command to trigger EDI2XML from within a Magic xpi business flow, EDI2XML will turn an incoming EDI file (i.e. 850) into XML format.

In a subsequent step, using a Data mapper component, the user can map the content of the EDI file in XML and map it to any other format (Flat file, database….).

Read: Top 3 Challenges to Overcome in Salesforce and EDI Integration Projects

Mapping EDI from EDI2XML to JDE

As mentioned previously, Magic xpi comes loaded with connectors to major systems such as SAP, JDE, Salesforce, etc. As an example, any table in JDE can be used as a source or destination in data mapping process, using a Data Mapper step within Magic xpi.

Once the incoming EDI X12 file is converted to XML, it is very simple to then map it to JDE:

  • Create a step with a Data mapper
  • Source: XML based on the EDI2XML .xsd (schema file)
  • Destination: the JDE table to feed from the XML format

Once the source and destination are defined, the user can use his mouse to drag and drop to map fields from the source to the destination (JD table).

EDI Integration with JDE


Looking to integrate your EDI or eCommerce processes with Oracle JDE enterprise one, look no further, since we have the best integration option where we turn your Oracle JDE system into a modern REST API, that receives https requests and acts accordingly. LEARN MORE>


This is why we love EDI2XML in EDI integration with JDE

EDI2XML has a rich library of EDI documents to translate and it is expandable. In addition, using EDI2XML within a flow in Magic xpi is a MUST in order to map EDI data to XML and from XML directly to JDE. Most importantly, there is no need for EDI knowledge to interpret the fields and segments, as it is all easily understandable by any person. On top of it all, all .xsd files are provided with the EDI2XML engine!

EDI integration into JDE is as simple as mapping from XML to JDE using drag and drop!

Free EDI consultation


This post was updated to reflect current trends and information.


EDI integration projects have always been time consuming, as it requires an expert team with EDI knowledge and many resources. No matter how small or large the company is, the previous statement falls true for them all. It is the nature of EDI and all the processes involved that makes an EDI integration project complex and problematic for the developers and executives. In this article, I would like to identify a few of the major problems of EDI integration with JDE (JD Edwards) and how to solve them, in order to have a smooth and successful EDI implementation.

About JDE

JD Edwards, also known as JDE, is an Enterprise Resource Planning (ERP) software that Oracle sells and supports. JDE is offered in two different lines (or editions): JD Edwards EnterpriseOne and JD Edwards World. In most cases, JDE software solutions are implemented and deployed in corporate level enterprises. It is less present in small enterprises since most SMEs cannot afford its maintenance costs.

Why EDI integration with JDE is a problem

Read: EDI Integration with JDE Made Easy with EDI2XML

While JDE is a great corporate level ERP solution, offering lots of tools and connectors for data integration (flat file and other format), it does NOT offer out of-the-box an integrated EDI solution or connector that would make EDI integration seamless. It offers the necessary interfaces to define file formats for export and import, but it stops short on completing the loop into a full EDI solution.
For EDI project integration, JDE heavily relies on third-party “EDI translation software” to send or receive EDI files, and to turn the EDI files into a format (flat file for example) that can be easily interpreted and processed by JDE.

Having said that, you can now imagine how complex and time-consuming integration of EDI in JDE is for a company’s IT personnel and developers. The major problems can be summarized as follows:

  1. IT personnel need to have an extensive EDI expertise; for example, a high knowledge of EDI is needed to be able to define the data to be extracted from the incoming EDI file
  2. They need to learn how the “EDI Translation software” works as well as how and when to extract data and transform it into the proper format for JDE
  3. Of course, they need to know how to work with JDE and setup interfaces and connectors. This one is not of a major concern as IT personnel handling JDE are experienced with this platform

Looking to integrate your EDI or eCommerce processes with Oracle JDE enterprise one, look no further, since we have the best integration option where we turn your Oracle JDE system into a modern REST API, that receives https requests and acts accordingly. LEARN MORE>


How to solve the integration problems

In order to solve problems associated with EDI integration with JDE, it comes down to reducing the number of points identified in the previous section to 2 rather than 3, by capitalizing and building on JDE expertise. So how can this be done in order to have an EDI integration project run smoothly, on budget and on time?

Read: Top 3 Challenges to Overcome in Salesforce and EDI Integration Projects

The answer is simple. Companies running JDE can leverage:

  • EDI2XML : the technology to convert EDI to XML (and XML to EDI)
  • Magic xpi: the business integration platform from Magic Software, that is able to orchestrate the entire business process. It is an “Oracle Validated Integration” solution for both JD Edwards EnterpriseOne and JD Edwards World.

Magic xpi comes with a lot of built-in features to support an EDI project implementation such as:

  • Communication components (FTP,sFTP)
  • Ability to execute scheduled tasks based on several triggers
  • Ability to execute tasks based on file scanning triggers

EDI2XML has complementary features to make an EDI integration project within JDE very simple and straightforward:

  • EDI2XML is able to generate FA 997 out-of-the box for incoming EDI documents
  • EDI2XML turns the EDI files received into readable XML format, so no need for extensive EDI expertise

Therefore, EDI integration projects with JDE don’t have to be so dreadful anymore. The marriage of EDI2XML, Magic xpi and our team’s EDI expertise can definitely benefit your company and make EDI projects easy and under budget.

To read more about using EDI with JD Edwards and the third-party applications, Click here

Free consultation ecommerce JDE integration