JDE table update using .NET

jde.net

New member
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!
 

e1ellen

New member
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!

Have you looked at using Orchestrator or AIS for this?
 

jde.net

New member
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.
 

jde.net

New member
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?
 

Cool Calico

Administrator
Staff member
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.
 
Top