| Panel | |
|---|---|
|
...
Your use of this download is governed by Stonebranch’s Terms of Use, which are available at https://www.stonebranch.com/integration-hub/Terms-and-Privacy/Terms-of-Use/
...
Overview
Pentaho Data Integration provides powerful ETL (Extract, Transform and Load) capabilities. Universal Controller is integrated to orchestrate the jobs and transformations within Pentaho Data Integration platform via Carte webservice calls.
As an alternative approach, if there is no Carte webserver set-up, it is possible to use the Kitchen & Pan command line utility to execute the jobs & Transformations within the Pentaho Data Integration platform via Windows or Linux Task type in Universal Controller.
...
The current integration with Pentaho is developed using the Universal Extension functionality in Universal Controller.
...
Software Requirements for /wiki/spaces/UC71x/pages/5178050 and /wiki/spaces/UC71x/pages/5180675 Universal Template and Universal Task
Universal Agent from V7.0 supporting Universal Extension
Requires Python 3.6 or higher. Tested with the Universal Agent bundled Python distribution.
Python modules required:
requests
base64
ElementTree
...
To use thePentaho Universal Extension, you first must perform the following steps:
- This Universal Task requires the /wiki/spaces/UC71x/pages/5178443 Resolvable Credentials feature. Check that the/wiki/spaces/UC71x/pages/5177877 Resolvable Credentials Permitted system property has been set to true.
- Download the provided ZIP file.
- In the Universal Controller UI, select Configuration > Universal Templates to display the current list of /wiki/spaces/UC71x/pages/5178054 Universal Templates.
- Click Import Template.
- Select the template ZIP file and Import.
...
Trigger a Pentaho Data Integration with Repository Details as Input
Launch a Pentaho Job using *.kjb files
Define and Trigger Pentaho Job from Universal Controller Script Library
...
Name | Location | Description |
|---|---|---|
Universal Templates | https://docs.stonebranch.com/confluence/display/UC71xUC72x/Universal+Templates | User documentation for creating Universal Templates in the Universal Controller user interface. |
Universal Tasks | https://docs.stonebranch.com/confluence/display/UC71xUC72x/Universal+Tasks | User documentation for creating Universal Tasks in the Universal Controller user interface. |
Universal Extension | https://docs.stonebranch.com/confluence/display/UC71xUC72x/Universal+Extension+for+Universal+Controller | User documentation for creating Universal Extension Tasks in the Universal Controller user interface. |
Pentaho Rest-API Reference | https://help.hitachivantara.com/Documentation/Pentaho/9.1/Developer_center/REST_API_Reference | Pentaho Developer REST-API Reference |
...