Skip Ribbon Commands
Skip to main content
Navigate Up
Sign In

Quick Launch

Average Rating:

facebook Twitter
Email
Print Bookmark Alert me when this article is updated

Feedback

HOW TO: Use different ticket cache files to connect Hadoop cluster with different level of access while running PowerCenter session
Solution

This can be achieved using the Operating system profile in PowerCenter. 


Do the following: 

  1. Create Operating System profile users (A and B for instance).
  2. Create two directories as <INFA_HOME>/Hadoop_conf_A  and <INFA_HOME>/Hadoop_conf_B.
  3. Place your Hadoop configuration files (hive-site.xml, core-site.xml, hdfs-site.xml and under mapred-site.xml files from Hadoop cluster) in both directories created above.
  4. Ensure that the Operating System profile users exist on all the Hadoop cluster nodes.
  5. Edit core-site.xml file for user A under <INFA_HOME>/Hadoop_conf_A directory and provide path to the Kerberos ticket cache.
  6. Edit core-site.xml file for user B under <INFA_HOME>/Hadoop_conf_B directory and provide path to the Kerberos ticket cache.
  7. In the Operating System profile for user A, create environment variable as CLASSPATH and set its value as <INFA_HOME>/Hadoop_conf_A
  8. In the Operating System profile for user B, create environment variable as CLASSPATH and set its value as <INFA_HOME>/Hadoop_conf_B
    This way both users will have different CLASSPATH and different Hadoop configuration files.
    Integration service restart is not required. Its good if one could do it.
  9. Run the session with the Operating System profiles.
More Information
Reference
Applies To
Product: PowerCenter
Problem Type:
User Type: Administrator
Project Phase:
Product Version: PowerCenter
Database:
Operating System:
Other Software:
Attachments
Last Modified Date:4/12/2017 11:43 AMID:507027
People who viewed this also viewed

Feedback

Did this KB document help you?



What can we do to improve this information (2000 or fewer characters)