Using a transformation as a data service

This recipe guides you through the process of turning an existing Kettle transformation into a data service for the Thin Kettle JDBC Driver. A data service is a configuration that allows the user to query a transformation as if it were a table in a database.

Getting ready

To get ready for this recipe, you first need to start Spoon and the MongoDB server with the same database from the previous chapter.

How to do it…

We are assuming that you have MongoDB with the data generated in the previous chapters and Spoon open from the Pentaho EE version. Perform the following steps to create a data service:

1. Open the chapter1-using-mongodb-aggregation-framework.ktr file and save it as chapter2-using-mongodb-aggregation-framework-kettle-thin.ktr. Change the transformation name to MongoDB Aggregation Kettle Thin.
2. Define a Data Service for this new transformation.
   1. Open the Transformation settings dialog. There are two ways of doing this. One is to press Ctrl ...