Installing IBM-branded ODBC drivers

Install the IBM®-branded DataDirect ODBC driver to access Microsoft SQL data sources.

Before you begin

The IBM-branded DataDirect ODBC driver is included with the installation image of IBM InfoSphere™ Federation Server version 10.5. For non-Windows platforms, you can obtain the ODBC driver package from the installation image. The package name is typically ODBC_FedServ_vervion_platform.tar.gz.

You can also obtain the ODBC driver package from the IBM ftp site ftp://ftp.software.ibm.com. The download page for ODBC drivers is available at the following location:

ftp://ftp.software.ibm.com/software/db2ii/downloads/odbc_driver/

About this task

The ODBC driver installation is done through the command prompt. You must install the ODBC driver on your system before you install IBM InfoSphere Federation Server.

Procedure

Install the ODBC driver by using either of the following methods:
- Install the driver in GUI mode.
  1. Run the gunzip command to unzip the file_name.tar.gz file to a directory that you specify:
```
gunzip file_name.tar.gz
```
    Where file_name is the name of the ODBC driver that is bundled with IBM InfoSphere Federation Server.
  2. Run the tar command to untar the file_name.tar file:
```
tar -xvf file_name.tar
```
    Where file_name is the name of the file that you unzipped.
  3. Run the ODBC installation script:
```
./install.bin
```
    Use the default settings to install the ODBC driver.
  4. Continue to Step 3.
- Perform a silent installation by using a response file.
  1. Create a response file named odbc.rsp that includes the following lines:
```
LICENCE_ACCEPTED=TRUE
USER_INSTALL_DIR=/opt/IBM/odbcdriver
installNow=true
```
    Parameter values
    
    TRUE
    
    Specifies that you accept the license agreement.
    
    odbc_Driver_Install_Path
    
    Specifies the installation directory of the IBM-branded DataDirect ODBC driver.
    
    true
    
    Specifies that you want the installation to occur immediately.
  2. Run the ODBC installation script:
```
./install.bin -f response_file -i silent
```
    Note: Run the script as a root user. Running the script as a non-root user is not supported for the IBM-branded ODBC driver installation.
  3. Continue to Step 3.
- Perform a console installation.
  1. Run the ODBC installation script:
    - In a command line environment:
      "./install.bin"
    - In a command line or GUI environment:
      "./install.bin -i console"
  2. Continue to Step 3.
Optional: You can choose to invoke the installer for the ODBC driver after you install Federation Server. To invoke the installer:
1. Invoke install.bin in the odbcDriver folder
2. Use a response file to install both Federation Server and the ODBC driver.
Configure the odbc.ini file to specify the required installation directories. See Configuring the odbc.ini file.
Run the example application to test the driver configuration. See Testing ODBC driver configurations.