Data Selection Commander

Speed up JDE Upgrades, Document and Compare Data Selection

It's important to have Data Selections documented for many reasons: for reference, in case something stops working, to compare Data Selections across Environments or even different Systems and of course to help re-creating Versions in the new system after an Upgrade.

Current version: 5.0

  • Product Brief
  • More Details
  • System Requirements
  • Licensing
Faster and cheaper JDE Upgrades? Absolutely! Many custom Versions will inevitably be lost with every Upgrade because of changes in the parent Templates, so they will need to be re-created from scratch in the new systems. And without Version properties nicely printed in a readable format, this is a very slow and tedious task. DS Commander alone can shave weeks off a typical Upgrade Plan:

Easily compare Data Selections across different Environments or even different installations, using the built-in features:

Reduce risks and maintenance expenses by having your known good Data Selections documented - when something goes wrong with a Version, there will be a reference ready to instantly rectify the problem.
Comprehensive site documentation is not a luxury, but a necessity. Wrong Data Selections are causing many issues and need to be documented and periodically reviewed.

This intelligent self-configuring software solution provides a very easy way to document Batch Versions' Data Selections (per Section - if multiple Sections have DS overrides, it reports them all). It also finds any orphaned and/or corrupt specs in the system (hundreds of which are delivered with the default OneWorld/EnterpriseOne software installation).

Extremely easy to use, this software offers a one-button interface with no configuration. It's immediately operational upon installation. The users will not need to be trained to use this solution. All necessary configuration is read directly from OneWorld/EnterpriseOne.

The easy-to-read, color-coded output of this tool is saved in XLS format. Here are some sample report screenshots:

The tool identifies any corrupt Data Selections - referring to non-existent Data Structures, missing RI elements, RV's, etc. - see the samples above. Please note that such "corruptions" will even exist in pristine fresh installations and they are certain to confuse the runtime JDE engine, so such programs may produce unexpected results. The fix is as simple as reviewing and confirming the relevant data selections in RDA, re-saving the affected object and checking it back in afterwards.

DS Commander also finds any orphaned data selection records (and there are lots of them in every system). Orphaned Data Selection records could affect the job selection, if EnterpriseOne decides to use them. Making the specs tables smaller will also reduce the package build times and improve the run-time performance of the UBE's. To clean up orphaned records, simply open the Version in RDA and save it.

And finally, DS Commander also finds all Data Selections defined as Section Overrides in Versions, which would not be visible to end-users at all, and quite often creates a great deal of confusion as to why certain data is never displayed.

This tool is lightning-fast: it only takes a few minutes to report Data Selections for all versions in the system. It has no hardware dependencies, as it does not access any data directly.

DS Commander also takes into account the data selections defined for sections in the Versions' Templates.

Limited Trial Version is available upon request.

OS: MS Windows (x32 or x64)
OS Versions: 2000, 2003/Vista, 2008/Windows 7
OS Editions: Workstation or Server, excluding Home Edition
CPU: Intel or AMD (x32 or x64)
System Type: Physical (preferred) or Virtual (please mention this to us when purchasing, because of the licensing differences)
JDE Releases: XE (B7333), ERP8 (B7334), B9 (E1 8.9), E810, E811 (including E811 SP1), E812, E900, E910, E920
JDE Tools Releases (pre-Unicode): SP16 onwards
JDE Tools Releases (Unicode): TR891 onwards
JDE Backend Hardware Platforms: hardware-independent - all platforms supported by JDE are supported
JDE Backend Database Platforms: DB-independent - all platforms supported by JDE are supported
Client Machine Software Requirements: requires pre-existing functional JDE Fat Client installation (including any necessary DB connectivity clients)
Client Machine Hardware Requirements: has no requirements above JDE Fat Client MTR's, but will benefit from additional capacity

This software is licensed with a hardware dongle, usually a USB flash drive, which needs to be physically plugged into the client computer for the software to operate.

This licensing essentially works "as a book", or "one user at a time" and so it can be any user and in any computer.

This software does not have a mechanism that allows it to be used remotely, so in Virtual environments there will be additional considerations: the USB dongle can be plugged in into the Virtual Server and then mounted in the target VM, if the VM host offers USB support. And if it does not, then this software can instead be licensed to a physical HDD, mounted in the target VM (it's an Advanced option, this is not a Virtual Disk, physical disks are not available in VM's by default).

No installation is necessary to use the software - it can be copied to and executed directly from the USB disk, or from any other directory on the target computer, as long as the licensed device is physically available on the machine.

The optional Yearly Update/Upgrade Subscription is available at the time of purchase (not available separately) for an additional yearly fee. It is payable in advance per license, per year. It includes premium support and all software updates released during the paid period. Its cost is calculated as 20% of the product's list price at the time of invoicing, as may change from time to time. Unless the software is purchased for a single use application, we generally recommend to opt in for this Subscription: any future JDE Tools Releases and Releases/Updates may require an updated version of this solution and it's generally more cost-efficient compared to one-off Upgrades.
Related products:

For JDE Upgrades and System Documentation:
Help you Upgrade Versions - Processing Option Commander
Help you Upgrade Versions - Update Queue Names In Versions