Skip, I would absolutely agree with you on that issue and in fact I did some
work as the product manager for an edi translator that interfaced directly into
a progress database. My preferred method would be a direct database load, then
XML for readability, ( I don't see storage space as being a significant issue
any more) and flat files. I work with all three routinely, however, I am
currently working with a customer who is upgrading their system plant by plant
and need to divide the inbound plant by plant. So we convert X12 to XML, and
route the data to the correct system for that plant. Eventually, perhaps, we
can do direct dbloads as all of the plants will be on the upgraded system. I
still maintain that it's much easier to troubleshoot a labeled xml files as
opposed to a positional flat file and the resources, while greater, are not
exorbitant.
Dave Records
On Jan 27, 2011, at 10:06 AM, Skip wrote:
> There is a thread going on about the pro/con of using XML or flat file. What
> about using data base tables guys?
>
> Not like this is new science, common.... use the technology we have!
>
> I get so upset when I see flat file interfaces with so many ERP, and other
> systems. People take perfectly good EDI documents, map them into a 'flat
> file' or translate them to XML then write code interfaces to get the
> information/data into the data base that the application system uses.
>
> Why or why do so many folks make more work. Any decent translator marketed in
> the past 10 years will allow you to map directly into and out from most
> commercial data bases in existence today. Use the tables as they more closely
> mirror and structurally resemble EDI groupings.
>
> It is EASIER guys.
>
> Ok, back to work. As it is not Friday, I'll shut up.
>
> Cheers,
>
> Skip Stein
>
>
[Non-text portions of this message have been removed]
------------------------------------
...
Please use the following Message Identifiers as your subject prefix: <SALES>,
<JOBS>, <LIST>, <TECH>, <MISC>, <EVENT>, <OFF-TOPIC>
Job postings are welcome, but for job postings or requests for work: <JOBS> IS
REQUIRED in the subject line as a prefix.Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/EDI-L/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/EDI-L/join
(Yahoo! ID required)
<*> To change settings via email:
[email protected]
[email protected]
<*> To unsubscribe from this group, send an email to:
[email protected]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
