< Do not use any ODBC in EDI s/w to communicate with ERP.> <<I would not go that far. I've used ODBC connections to ERP systems during both inbound and outbound EDI mapping and I like it a lot. Different strokes for different folks.>> As soon as you use ODBC, you have the following potential problems: - ERP is down. - Database page is locked for an update. - User, password changes. - Permissions issues. - Convoluted SQL syntax shoe-horned into EDI software reducing maintainability, which is the holy grail of any s/w system. If there is an ODBC problem, and it will happen, does your EDI system gracefully handle it, without expert intervention? -Paul www.icefan.ca
-----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Michael Mattias Sent: Thursday, September 07, 2006 6:05 PM To: [email protected] Subject: Re: [EDI-L] ERP EDI raw data import/export concerns > I can't speak specifically about Axapta, but generally .... > > Use flat files to import/export with your ERP. > Use your ERP's import/export to manage flat-files or roll a quick program in > your language of choice. > Advantages? > Can change EDI or ERP s/w easily (future-proof, including SOA). Agreed 100%, if ERP system changes and you are writing directly to it, you have to change the EDI side, which is usually the harder side to maintain. If you use a "common" flat file or flat-like interface, the only time you have to change the EDI side is when the EDI changes. But for... > Do not use any ODBC in EDI s/w to communicate with ERP. I would not go that far. I've used ODBC connections to ERP systems during both inbound and outbound EDI mapping and I like it a lot. Different strokes for different folks. Michael C. Mattias Tal Systems Inc. Racine WI [EMAIL PROTECTED] <mailto:mmattias%40talsystems.com> .com [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: mailto:[EMAIL PROTECTED] mailto:[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/
