Cloudera
Overview: Utilizing CDAP on Cloudera Enterprise Data Hub
Configuring and Installing: Configuring and installing CDAP using Cloudera Manager (Administration Manual)
Ingestion and Exploration: Ingesting and exploring data using Impala
Ambari (Administration Manual)
Configuring and Installing: Configuring and installing CDAP using Ambari (Administration Manual)
Apache Sentry
Integrations: Configuring and integrating CDAP with Apache Sentry
Apache Ranger
Integrations: Configuring and integrating CDAP with Apache Ranger
...
Two business intelligence tools—SquirrelSQL and Pentaho Data Integration—are covered, explaining connecting them to a running CDAP instance and interacting with CDAP datasets.
The example Analyzing CDAP Data from BI Tools/wiki/spaces/KB/pages/482902019 includes the use of Pentaho.
CDAP JDBC Driver: A JDBC driver provided with CDAP to make integrations with external programs and third-party BI (business intelligence) tools easier.
CDAP ODBC Driver: An ODBC driver provided for CDAP to allow integration with external Windows programs.
Pentaho Data Integration: An advanced, open source business intelligence tool that can execute transformations of data.
SquirrelSQL: A simple JDBC client which executes SQL queries against many different relational databases.