Understanding Open Data Access
The JD Edwards EnterpriseOne Open Data Access ODBC driver is a read-only driver that is compliant with version 2.5 or higher. Front-end Windows query and reporting tools can use ODA to access the JD Edwards EnterpriseOne database. ODA supports these front-end tools:
Microsoft Query
Microsoft Access
Microsoft Excel
ODBCTEST
Microsoft Analysis Service (not certified)
ODA sits between the front-end Query and Reporting tool and the JD Edwards EnterpriseOne-configured ODBC drivers.