Posts

How to solve EDI integration challenges with Oracle’s JD Edwards

JD Edwards, or JDE, is an Enterprise Resource Planning (ERP) system by Oracle. There are currently two editions, JDE Enterprise One or JD Edwards World. In many ways, this ERP solution is great for corporate-level enterprises, as it offers many tools and connectors for data integration. One key challenge, however, that companies using a JDE system, no matter its edition, are faced with is the lack of ease for EDI integration within the system. Currently, there is no out-of-the-box integrated EDI solution or connector that would make this process easy, quick and seamless.

JDE EDI integration

Our team has encountered many companies struggling with this inefficiency. As we are not JDE experts, but instead EDI integration experts, we’ve teamed up with our partners at Magic Software Enterprises, who have worked in the JDE world for many years. By leveraging our combined expertise, teamwork and solutions (which will be mentioned below), JDE users can have an EDI integration project that is efficient, successful and within budget.

Therefore, how do we help companies overcome common EDI challenges with their JD Edwards system? By using our popular EDI2XML services, along with Magic Software’s powerful business integration platform called Magic xpi & certified JDE adaptor.

EDI2XML

Our team of EDI experts handle the entire EDI portion of the project, where we convert all EDI X12 or EDIFACT documents into the desired format that is requested by the client, such as flat file, XML, CSV, etc. For outgoing files, EDI2XML works by converting the XML / CSV file into the EDI format, requested by the Trading Partner. We take care of all EDI mapping, Trading Partner configuration, XML/CSV/flat file translations, and back and forth transactions with Trading Partners. Visit us at http://www.edi2xml.com

Read: The Definitive Checklist For Oracle JDE and EDI Integration Projects

Magic xpi for JDE

Magic Software’s xpi platform is an ‘Oracle Validated Integration’ solution that can be used to orchestrate the entire business process, no matter if you are using JD Edwards Enterprise One or JD Edwards World. It comes with a ton of built-in components to build workflows and streamline an entire business flow;

  • Database Gateways to connect with common databases, such as SQL Server, Oracle, DB2, Pervasive, MySQL, ODBC, etc.
  • Connectors that allow users to directly connect to JDE, SAP, Dynamics, Salesforce, etc.
  • Triggers & Data Mappers to monitor folders and to map from one file format to another.
  • Connectivity & Messaging through FTP, SOAP, MSMQ, etc.

Therefore, if an incoming EDI document is received by a company, our EDI2XML service will convert this file into the client’s desired format (let’s say XML), then using Magic xpi, will be mapped to JDE by;

  • Creating 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 or her mouse to drag and drop to map fields from the source to the destination (JDE table).

why-we-love-edi2xml-for-edi-integration-with-jde-and-you-should-too2

In this day and age, EDI integration within management systems should be seamless but for many it is not. This is can cause major headaches for managers. Companies no longer want to hire in-house EDI experts when they already have a full team of in-house JDE developers. It’s about time JDE users can rely on an outsourced EDI Integration Partner that will ensure their daily EDI transactions are processed and streamlined, without difficulties.

Call us today  +1 450-681-3009  to learn more about our EDI2XML Service and JDE Integration capabilities with our Magic Software partner.

 

/by

How to become EDI-compatible with major retailers such as Sears, HBC, Costco, Wal-Mart and Target

If you’re looking to do business with major retailers like Sears, Wal-Mart, Target, Costco, HBC, Amazon, etc., then you’ll definitely needEDI. Today, most major retailers require their trading partners to exchange all documents, such as purchase orders , invoices and ASNs, electronically[EDI]. This can be a major concern at first, but once you find the right EDI supplier (at the right price), everything will become very quick and easy. (To find out what is involved in the configuration of EDI accounts by EDI suppliers, read this article.)

Be EDI-compliant

So, to become EDI compliant, you first need to determine how you want to progress in this area. Do you currently have an IT department with EDI experience? In this case, all you need to do is purchase an EDI translation tool to convert all incoming EDI documents into a suitable format for easy integration into your management system. If not, and you’re not prepared to hire an in-house IT team with EDI experience, you’ll need to consider partnering with an EDIprovider who can manage EVERYTHING for you. “All” includes all EDI mapping servicesWe offer a full range of EDI services, including trading partner configuration, standard maintenance, XML / CSV / TXT translation, integration with your ERP application, sending and receiving of EDI documents from your trading partners, and the deposit and collection of all XML / CSV / TXT files to and from your EDI mailbox.

Then determine which documents your business partners will ask you for, and which they will send you. Will it only be an incoming PO and an outgoing invoice? Do they need an ASN? At this stage, it’s also very important to define the format you’ll need the incoming documents to convert to. Is it XML? CSV? TXT?

Other important questions to ask your business partners at the outset include:

  • What communication protocols do they need (if any)? AS2? VAN?
  • What EDI standard do they use? ANSI ASC X12? EDIFACT? (In North America, the standard generally used is X12)
  • What are the specifications of their documents? (Most probably they send a document with all their specifications).
  • Any other rules and/or guidelines they have for starting to exchange documents electronically with them?

Once you know the basics of your EDI requirements, it’s time to speak with an EDI consultant (or talk to your EDI supplier) to establish the exact EDI flow for your business. At Namtek Consulting Services, our EDI experts are here to assess your EDI business needs and ensure that our services are right for you. If you need direct EDI integration into your Salesforce, JDE, IBM AS400 or eCommerce systems, they can handle it! If you’re simply looking for us to translate incoming and outgoing documents and hand them over to your team for further processing, this can also be arranged. Whether it’s your business partner Sears, Wal-Mart, Costco, HBC, Amazon, Meijer, Canadian Tire, Home Depot, Loblaws or Target, you’ll be well prepared to do business with them on time and on budget. See the list of our current business partners, but note that we can add any partner at any time!

To see prices for our EDI2XML translation service, click here.

Contact us for a free EDI consultation today!

 

/by

How Modern EDI Can Be Your Missing Piece to an Efficient Company

At this point in time, I’d say that most of our readers know what EDI is. We’ve written tons of articles and continuously provide educational resources on it. If you are still unsure of what EDI is and what it can do for your business, please refer to our EDI slide presentation or download our Intro to EDI guide to get better acquainted with this business communication method. Read more

/by

How to become EDI compliant with large retailers like Sears, HBC, Costco, Wal-Mart and Target

If you are looking into getting into business with large retailers like Sears, Wal-Mart, Target, Costco, HBC, Amazon, etc., then you will most certainly require EDI. Nowadays, most large retailers demand that their Trading Partners exchange all documents, like Purchase Orders, Invoices, ASNs, electronically [EDI]. This may seem like such a hassle at first but once you find the right EDI Provider (at the right price), it’ll all become quite easy and quick. (To know what’s involved in the setup of EDI accounts by EDI Providers, read this article.) Read more

/by

Bringing EDI To Your Business in 2016

EDI Communication, a method of electronically exchanging business documents, like Purchase Orders and Invoices, between Trading Partners, has been very much in demand for manufacturers, retailers, suppliers, etc. in recent years…and for good reason! [Read the top benefits of EDI]

So, you’ve recently been looking into doing business with a large retailer but they require you to exchange POs, Invoices, ASNs via EDI? Debating whether or not to bring EDI into your business by 2016? Read more

/by

Getting Started with EDI

Take a look at today’s  Infographic that goes on to briefly describe how companies can get started using EDI Communication with their customers/suppliers/partners.

Every company needs to analyze their EDI requirements first and foremost to determine which solution or service will be needed to easily and securely exchange documents with their Trading Partners. To learn more about EDI Communication, visit EDI2XML. Read more

/by