Home : Compass Tool for J.D. Edwards OneWorld

This tool is not publicly available.

Revision Notes

July 3, 2001 - Document Created

Downloads/Links

• Screen Shot - Here is a screen captures of the Compass Tool in action. 

Overview

During my first J.D. Edwards OneWorld implementation I decided to build a tool that would make my life of constantly querying the OneWorld schema a bit easier.  With table names like F4211 and F986101, owner names like SYSB733 and PRODCTL, and column names like ABAN8 and RPDOC...things tend to get a bit confusing!  The result was a tool that could do the following:

• Allows user to browse all OneWorld tables by name, description or system code.

• Allows user to directly query tables via ODBC.  Query could be stored for later re-use.

• Allows user to export the results of any query to an Excel file.

• Provides a special code table lookup facility.

• Contains tools for automatically looking up indexes, checking tables for NULL values and determining uniqueness of various column combinations.

• Generates reports for objects which includes object and column descriptions as well as user comments.

• Capable of being used against multiple environments.

Compass Tool has come in handy in more circumstances than I can count.  It has allowed me to develop an understanding of the OneWorld schema that many do not not have.  The tool has been used by a number of other J.D. Edwards professionals within our company and has greatly increased their efficiency.