ODA

ODA (Open Data Access) provides the capability for you to extract JD Edwards EnterpriseOne data (using SQL statements) so that you can summarize information and generate reports. You can use ODA with any of these desktop applications:

• Microsoft Query

• Microsoft Access

• Microsoft Excel

• ODBCTEST

• Microsoft Analysis Service

ODA sits between the front-end query and reporting applications and the JD Edwards EnterpriseOne-configured ODBC drivers.

The JD Edwards EnterpriseOne database contains object and column names, specific data types, and security rules that must be converted or applied so that the data is presented correctly. The specific data types and rules include decimal shifting, Julian date, currency, media object, security, and user defined codes. In some instances, ODA modifies the SQL SELECT statement, as well as the data, so that it appears correctly within the selected application.

Some of the benefits of using ODA include:

• Read-only access to all JD Edwards EnterpriseOne data, including the entire data dictionary.

• Use of the same security rules that you established for JD Edwards EnterpriseOne.

• Ability to extract JD Edwards EnterpriseOne data easily.

  See Understanding Open Data Access.