XMLP - Data Access Driver – What is it Used for?

The JD Edwards EnterpriseOne Data Access Driver (DAD) is a type 4 jdbc driver whose sole purpose is to access JD Edwards database from an outside source.  Applications such as Hyperion or BI Publisher can utilize the DAD to make such a connection.

NOTE:  The DAD provides the third party tool access to EnterpriseOne data in read only mode.

 

What are the Requirements to Use the DAD?

The DAD can only be utilized with applications that support “read-only” jdbc type 4 drivers.

 

How Complex is the Setup?

The setup is fairly straight forward involving placement of the dad driver jar files into the location of third party applications class path directory (Usually this will be the product’s lib directory where that application’s jar files exists).  Since JD Edwards EnterpriseOne is not a database in and of itself an environment is initialized which is then utilized to perform the queries on the JD Edwards data.  This is done via a URL that specifies the environment name.  To get this environment to work the jas.ini, jdbj.ini and jdelog.properties files should be created on the third party application’s machine. This has to be done via server manager by registering that third party application machine and then creating a managed instance for type Data Access Driver.

 

For additional resources regarding Data Access Driver please see the following KM documents:

     E1: XMLP: Implementation Steps for Data Access Driver (DAD) with BI Publisher 11g and Above (Doc ID 1331667.1)