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.
To get ready for this recipe, you first need to start Spoon and the MongoDB server with the same database from the previous chapter.
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:
chapter1-using-mongodb-aggregation-framework.ktrfile and save it as
chapter2-using-mongodb-aggregation-framework-kettle-thin.ktr. Change the transformation name to
MongoDB Aggregation Kettle Thin.
Define a Data Service for this new transformation.
Open the Transformation settings dialog. There are two ways of doing this. One is to press Ctrl + T, right...