...
The example Analyzing CDAP Data from BI Tools 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.