O'Reilly logo

Pentaho Analytics for MongoDB Cookbook by Harris Ward, Joel Latino

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 2. The Thin Kettle JDBC Driver

In this chapter, we will cover the following recipes:

  • Using a transformation as a data service
  • Running the Carte server in a single instance
  • Running the Pentaho Data Integration server in a single instance
  • Defining a connection using a SQL Client (SQuirreL SQL)

Introduction

The Thin Kettle JDBC Driver provides a means for a Java-based client to query the results of a transformation.

It is a new concept pioneered by Matt Casters, (@mattcasters), the Chief Architect of Data Integration at Pentaho and Kettle project founder. It allows any Java-based, JDBC-compliant tool, including third-party reporting systems, to execute a query against a predefined Kettle transformation. This works a lot like a traditional SQL query. ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required