Skip to content
Artwork for The JDE Connection
The JDE Connection · November 10 · 34 min

Ep 128 - Just Because You Can SQL Does Not Mean You Should

In this episode, Chandra and Paul focused on the challenges and risks associated with directly using SQL to update JD Edwards data, sharing real-life examples of how manual SQL entries can bypass critical business logic and lead to data integrity issues. One concept discussed was the value of new automation tools like Orchestrator and AI assistance (such as Claude code) to streamline bulk updates safely within JDE’s validations. Chandra and Paul reminded listeners about the importance of sharing enhancement ideas with Oracle after developing custom solutions, to benefit the wider community. 01:54 Just fall gracefully 07:25 Organizing the episode chaos 09:33 Chandra’s pet peeve – SQL Updates 14:30 Sharing your challenges so others can benefit 16:18 Discussing SQL and alternatives 30:52 Midwesternism

0:00-34:57

transcript

No transcript — this publisher did not publish one.

show notes

In this episode, Chandra and Paul focused on the challenges and risks associated with directly using SQL to update JD Edwards data, sharing real-life examples of how manual SQL entries can bypass critical business logic and lead to data integrity issues. One concept discussed was the value of new automation tools like Orchestrator and AI assistance (such as Claude code) to streamline bulk updates safely within JDE’s validations. Chandra and Paul reminded listeners about the importance of sharing enhancement ideas with Oracle after developing custom solutions, to benefit the wider community.

01:54 Just fall gracefully

07:25 Organizing the episode chaos

09:33 Chandra’s pet peeve – SQL Updates

14:30 Sharing your challenges so others can benefit

16:18 Discussing SQL and alternatives

30:52 Midwesternism