Results 1 to 6 of 6

Thread: Execute JD Edwards Logic or Business Function After Data Inserted Via SQL

  1. #1
    New Member
    Join Date
    Jul 2011
    Posts
    45

    Execute JD Edwards Logic or Business Function After Data Inserted Via SQL

    Curious if anyone has ever found a way around this... JD Edwards obviously does not play well with regards to JDE based table triggers recognizing data when it is inserted/changes using SQL. I have a situation i'm trying to work around where an external application is pushing data into a temporary table and I would ideally like to have JDE execute some business functions with this data that has been inserted - I cannot determine a way to get JDE to recognize that the data is there. That being said, could obviously execute a UBE on a schedule but that is not nearly real time enough for this operation. Any ideas are appreciated.
    E1 8.12, 9.0, 9.1 and 9.2.
    E1 Tools 8.x through current
    SQL server, Oracle and IBM iSeries
    Technical (Development and CNC) and Functional

  2. #2
    A few ideas:
    1. Could you put a UBE into "subsystem" mode and continually poll the table?
    2. Your tools in your signature indicate 'current'. Could you have you third party app make a service call to Orchestrator and let Orchestrator write to the temp table and call the business logic?
    Jeremy Shearer

  3. #3
    New Member
    Join Date
    Jul 2011
    Posts
    45
    Great idea on the subsystem mode, yes. I'll explore that.

    I work with a few different installations and this particular install does not have Orchestrator. I did lobby for that as an option
    E1 8.12, 9.0, 9.1 and 9.2.
    E1 Tools 8.x through current
    SQL server, Oracle and IBM iSeries
    Technical (Development and CNC) and Functional

  4. #4
    Member nkuebelbeck's Avatar
    Join Date
    Mar 2012
    Location
    Minnesota
    Posts
    556
    xmlinterop fires table triggers i believe
    Analyst/Developer
    E1: 9.2 | TR: 9.2.3.5 | JAS: WebLogic | ES: OS400
    DB: DB2 | WebDev Client: Win7Pro (64 bit), VS 2013

  5. #5
    Senior Member craig_welton's Avatar
    Join Date
    Oct 2000
    Location
    Litchfield, CT
    Posts
    1,037
    Call a UBE or function via XML Interop after the external process finishes the inserts?
    Craig Welton
    PatWel Group Inc.
    http://www.patwel.com
    Home of the FREE JDE Object Browser, JDETrace, NERDup and BusBuild+ Tools

    E1 9.0 8.98.4.2 Wintel SQL 2008
    E1 9.2 9.2.1.4 iSeries

  6. #6
    New Member
    Join Date
    Jul 2011
    Posts
    45
    nkuebelbeck and Craig,

    I actually put together a XMLInterop process (with some examples from nkuebelbeck - thanks again). I was able to create a windows service to act as a listener where our third party app could use the service to dispatch the actual XML call. Had to do it this way because the app is 64bit and the edwards install is 32bit... made for a few creative weeks. Anyway, that was all working but the roundtrip for the transactions was VERY lengthy. The box making the call was located across the US from the Edwards install. We started toying with SQL inserts as a way to avoid some of the overhead (since XML has to establish a connection, handshake, post the file, etc.). SQL turned out to be much quicker (since JDBC can be established then direct inserts until transactions are complete) and then come back only when more interaction is required. Anyway, I thought about what you both suggested - basically allow for the SQL inserts to continue and basically have the XML Interop call send a message just to notify JDE that there was some activity performed and that it should go through and process whatever it finds in that table. The only concern I have, and the reason i've avoided doing it, is due to the increase in transaction time. If the volume weren't high and this was a one-off process, i'd go for it, but the frequency of usage will be very high and I think over time the compounding of that transaction time would cause issues.
    E1 8.12, 9.0, 9.1 and 9.2.
    E1 Tools 8.x through current
    SQL server, Oracle and IBM iSeries
    Technical (Development and CNC) and Functional

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
The legal restrictions and terms of use applicable to this site are available here.
Use of this site signifies your agreement to the terms of use.
JDELIST is NOT affiliated with JD Edwards® & Company, Oracle or Peoplesoft. Contents of this site are neither endorsed nor approved by JD Edwards® & Company and, or Oracle.