ESI JDE ODBC Driver

Universal ODBC access to JD Edwards® EnterpriseOne® data - a modern alternative to legacy JDE ODA connectivity.

ESI JDE ODBC Driver provides a practical, familiar and easy-to-use way to access JD Edwards data from reporting tools, spreadsheets, integration utilities, desktop applications and custom software. Instead of forcing every tool to understand JDE internals, it exposes JDE data through the most universal data access interface: ODBC. All the smart JDE-aware features people wanted from old JDE ODA driver - but modernized, easier to deploy, and with multiple backend options.

The driver uses JDE credentials, observes automatic JDE Table Security and can operate through three separate backends: FAT, XML and AIS. It also includes JDE-aware conveniences such as UDC expansion, automatic decimals and currency handling, and support for either Long or Short column names.

Current version: 1.0

Order or Inquire

  • Product Brief
  • More Details
  • System Requirements
  • Licensing
ODBC is still the common language of business data access. It is supported by a huge range of tools, including reporting products, BI platforms, ETL tools, Microsoft Excel, Microsoft Access, scripting environments and custom applications.

ESI JDE ODBC Driver brings that universal access model to JD Edwards data while preserving the JDE security model. Users connect with their JDE credentials, and access is automatically constrained by JDE Table Security.

The result is simple: users and tools get familiar ODBC access, while administrators retain JDE-controlled authentication and table-level access protection.

Access to F0101

ESI JDE ODBC Driver is designed specifically for JD Edwards environments and includes functionality that generic database drivers do not understand and cannot handle.

Main advantages:
• Uses JDE credentials
• Automatic JDE Table Security
• Three separate backends: FAT, XML and AIS
• UDC expansion support
• Automatic Decimals, Dates and Currency handling
• Support for Long or Short column names
• Provides ODBC interface, one of the most universal and easy-to-use data access providers

The three-backend design allows the driver to fit different JDE landscapes and usage scenarios. FAT, XML and AIS access paths provide flexibility for older and newer installations, different deployment preferences and different integration requirements.

JDE-aware field handling means that common reporting and integration problems are reduced before the data reaches the target tool. Numeric values can be presented with the correct decimal interpretation, currency fields can be handled automatically, Dates shown in the regular format, UDC values can be expanded into more meaningful data, and column naming can be adjusted to suit either technical or business users.

Nothing can be easier!

OS: MS Windows (x32 or x64)
CPU: Intel or AMD (x32 or x64)
System Type: Physical or Virtual
JDE Releases: JD Edwards EnterpriseOne
JDE Backend Database Platforms: DB-independent - all platforms supported by JDE can be accessed through the relevant JDE backend
Client Software: Any ODBC-capable application or development environment

Multiple Licensing options exist.

 
Related products:

For JDE Integration:
Develop and test XML easily. JDE supports extended XML syntax that allows creating whole "programs" in XML that can call multiple functions, have variable support, exception and transaction handling and more. - ESI JDE XML Playground

For Automation:
A variety of powerful automation tools - All Automation Tools

For JDE Security and SSO:
Modern authentication middleware for JD Edwards - XpreSSO