I am a .NET developer working on upgrading an integration project in JDE The current version of the project uses XML call object to interface with JDE. It works well, but we end up creating business functions for table changes. I came across this product on internet search. Can you confirm that it can do table changes (i.e. update, insert and delete) in .NET? Thanks!
JDE table update using .NET
- Thread starter jde.net
- Start date
Yes, it can. Let us know if you have further questions.
Have you looked at using Orchestrator or AIS for this?
Yes, I have. We decided not to go with Orchestrator/AIS because we already have programming logic to call business functions and table selects to do what we need. Our integrations accept multiple records in each request and we need the ability to roll back the entire transaction if one or more records fail. In Orchestrator/AIS, data is committed with the completion of each form request. Besides, opening forms, placing values in controls and invoking UI actions is not true integration, IMO, no offense.
The commit/rollback requirement got me thinking - we are using transactions in our XML call object model. Does your product support transactions with table updates? Can we use the a transaction that combines business functions (that may update tables) and direct table updates?
In LynX.Net (the development framework of LynX Business Integrator), you can open a transaction boundary, call business functions and table i/o (select, insert, update, delete) and then commit/rollback the transaction as needed. This lets you preserve data integrity in scenarios that mandate it.