How to setup Hyperion ODI (Oracle Data Integrator) to integrate with JD Edwards EnterpriseOne


1. Download the JD Edwards EnterpriseOne Data Access Driver (DAD) driver:

Select My Oracle Support, then Patches, and then Software and Patch Search Sites.

  • From JDEdwards, enter: EnterpriseOne Tools Releases.
  • In Release, select All Releases.
  • In Platform, select Multiplatform.
  • In Description (*text*), select *Data Access Driver*.
  • Select the License Agreement check box.
  • Click Search.
  • Click the plus sign (+) to add Tools 9.1 Data Access Driver to the Download Basket.
  • Click the Item(s) hyperlink and download the tools release specific item.

 

2. To copy the DAD Drive to the ODI Agent Driver directory, unzip the archive file to a temporary directory. Extract the JAR file DADriver_EAR.jar. Then, copy the extracted contents of DADriver_EAR.jar to the ODI Agent Driver directory. If you are running the standalone ODI Agent, then the directory in a default installation is: C:\Oracle\product\11.1.1\Oracle_DI_1\oracledi\agent\drivers

3. Register the JD Edwards EnterpriseOne Data Access Driver by way of the Server Manager.
The combined Server Manager Agent (installed on the Oracle Data Integrator server) and Server Manager Console are used to register the JD Edwards EnterpriseOne Data Access Driver. This process generates the jas.ini file, jdbj.ini file, and jdelog.properties file, and extracts the JD Edwards EnterpriseOne Data Access Driver jar files to a target location.

  1. From the Server Manager Console, select the Managed Home Location named for your Oracle Data Integrator Server.
  2. Click Create New Managed Instance.
  3. From the panel that follows, select the EnterpriseOne Data Access Driver radio button.
  4. Click Continue.
  5. Complete the form fields as follows, and click Continue.

jdedward

6. Complete the form fields based upon configuration attributes of the environment; and click Continue.

Caution! Click Continue only once and wait for the panel to change.

7. Click Create Instance.

4. Navigate to the recently created Server Manager Agent JDBC driver configuration install location.

For example, navigate to: C:\JDE_HOME\targets\JDEJDBC_DAD\config

5. Copy the jas.ini file, jdbj.ini file, and jdelog.properties file from the JDE Application Server to the ODI Agent Driver directory. If you are running a standalone ODI Agent, then the directory in a default installation is: C:\Oracle\product\11.1.1\Oracle_DI_1\oracledi\agent\drivers

6. Ensure that the security server of the jas.ini file is set correctly.

7. Review and edit the jdbj.ini file as follows:

If the JD Edwards application database is Oracle, update the location to the tnsnames.ora file. It is imperative that you encrypt the [JDBj-BOOTSTRAP SESSION] stanza, then the password value.
Modifications to the .INI file password encryption can only be accomplished through the use of Server Manager.
Set the value of following parameters under [JDBj-RUNTIME PROPERTIES] stanza to:

resultSetTimeout=-1

transactionTimeout=-1

usageExecutionThreshold=20000

usageResultSetOpenThreshold=120000

usageTracking=false

msSQLQueryTimeout=1800000

8. Edit the jdelog.properties file and set the log level as needed. In a production environment, set the log level to SEVERE so that only severe errors are reported in the log file.

9. Ensure you can access the server specified in the jdbj.ini file from the ODI Server. Sometimes the .INI file may contain a server host name without a domain suffix. If needed, create an entry in the host file of the ODI Server so that the JDE server can be accessed.

Thanks,
~KKT~

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s