Hitachi Vantara Pentaho Community Wiki

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migration of unmigrated content due to installation of a new plugin
Excerpt Include
Doc_Help
Doc_Help
nopaneltrue

Data Services via the Thin Kettle JDBC driver

The thin Thin Kettle JDBC driver allows a Java Driver provides a means for a Java-based client to query the results of a Kettle transformation remotely using JDBC and SQL.

Architecture

As with most JDBC drivers, there is a server and a client component to the JDBC driver.
The server is designed to run as a Servlet on the Carte server, the Pentaho Data Integration server or Pentaho Business Analytics platform.  At the time of writing only Carte is supported.

Image Removed
The client JDBC driver consists of the kettle-core.jar library which has dependencies against Apache Commons HTTP Client and Apache Commons VFS only.

Server configuration

The carte configuration file accepts a <services> block that can contain <service> elements with the following sub-elements:

  • name : The name of the service.  Only alphanumeric characters are supported at the moment, no spaces.
  • filename: The filename of the service transformation (.ktr) that will provide the data for the service
  • service_step: the name of the step which will provide data during querying.

For example:

<services>
  <service>
    <name>Service</name> 
    <filename>/home/matt/svn/kettle/trunk/testfiles/sql-transmeta-test-data.ktr</filename> 
    <service_step>Output</service_step>
   </service>
 </services>

Any Java-based, JDBC-compliant tool, including third-party reporting systems, can use this driver to query a Kettle
transformation using a SQL string via JDBC.

Just in time blending of data from multiple sources for a complete picture:

  • Connect, combine and transform data from multiple sources
  • Query data directly from any transformation
  • Access architected blends with the full spectrum of Pentaho Analytics
  • Manage governance and security of data for on-going accuracy

Image Added

This just in time, architected blending delivers accurate big data analytics based on the blended data. You can connect to, combine, and even transform data from any of the multiple data stores in your hybrid data ecosystem into these blended views, then query the data directly via that view using the full spectrum of analytics in the Pentaho Analytics platform, including predictive analytics.

Panel

Available since Pentaho Data Integration Version 5.0 GA (Enterprise Edition)

Please see the following pages for more information:

Page Tree
root@self
expandCollapseAlltrue
sortposition
excerpttrue
reversefalse