StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
17553367
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
5
CommunityOwnedDate
CreationDate
2013-07-09T16:21:37.180
FavoriteCount
0
LastActivityDate
2013-07-09T16:21:37.180
LastEditDate
LastEditorUserId
0
OwnerUserId
425289
ParentId
17549115
PostTypeId
2
Score
3
ViewCount
0
LastEditorDisplayName
text
Body
Most traditional EDI software houses have "enterprise" scale integration options that run on (as) a server. Gentran, TrustedLink, BizTalk..all names that are in that space and are usually a sizable (expensive) investment. What I use here is Liaison's Delta (translation) and ECS (communication). Both run as client / server. The translation software is a true Windows drag / drop any-to-any mapper that can handle all integration scenarios. This commercial software would run you around $20k. We are currently supporting well over 100 trading partners, doing about 3000 batches of data per day. The system is integrated with our ERP and not only handles EDI but XML, flat file, CSV data as well. <a href="http://liaison.com/products/transform/delta" rel="nofollow" title="Delta">Delta</a> and <a href="http://liaison.com/products/integrate/ecs" rel="nofollow">ECS</a>. You might be interested in reading this: <a href="http://liaison.com/docs/case-studies/liaison---keysource-delta-ecs-case-study.pdf?sfvrsn=6" rel="nofollow">My Case Study</a> If you have your own translation engine (parser) and just want a piece for communication, you can still check out ECS, Cleo Lexicom, or Axway. All have Managed File Transfer solutions that will work for you, and run as a Windows service. So our server handles AS2 communication, picks up files on schedules, sends data via FTP and FTPs, handles web services via HTTP, and has client utilities to show data coming in and out of the system. It also automatically generates the 997 for inbound transactions. Setup of ECS is very easy. Learning a translator - any translator - can be a daunting task. There are quirks to every one of them. That's where the time will be invested in.
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POHow to set up an EDI Server
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USAndrew
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. POHow to set up an EDI Server
 singulars
 PostTypePostTypeId
 PTQuestion
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTAcceptedByOriginator
2. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
CommentsPostId
1. COHi Andrew, Thanks very much, this is very helpful.
 singulars
 PostPostId
 PO
 UserUserId
 USGreg0

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.