My first transformation with the CMIS Input

The use of the PDI CMIS Input is exactly the same of an Input plugin like, for example, the Table Input. Below a simple tutorial that shows how to develop the first transformation using the CMIS Input Plugin.

Below a simple step by step description of how to develop a simple transformation to extract the informations from the E.C.M. using CMIS Input plugin.

  • Run Pentaho Data Integration (Kettle) executing the ‘spoon.bat’ under Windows platform or ‘spoon.sh’ under Linux platform.
  • In the repository connection form, press the ‘Cancel’ button.

PDI_screenshot_1

  • Now create a brand new transformation.

PDI_screenshot_2

  • Drag & drop the Cmis Input icon on the Input folder of the left menu in the Design tab.

PDI_screenshot_3

  • Double click on the CMIS Input icon to open the dialog.

PDI_screenshot_4

  • Customize the connection’s parameters of the CMIS Query and press the ‘ok’ button.
  • Drag & drop the Text file output icon on the Output folder of the left menu in the Design tab. After this, connect the two icons from the CMIS Input to the Text file output.

PDI_screenshot_5

  • Customize the parameters of the Text file Output and press the ‘ok’ button.

PDI_screenshot_6

  • Click on the fields tab and press the ‘Get fields’ button. The destination fields will be automatically filled with the metadata.

PDI_screenshot_7

  • Press the ‘ok’ button, save the transformation and run it pressing the green arrow.

PDI_screenshot_8

  • At the end, open the destination file and see all the metadata of you documents.

<< How-to install PDI CMIS Input                                 Basics about the CMIS >>

Download PDI CMIS Input plugin

2 thoughts on “My first transformation with the CMIS Input

  1. Hi,
    I’m really interested on your project, that will be awesome just if the cmis – query could be set like a parameter on the component like user, pass etc, that must be not a great problem,.. is it?

  2. Francesco Corti

    Hi Vladimir,

    Thank you for the feedback and suggestion.
    I always appreciate contributions especially on new features because I don’t have many clues on what the community would like to see more (or different) in the plugin.

    Coming to your specific question: ehm, it does!
    I know this is not well documented but you can insert variables also into the CMIS query.
    To see a real life example, please, take a look to the AAAR plugin: it uses the CMIS Input plugin in its Kettle transformations and it is developed more than one dynamic CMIS query. 😉

    If you like the project, please click “like” or leave comments about it in the main sites (sourceforge, ecc.).
    Thank you in advance for that.

Leave a Reply

Your email address will not be published. Required fields are marked *

Time limit is exhausted. Please reload CAPTCHA.