Table of Contents

Search

  1. Preface
  2. Part 1: Installation Getting Started
  3. Part 2: Before You Install the Services
  4. Part 3: Run the Services Installer
  5. Part 4: After You Install the Services
  6. Part 5: Informatica Client Installation
  7. Part 6: Uninstallation
  8. Appendix A: Starting and Stopping Informatica Services
  9. Appendix B: Connecting to Databases from UNIX or Linux

Installation for Enterprise Data Preparation

Installation for Enterprise Data Preparation

Connecting to a JDBC Data Source

Connecting to a JDBC Data Source

To enable the the Data Integration Service to write to relational targets, download JDBC driver .jar files to the Data Integration Service host and to all client machines that run mappings that have relational targets.
Obtain the driver .jar file from the database vendor. For example, to access an Oracle database, download the file
ojdbc.jar
from the Oracle website.
  1. Place the JDBC driver .jar file in the following directory on the Data Integration Service machine
    <Informatica installation directory>/externaljdbcjars
    . Then recycle the Data Integration Service.
  2. Place the JDBC driver .jar file in the following directory on machines that host the Developer tool:
    <Informatica installation directory>/clients/externaljdbcjars
    . Then recycle the Developer tool.