I use SI to load data in order header and several related child tables via ODBC maps every day. However that isn't a single query. I have to load the header and then query it again to get the order number and use that to load the child tables. It never gives me troubles designed that way. They are oracle tables ( the database not the ERP)
On Aug 1, 2011, at 4:29 PM, Dave Records <[email protected]> wrote: > Thanks for the response Travis - I know if you are doing a query on a child > table and it returns a null set, that the map will loop forever. The other > issue is updating and setting flags after a query, seems to lock the table > after so many records, then will sometimes hang and leave the table locked, > which the ERP folks don't seem to appreciate. > > Dave Records > Records Consulting, LLC > Phone: 616.583.0090 > Email: [email protected] > > On Aug 1, 2011, at 4:13 PM, Travis Truax wrote: > > > Well, I don't have any JDE/Oracle experience, but I have worked with direct > > DB mapping on 2 other ERPs... > > > > >>GENTRAN SQL handling is not robust -------Agreed. The AI Mapper can be > > >>crashy, and the DB functionality was obviously an afterthought. When you > > >>have problems with it, there's no easy way to debug the map. The Trace is > > >>just about your only hope, and it gives weak information on DB maps at > > >>best. > > > > >>causes looping --------Not sure what this means. We generally have a > > >>single query returning denormalized header and detail data. It *is* going > > >>to run that query once for each document, though- is that way you mean? > > > > >>leaves locks lying around. ---------Never had that issue with Gentran. > > >>Our ERP systems are usually pretty good about locking themselves up, with > > >>no outside intervention required. > > > > > > Travis- > > > > > > From: "Dave Records" <[email protected]> > > To: "edi list" <[email protected]> > > Sent: Monday, August 1, 2011 2:50:34 PM > > Subject: [EDI-L] SQL Mapping Question > > > > > > I know there has been a discussion on direct SQL mapping vs. exporting to a > > flat file and mapping Gentran/GIS from the flat file. What type of > > experiences has anyone had with SQL mapping from JDE and Oracle? It appears > > to me that the GENTRAN SQL handling is not robust, causes looping and > > leaves locks lying around. At this point, I would not recommend SQL mapping > > as it's too unreliable from within a Gentran map unless someone can give me > > some good advice on controlling the scope of a record or even a table. > > > > Dave Records > > Records Consulting, LLC > > Phone: 616.583.0090 > > Email: [email protected] > > > > > > > > > > > > > > [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 > > > > > > > > > > > > [Non-text portions of this message have been removed] > > [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/
