Table of Contents

Search

  1. Installation Getting Started
  2. Before You Install the Services
  3. Run the Big Data Suite Installer
  4. After You Install the Services
  5. Install the Developer Tool
  6. Uninstallation
  7. Starting and Stopping Informatica Services
  8. Connecting to Databases
  9. Updating the DynamicSections Parameter of a DB2 Database
  10. Silent Input Properties File

Installation and Configuration Guide

Installation and Configuration Guide

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.