ODBC on-line Help v2.0
ODBC on-line Help v3.0
ODBC Driver Downloads
UTB Downloads
UTB on-line Help

jdeDirect - Take a Fresh Look

Documentation | DownloadsOn-Line Help v2.0 | On-Line Help v3.0 | FAQ

The storm clouds are never far away when it comes to JD Edwards reporting.

We deliver an out-of-the-box, purpose built, intelligent bridge to your data.  A safe, secure, read only data access ODBC driver. Used by 100's of JDE sites around the world, both World and EnterpriseOne/OneWorld with a whole range of different reporting solutions from Crystal Reports to MS Access, Cognos to Lotus Notes. So chase away those clouds and let your data shine through.

jdeDirect Information Sheet


Government of Bermuda Case Study

Having implemented JD Edwards EnterpriseOne or JD Edwards World ??  you now need to make the data easily available to your users - provide them with full access to the entire master and transactional data.  You need the freedom to pick what you want, to support management and the continuous improvement of your business - easily, flexibly and without undue reliance on IT staff.

Perhaps you're looking to implement a business intelligence, reporting or data warehousing solution such as Cognos, Hyperion, Crystal Reports, Crystal Enterprise: or to interface Microsoft Excel, Access and SQL Server with your existing JD Edwards Enterprise One and JD Edwards World system.

You will be aware that your back-end database is not the easiest of ERPs with which to build bridges and interfaces. You need to be able to deal with decimal scaling, strange date formats, security issues and a whole bunch of other constraints that will simply slow things down.  Others may have developed solutions, but do they work with ALL the various supported databases? Will they support your third party application? Will they work with JD Edwards World?

Are they cost effective? Will they give you the flexibility offered by unique solutions from Unity ?

At Unity we have taken our vast experience and technical understanding of the JD Edwards Enterprise One and JD Edwards World systems to develop an out-of-the-box, purpose built, intelligent bridge to the back-end ERP database. With jdeDirect, you'll have some clever front-end controls and manageability - delivering the power to move data in real time, fully formatted to your data analysis application.

We deliver this bridge as a fully functional, fully compliant READ ONLY ODBC driver. Suddenly your ODBC compliant application can see the full database schema - not as seen by other ODBC drivers... 

Imagine having the power to externally communicate with your JD Edwards EnterpriseOne security server, database server and data dictionary to access, retrieve and present business critical data held within your JD Edwards EnterpriseOne or World solution.  jdeDirect enables Windows server and client applications to exchange data held within your JD Edwards database for external web technologies, business intelligence tools, data warehousing, data mining, query and reporting tools and decision support solutions.

jdeDirect is a ODBC driver designed specifically for JD Edwards EnterpriseOne and World.

CRYSTAL REPORTS Solutions for JD Edwards WORLD - Special Package -
Read More


  •  Expose the full database schema, long table and column names

  •  Present numeric and date values correctly

  •  Expose UDC descriptions in a virtual column

  •  Maintain system security by requesting correct user authentication

  •  Apply row and column security as defined in the security workbench

  •  Enable Enterprise Wide reporting with ease

  •  Empower users with  Ad Hoc reporting tools

  •  Data extraction made easy - Use Excel, Access, Crystal

  •  Expose OneWorld and EnterpriseOne Media & Text Objects - Read More  

  •  No need for the JDE client software to make jdeDirect work

  •  Link your data straight into Microsoft Excel - including complex joins and data selection

  •  Makes Crystal Reports a snip

  •  No programming skills needed, just point and click using your existing familiar tools

  • Installs as an ODBC driver, available to any ODBC compliant application