Table of Contents

Search

  1. Preface
  2. Introduction to Hadoop Integration
  3. Before You Begin
  4. Amazon EMR Integration Tasks
  5. Azure HDInsight Integration Tasks
  6. Cloudera CDH Integration Tasks
  7. Hortonworks HDP Integration Tasks
  8. MapR Integration Tasks
  9. Appendix A: Connections

Hadoop Integration Guide

Hadoop Integration Guide

Update odbc.ini

Update odbc.ini

Before you run mappings with ODBC sources and ODBC targets on the Hive engine, you must configure the ODBCHOME and ODBCINI cluster environment variables in the Hadoop connection. You must then manually edit the odbc.ini file to replace the absolute driver paths with relative driver paths.
By default, the odbc.ini file contains absolute driver paths. To run ODBC mappings on the Hive engine, you must edit the odbc.ini file and replace the absolute driver paths with relative driver paths.
You can access the odbc.ini file from the following directory on the machine that runs the Data Integration Service:
$INFA_HOME/ODBC7.1/
Replace the absolute driver paths with relative driver paths. For instance, if you use the DataDirect Greenplum Wire Protocol driver, by default, the odbc.ini file contains the following driver entries:
[Greenplum Wire Protocol] Driver=/data/opt/cloudera/parcels/INFORMATICA/ODBC7.1/lib/DWgplm27.so Description=DataDirect 7.1 Greenplum Wire Protocol
Update the driver entries as follows to replace the absolute driver path with a relative driver path:
[Greenplum Wire Protocol Driver=./lib/DWgplm27.so Description=DataDirect 7.1 Greenplum Wire Protocol
Changes take effect after you recycle the Data Integration Service.

0 COMMENTS

We’d like to hear from you!