Post-Installation Database Configuration

How to:

This section describes the configuration of third-party database drivers with iWay Data Profiler (iDP).
Top of page
x
Procedure: How to Configure iWay Data Profiler With MySQL Server Version 5.5

iWay Data Profiler requires the following database driver file:

mysql-connector-java-<version>-bin.jar
  1. Copy the mysql-connector-java-<version>-bin.jar file to the following directory: 
    <dphome>\idpweb\WEB-INF\lib\

    where:

    <dphome>

    Is the path on your file system where iWay Data Profiler is installed.

  2. Restart the application server where iWay Data Profiler is currently deployed (Apache Tomcat).
Top of page
x
Procedure: How to Configure iWay Data Profiler With MSSQL Server 2005 or MS SQL Server 2008
  1. If you are using Microsoft SQL Server 2005, then iWay Data Profiler requires the following database driver file: 
    sqljdbc.jar
    1. Copy the sqljdbc.jar file to the following directory: 
      <dphome>\idpweb\WEB-INF\lib\
  2. If you are using Microsoft SQL Server 2008, then iWay Data Profiler requires the following database driver file: 
    sqljdbc4.jar
    1. Copy the sqljdbc4.jar file to the following directory: 
      <dphome>\idpweb\WEB-INF\lib\
  3. Restart the application server where iWay Data Profiler is currently deployed (Apache Tomcat).
Top of page
x
Procedure: How to Configure iWay Data Profiler With Oracle 11g

iWay Data Profiler requires the following database driver file:

ojdbc7.jar
  1. Copy the ojdbc7.jar file to the following directory: 
    <dphome>\idpweb\WEB-INF\lib\
  2. Restart the application server where iWay Data Profiler is currently deployed (Apache Tomcat).
Top of page
x
Procedure: How to Configure iWay Data Profiler With Teradata Server Version 13.10.00.14

This section is applicable only for iWay Data Profiler - Version 9.0.1T.

iWay Data Profiler requires the following database driver files:

  1. Copy the terajdbc4.jar and tdgssconfg.jar files to the following directory: 
    <dphome>\idpweb\WEB-INF\lib\
  2. Restart the application server where iWay Data Profiler is currently deployed (Apache Tomcat).
iWay Software