Windows IT Pro is the authoritative and independent resource for windows nt, windows 2000, windows 2003, windows xp. Features a collection of resources and magazines for windows IT professionals.
  
  
  Advanced Search 


February 1999

EDI, NT, and the Internet


RSS
Subscribe to Windows IT Pro | See More Internet Articles Here | Reprints | Or get the Monthly Online Pass—only $5.95 a month!
SideBar    SSCE and EDI

Changing the Way You Do Business

Electronic data interchange (EDI), which has been around for decades, is the transmission and reception of documents between computers in machine-readable form. EDI transactions have high integrity and are highly secure, with the potential to scale to very large batch operations. These transactions often transfer mission-critical data between enterprises. Most companies use value-added networks (VANs) to transmit EDI transactions, but the advent of the Internet is rapidly changing the EDI landscape.

In this article, I'll describe how EDI has traditionally fit into many business models and explain the costs associated with EDI. In addition, I'll show you how the Internet is making EDI more accessible to small and midsized companies and what tools are available to implement EDI in a Windows NT environment.

EDI and Traditional Business Models
EDI is a simple technology that maps the database data set on one computer to the database data set of a different computer. Companies traditionally use VANs, such as GE Information Services, the IBM Advantis Network, Harbinger EDI Services, and AT&T, for EDI. Some of these VANs can be quite large (e.g., GE Information Services has almost 40,000 subscribers). Most VANs use the X.25 mail protocol to transmit compressed, encrypted data over secure pathways. Companies typically pay for transmissions in kilocharacters (1000 characters) according to the number of characters the VAN transmits or receives, which is expensive.

About 100,000 companies worldwide participate in EDI transactions, and about 1000 companies, many of which are Fortune 1000 companies, engage in large-volume EDI transactions. International communications use EDI extensively, which is important to know if your organization conducts business around the world. As a result of the widespread use of EDI worldwide, the United Nations established the Electronic Data Interchange for Administration, Commerce, and Transport (UN/EDIFACT), which focuses on EDI.

About 100 vendors, including Sterling Commerce, Harbinger, St. Paul Software, Data Management Strategies, and Perwill EDI, sell EDI translation software. EDI translation software available for NT includes Premenos' TrustedLink Enterprise and TSI International's Mercator.

The software on the sending and receiving computers determines the number of fields in a document (such as a purchase order or invoice), the order of the transmission, and the appearance of the data. Software on the sending computer prepares the data for transmission and often modifies fixed-length data, and software on the receiving computer parses the data into a form that the computer can use. The translation software formats the data using a standard such as ANSI X12 or UN/EDIFACT so that the software can map outgoing data and unmap incoming data and transform it into proprietary file formats that business applications use.

Although the concept of EDI is simple, the practice of EDI is arcane. Standards exist, but they represent only a starting point that requires human intervention and agreement on both sides of the messaging system.

EDI plays a fundamental role in the working business model of several industries. When the government, large retail outlets, or automotive manufacturers need to communicate document-based paperless transactions to their business partners, they are in a position to impose an industry wide EDI standard. EDI cuts down on error, transmission times, and the number of staff required to process the transactions. For example, retailers can rely on EDI to communicate the output from a database that measures the inventory fluctuations that occur every time a cashier scans an item's bar code at a checkout counter. Using this information, a retailer can place the burden of stocking its shelves on the product distributors and can pay these distributors according to how quickly their products sell from the retailer's shelves. Under this arrangement, the distributors get instant (generally overnight) feedback about the success of their products and a closer working relationship with their large retail customers.

Retailers often couple EDI with an Electronic Funds Transfer (EFT) system so they can credit money to a distributor as soon as that distributor's new product arrives on the shelf. In a tightly coupled system, these transactions can occur frequently. EFT is a form of EDI using proprietary file formats that pass payment transactions between banks. However, EFT doesn't always mean that the money is immediately available to the distributor. The financial organizations involved in the transactions determine the rules of deposit and transfer.

