PowerExchange for HBase User Guide

PowerExchange for HBase User Guide

Configuration

Configuration

Configure Informatica Data Services to use PowerExchange for HBase.
To use PowerExchange for HBase to access data in an HBase table, perform the following tasks:
  • On the Developer tool machine, verify that the Hadoop Distribution Directory property in the
    developerCore.ini
    file is set based on the Hadoop distribution that you use.
    The
    developerCore.ini
    file is located in the following directory:
    <Informatica installation directory>\clients\DeveloperClient\
    The following table lists the Hadoop Distribution Directory property value that you must set for different Hadoop distributions:
    Hadoop Distribution
    Hadoop Distribution Directory Property Value
    Amazon EMR
    -DINFA_HADOOP_DIST_DIR=hadoop\amazon_emr5.4.0
    Azure HDInsight
    -DINFA_HADOOP_DIST_DIR=hadoop\HDInsight_3.6
    Cloudera CDH
    -DINFA_HADOOP_DIST_DIR=hadoop\cloudera_cdh5u10
    Hortonworks HDP
    -DINFA_HADOOP_DIST_DIR=hadoop\hortonworks_2.6
    IBM BigInsights
    -DINFA_HADOOP_DIST_DIR=hadoop\biginsights_4.1
    MapR
    -DINFA_HADOOP_DIST_DIR=hadoop\mapr_5.2.0
    By default, the Hadoop Distribution Directory property value is set for a Cloudera distribution.
  • If you want to import an HBase table from a Hadoop cluster where Ranger is enabled, create a user in Ranger with the same name as the Windows NT Login user that launches Informatica Client. Verify that the user in Ranger has Create and Read privileges on the HBase table to import.