Kettle JDBC driver
The thin Kettle JDBC driver allows a Java client to query 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.
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>