The automotive industry uses EDI as a fundamental part of its business model to implement just-in-time (JIT) manufacturing. Several hundred suppliers provide thousands of parts to the manufacturer to build each car, and a typical assembly line might stock only 2 or 3 days' worth of inventory. The suppliers receive EDI transmission-based purchase orders from the manufacturer and provide parts as needed. The manufacturer pays suppliers for the inventory the manufacturer uses on its assembly line, thereby shifting the inventory problem to the suppliers.

   Previous  [1]  2  3  Next 


Reader Comments
I read Barrie Sosinsky’s “EDI, NT, and the Internet” (February), and I want to share some thoughts about the article’s topic. EDI technology is exciting when coupled with the potential leverage of the Internet and new database technologies. You can also effectively implement EDI <i>within</i> an organization. Many industries have linked data sets electronically, but perhaps not to such an extent that the effort adds value or electronic data transfer exceeds manual data handling.
I’m a database junkie for what I think is a technologically progressive newspaper (<i>The Orlando Sentinel</i>). However, we can do much to enhance how we electronically share data among systems and use warehoused data. Plenty of opportunities exist to implement EDI between the newspaper and its advertisers and suppliers.
Last year, I campaigned within our company to apply the strategy the article outlined. <i>MicroEDI</i> (EDI within a company) can add value to existing systems in a midsized company and increase operating efficiency with little or no additional infrastructure requirements. I’ve received positive feedback from my campaigning, but it takes a long time to steer even a not-so-big ship when the steering input comes from someone who isn’t even close to being in control of the rudder.
I’m very excited about the possibilities that today’s database systems offer, and I hope to put my vision in place one day. By communicating and collaborating with people who have a similar vision, the reality of microEDI might come sooner.<br>
--Robb Salzmann<br><br>

EDI is a straightforward technology—–
essentially, just a data-mapping exercise. Given a low-cost, secure transmission method and a well-thought-out, reasonable translation server, many companies (not just large rich companies) might be game to try it. Enabling EDI is one of the primary goals of Microsoft’s BizTalk initiative. (For more information about the BizTalk initiative, see http://www.microsoft.com/presspass/
commerce/initiatives.)<br>
--Barrie Sosinsky</i>

Robb Salzmann August 09, 1999


You must log on before posting a comment.

If you don't have a username & password, please register now.




Top Viewed ArticlesView all articles
PsExec

This freeware utility lets you execute processes on a remote system and redirect output to the local system. ...

Microsoft Delivers Service Pack 2 Beta 2 for Vista, Server 2008

Microsoft on Tuesday announced the availability of the Beta 2 version of Service Pack 2 (SP2) for Windows Vista and Windows Server 2008. Since both operating systems were developed from the same code base, they have a common servicing structure and thus ...

Command Prompt Tricks

One reader shares his tip for setting up the command prompt to reflect a remote path. ...


Security Whitepapers The Impact of Messaging and Web Threats

Why SaaS is the Right Solution for Log Management

Protecting (You and) Your Data with Exchange Server 2007

Related Events How IE7 & The New Extended Validation SSL Certificates Impact Your Site

Top 10 Email Security Challenges and Solutions

Introduction to Identity Lifecycle Manager "2"

Check out our list of Free Email Newsletters!

Security eBooks Spam Fighting and Email Security for the 21st Century

Understanding and Leveraging Code Signing Technologies

A Guide to Windows Certification and Public Keys

Related Security Resources Become a VIP member of the Windows IT Pro community!
Get it all with the VIP CD and VIP access. A $500+ value for only $279!

Subscribe to Windows IT Pro!
Solve your toughest technical problems with our experts and access 10,000 + articles online. 30% off

Monthly Online Pass - Only $5.95!
Get instant access to 10,000+ articles from Windows IT Pro Magazine!

TechNet Virtual Labs
Evaluate and test Microsoft's newest products.


Windows IT Pro Home Register FAQ for Windows WinInfo News
Europe Edition About Us Contact Us/Customer Service Media Kit Affiliates / Licensing  
SQL Server Magazine Office & SharePoint Pro Windows Dev Pro IT Job Hound ITTV
IT Library Technology Resource Directory Connected Home Windows Excavator Windows SuperSite 
 
 Windows IT Pro is a Division of Penton Media Inc.
 Copyright © 2008 Penton Media, Inc., All rights reserved. Terms and Use | Privacy Statement | Reprints and Licensing