blusky75
Member
Hello,
I'm interested to hear how other companies have tackled EDI translation (850's, 810's, 856's primarily) and Integration with JDE. Currently we are using Gentran:Server (4.0 for Windows) to export/import inbound and outbound flat files from JD Edwards (OneWorld on an AS400 box). JD Edwards reads and writes these flat files using the R47xxxC programs (flat file conversions for the EDI Z tables such as F47011, F47046, etc).
There are several problems with automating EDI this way:
1) the need for a windows logical application server (since the AS400 seems to have issues running the R47xxxC flat file conversion programs).
2) inbound flat file processing (e.g. 850 purchase orders) run in batch mode and are not transaction safe (would rather isolate transactions down to the each EDI PO)
3) Gentran:Server does not have any integration capabilities with other systems (we had to program SQL Server DTS jobs on Gentran to pull JD Edwards EDI cross reference data into Gentran - this is taxing on both JDE and Gentran). Nor can JD Edwards initiate a Gentran:Server process.
We are having a hard time getting a feel for what other JDE clients are using for EDI translation and integration. So far we have had an extensive proof of concept demo of Gentran Integration Suite (which has shown us to be capable of performing table selects/inserts/updates/deletes to the F47 tables via SQL and a JDBC adapter).
EDI translation is just one piece of the puzzle. Other requirements include integration (to perform lookups in JD Edwards such as the address book, as well as execute BSFN's using THINNET, etc), as well as UCCNet / ECCNet item synchronization capabilities, and AS2/EDIINT communications.
Obviously with the many problems associated with automating flat file conversions using the vanilla JDE tools, we're looking at better ways to approach the problem. What EAI/EDI solutions are most popular and favorable in the JD Edwards community? All references I have found praise GIS with other non-edwards packages.
Also, if anyone has been using GIS with your Edwards outfit, I'd very much like to get your input!
Steve Krisjanovs - Programmer Analyst
I'm interested to hear how other companies have tackled EDI translation (850's, 810's, 856's primarily) and Integration with JDE. Currently we are using Gentran:Server (4.0 for Windows) to export/import inbound and outbound flat files from JD Edwards (OneWorld on an AS400 box). JD Edwards reads and writes these flat files using the R47xxxC programs (flat file conversions for the EDI Z tables such as F47011, F47046, etc).
There are several problems with automating EDI this way:
1) the need for a windows logical application server (since the AS400 seems to have issues running the R47xxxC flat file conversion programs).
2) inbound flat file processing (e.g. 850 purchase orders) run in batch mode and are not transaction safe (would rather isolate transactions down to the each EDI PO)
3) Gentran:Server does not have any integration capabilities with other systems (we had to program SQL Server DTS jobs on Gentran to pull JD Edwards EDI cross reference data into Gentran - this is taxing on both JDE and Gentran). Nor can JD Edwards initiate a Gentran:Server process.
We are having a hard time getting a feel for what other JDE clients are using for EDI translation and integration. So far we have had an extensive proof of concept demo of Gentran Integration Suite (which has shown us to be capable of performing table selects/inserts/updates/deletes to the F47 tables via SQL and a JDBC adapter).
EDI translation is just one piece of the puzzle. Other requirements include integration (to perform lookups in JD Edwards such as the address book, as well as execute BSFN's using THINNET, etc), as well as UCCNet / ECCNet item synchronization capabilities, and AS2/EDIINT communications.
Obviously with the many problems associated with automating flat file conversions using the vanilla JDE tools, we're looking at better ways to approach the problem. What EAI/EDI solutions are most popular and favorable in the JD Edwards community? All references I have found praise GIS with other non-edwards packages.
Also, if anyone has been using GIS with your Edwards outfit, I'd very much like to get your input!
Steve Krisjanovs - Programmer Analyst