Performance. This situation might have improved in the intervening time but the ODBC connection between Gentran for Windows and Oracle was slow and buggy compared with voracious, rock-solid and powerful SQL*Loader. From time to time I considered replacing our mapper with it. Not *quite* capable of that but very close.
Howard Parks 1 Peter 4:10 ________________________________ From: Skip <[email protected]> To: [email protected] Sent: Thu, January 27, 2011 9:06:03 AM Subject: [EDI-L] Flat File vs XML => What about Using your data base? 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/
