Ambari (Administration Manual)
Apache Hadoop Key Management Server (KMS)
Accessing CDAP Datasets through JDBC and ODBC
Many Business Intelligence tools can integrate with relational databases using JDBC or ODBC drivers. They often include drivers to connect to standard databases such as MySQL or PostgreSQL. Most tools allow the addition of non-standard JDBC drivers.
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 includes the use of Pentaho.