Posts Tagged ‘XML’

B2B – Confusion Over Data Formats and Protocols

Monday, September 14th, 2009

Business-to-Business (B2B) eCommerce terms such as EDI, XML, AS2, SFTP, and so on can get very confusing.

What is really needed for two businesses to exchange electronic documents between each other? Most business see the value of establishing a B2B eCommerce interface in order to transfer electronic documents. What is confusing is that there are several technical methodologies needed to establish a B2B eCommerce interface to transfer the electronic documents. First, there is the data standard to be used when formatting the data within the electronic document. Second, there is the communications method or protocol to transport the electronic document over data communications lines or the internet.



Data Standards. B2B eCommerce electronic documents can be electronically transferred using a variety of different data formats such as Electronic Data Interchange (EDI) X12, EDIFACT, or Extended Markup Language (XML). These formats define the data and layout so that the data within the electronic document can be easily integrated into dissimilar business systems.

Data Format Example. Take for example an electronic purchase order document. Depending on specificity, the data standard may define the purchase order field in such terms as field name, data type, field length, and allowable content.

The EDI Versus XML Debate There is a lot of debate in B2B eCommerce circles over the use of EDI Versus XML. Both will work, but in my opinion EDI / EDIFACT data standards are superior in supporting B2B eCommerce. This is because EDI has mature data specifications (XML is designed for minimum data specifications) and the file sizes of EDI documents are much smaller to transport over communications lines or the internet (i.e. XML is a bandwidth hog).

The Challenge of Universal B2B eCommerce Data Standards. B2B eCommerce data standards have come and gone. There are now many different and proprietary data standards. See posting, Will There Ever be an Universal Standard for Supply Chain Information Exchange? for more on the challenges and promises of universal B2B eCommerce data standards.

Communications Protocol. Electronic documents can be transferred over communications lines using a variety of different communications protocols. Now-a-days, more and more businesses are using the internet versus private communications lines to conduct B2B eCommerce. Additionally due to hackers and SOX-compliance, it is now becoming a necessity to encrypt most, if not all, electronic documents to protect them from unauthorized use. Common communications protocols for B2B eCommece include File Transfer Protocol (FTP), Secure FTP using SSH, FTPS (FTP over SSL), AS2 (HTTPS), Simple Mail Transfer Protocol (SMTP) / AS1, and so on.

Note: Many businesses are challenged by B2B eCommerce because there are so many EDI-type standards and so many proprietary integration applications that can support B2B eCommerce. They may all work, but which one and which one works with what? See posting, Is B2B eCommerce at a Crossroads?.

Back to B2B Commerce Resources.

Why Use XML?

Friday, September 4th, 2009

Extensible Markup Language (XML) has its place, but because of a lot of hype it is many times used to do things it was not intended to do. The misuse of XML is particularly prevalent when it comes to Business-To-Business (B2B) eCommerce. Below are reasons to use XML.



Why XML Was Invented. XML was originally developed to make web page development easier by providing a base language to separate, store, and integrate data content into Hypertext Markup Language (html) formatted web pages.


Why Use XML?

Why Use XML? – Display Dynamic Data. XML is great for integrating dynamic data into a web page. If the data changes a lot on a web page, use XML to display it within an html document. Example: news headlines.

Why Use XML? – Simplifies Data Sharing. XML makes it easy to share data with numerous applications and on multiple web pages across the internet. Many internet widgets use an XML-based language such as Really Simple Syndication (RSS) to display content on countless desktops and web pages. Note: XML is best for a raw data feed on a web page. XML is usually not the best choice if the data is just to be shared and processed between two systems.

Why Use XML? – Simplifies Data Transport. Because XML uses a simple, universal format, data can be transported easily between two incompatible systems or applications. Note: Because XML is a very verbose data format, it is not usually the best choice for passing electronic documents between two business systems.

Why Use XML? – Simplifies System Upgrades. Because XML is normally stored in text format, it is much easier to upgrade and replace systems, browsers, and applications. Note: Because XML has a verbose data format, it is not the best storage format in terms of maximizing disk space.

EDI Versus XML – Data Exchange Between Businesses

Monday, June 8th, 2009

If I recommend or mention to a business user an eCommerce solution involving EDI (Electronic Data Interchange) instead of using XML (eXtensible Markup Language), I usually lose at least some credibility. I am not really tied to EDI, but every time I look at XML for a specific business solution it ends up lacking. The primary reason that it lacks is there is a lack of standards when it comes to defining the specific data elements in a business transaction. For example, EDI has mature data definitions for things like a transaction number field for a shipment status electronic document.

XML seems to be only useful for real-time, simple transactional-level processing or for machine-to-human interface such as an RSS-type feed or web page presentation. At sometime in the future, XML may have mature data definitions that support system-to-system interfaces for different types of electronic documents. Data definition standards is something that EDI already has to support system-to-system integration. See Skip Stein’s paper, Co-existence of Traditional EDI with XML-EDI, on the purpose of XML and EDI.

XML has a lot of myths. Myths include: simple to implement, cheap to implement, easy data format, and technically superior. If you look at the business case for system-to-system data exchange between different businesses, EDI usually wins out. See Comparison Chart Between EDI and XML on the myths and the business cases in regard to implementing EDI or XML.