Table of Contents

Search

  1. Preface
  2. Starting Data Archive
  3. System Configuration
  4. Database Users and Privileges
  5. Source Connections
  6. Target Connections
  7. Archive Store Configuration
  8. Datatype Mapping
  9. Database Optimization
  10. SAP Application Retirement
  11. z/OS Source Data Retirement
  12. Seamless Data Access
  13. Data Discovery Portal
  14. Security
  15. SSL Communication with Data Vault
  16. LDAP User Authentication
  17. Auditing
  18. Running Jobs from External Applications
  19. Salesforce Archiving Administrator Tasks
  20. Upgrading Oracle History Data
  21. Upgrading PeopleSoft History Data
  22. Data Archive Maintenance
  23. Storage Classifications
  24. Appendix A: Datetime and Numeric Formatting
  25. Appendix B: Data Archive Connectivity

Administrator Guide

Administrator Guide

Uploading JDBC Driver JAR Files

Uploading JDBC Driver JAR Files

Upload a JDBC driver JAR file so that you can connect to a source database through a generic JDBC driver.
  1. Select
    Administration
    Upload JDBC Driver
    .
    The
    Upload JDBC Driver
    window appears.
  2. Click
    Browse
    next to the
    JDBC Jar File Location
    field, select the JDBC JAR file, and click
    Open
    .
    The file path and file name of the JAR file appear in the
    JDBC Jar File Location
    field.
  3. To upload more files, click
    Add Row
    , and repeat step 2.
  4. Click
    Upload Files
    .
    Data Archive uploads the files to the following directories:
    • <ILM Products Installation Directory>\webapp\WEB-INF\lib
    • <ILM Products Installation Directory>\webapp\edm\lib
    After you upload a custom JDBC driver, you must update one of the following files depending on your operating system before you can make use of the new driver.
    • Windows:
      edm.bat
    • Linux:
      edm.sh
  5. Navigate to the
    \webapp\edm\lib
    folder and make note of the name of each JAR file of the driver that you uploaded in step 4.
  6. Open the
    edm.bat
    or
    edm.sh
    file in a text editor and add an entry for each JAR file to the classpath settings section, such as in the following example:
    :: CUSTOM_JDBC jdbc driver set LAUNCH_CLASSPATH=%LAUNCH_CLASSPATH%;%WORKLIBDIR%\CUSTOM_JDBC.jar
  7. Save your changes. If Enterprise Data Manager is already running, restart it to make the new JDBC driver available.
After you upload the driver files, restart the ILM application server on the machine that hosts Data Archive.

0 COMMENTS

We’d like to hear from you!