Requirements for Ranger integration with Db2 Big SQL

If Ranger is enabled in IBM® Cloud Object Storage when there is a connection to a remote Cloudera Data Platform (CDP) Hadoop cluster, some configuration on the remote Hadoop cluster is required.

Ranger is supported when you connect Db2® Big SQL to remote Hadoop clusters on CDP 7.1.7.

For more information, see Enabling and disabling Ranger security support for Db2 Big SQL.

To configure the remote Hadoop cluster, complete the following steps:
  1. Update the download.auth properties for the Hive plugin by adding db2inst1, as shown in the following screen capture. Ensure that there are no blank spaces after the commas.
    Screen capture showing the download.auth properties for the Hive plugin
  2. Add the db2inst1 user to the HDFS ACL for the warehouse directory. For details, see Preparing to install Db2 Big SQL.