Use Secure Impersonation with Cloudera

Parent Topic

• Use Secure Impersonation with Cloudera

Procedure

1. Navigate to the pentaho-server\pentaho-solutions\system\kettle\plugins\pentaho-big-data-plugin\hadoop-configurations\chd59 folder and open the config.properties file with a text editor.

2. Modify the config.properties file with the values in the following table:

   Parameter	Value
   pentaho.authentication.default.kerberos.principal	​exampleUser@EXAMPLE.COM
   pentaho.authentication.default.kerberos.keytabLocation	Set the Kerberos keytab. You only need to set the password or the keytab, not both.
   pentaho.authentication.default.kerberos.password	Set the Kerberos password. You only need to set the password or the keytab, not both.
   pentaho.authentication.default.mapping.impersonation.type	simple
   pentaho.authentication.default.mapping.server.credentials.kerberos.principal	exampleUser@EXAMPLE.COM
   pentaho.authentication.default.mapping.server.credentials.kerberos.keytabLocation	You only need to set the password or the keytab, not both.
   pentaho.authentication.default.mapping.server.credentials.kerberos.password	You only need to set the password or the keytab, not both.
   pentaho.oozie.proxy.user	Add the proxy user's name if you plan to access the Oozie service through a proxy. Otherwise, leave it set to oozie.

   In this table, exampleUser@EXAMPLE.COM is provided as a sample of how you would specify your proxy user. If you have key-value pairs in your existing config.properties file that are not security related, merge those settings into the file.

3. Save and close the config.properties file.

4. Copy the config.properties file to the following folders:

   design-tools/report-designer/plugins/pentaho-big-data-plugin/hadoop-configurations/cdh59/config.properties
   design-tools/metadata-editor/plugins/pentaho-big-data-plugin/hadoop-configurations/cdh59/config.properties
   design-tools/data-integration/plugins/pentaho-big-data-plugin/hadoop-configurations/cdh59/config.properties

   .

5. Restart the Pentaho Server

Parent Topic

• Use Secure Impersonation with Cloudera

Procedure

1. Navigate to the design-tools\data-integration\plugins\pentaho-big-data-plugin\hadoop-configurations\cdh59 folder and open the mapred-site.xml file with a text editor.

2. Navigate to the pentaho-server\pentaho-solutions\system\kettle\plugins\pentaho-big-data-plugin\hadoop-configurations\cdh59 folder and open the mapred-site.xml file with a text editor.

3. Add the following two properties to the two mapred-site.xml files:

   <property>
     <name>mapreduce.app-submission.cross-platform</name>
     <value>true</value>
   </property>
   <property>
     <name>mapreduce.framework.name</name>
     <value>yarn</value>
   </property>

4. Save and close the files.

Parent Topic

• Use Secure Impersonation with Cloudera

Procedure

1. Download the Cloudera Impala JDBC driver for your operating system from the Cloudera web site http://www.cloudera.com/downloads/connectors/impala/jdbc/2-5-29.html.

   NoteSecure impersonation with Impala is only supported with the Cloudera Impala JDBC driver. You may have to create an account with Cloudera to download the driver file.

2. Extract the ImpalaJDBC41.jar file from the downloaded zip file into the folder pentaho-server/pentaho-solution/system/kettle/plugins/pentaho-big-data-plugin/hadoop-configurations/cdh59/lib. The ImpalaJDBC41.jar file is the only file to extract from the downloaded file.

3. Connect to a secure CDH cluster.

   If you have not set up a secure cluster, complete the procedure in the article Set up Pentaho to Connect to a Cloudera Cluster to set up a secure cluster.

4. Start the PDI Client and choose File New Transformation to add a new transformation.

5. Click the View tab, then right-click Database Connections and choose New.

6. In the Database Connection dialog box enter the values from the following table:

   Field	Value
   Connection Name	User-defined name
   Connection Type	Cloudera Impala
   Host Name	Hostname
   Database Name	default
   Port Number	21050

7. Click Options in the left pane of the Database Connection dialog box and enter the parameter values as shown in the following table:

   Parameter	Value
   KrbHostFQDN	The fully qualified domain name of the Impala host
   KrbServiceName	The service principal name of the Impala server
   KrbRealm	The Kerberos realm used by the cluster

8. Click Test when your settings are entered.

Results

Parent Topic

• Use Secure Impersonation with Cloudera

Parent Topic

• Use Secure Impersonation with Cloudera