A Pentaho Data Service is a virtual table that contains the output of a step in a PDI transformation. You can connect to and query a regular Pentaho Data Service from any Pentaho tool, such as Report Designer, the PDI client (Spoon), and Analyzer. You can connect to and query a streaming Pentaho Data Service from a dashboard created with CTools. For more information, see Pentaho CTools.
Note: To connect and query the Pentaho Data Service,
you need to know the data service name and have permission to run the transformation and to
access the Pentaho Server where it is
published.
Connecting to the data service from another Pentaho tool is the same as connecting to a database. The following tables describe the parameters needed to make a Pentaho Data Service connection:
| Required Parameters | Description |
|---|---|
| Connection Name | The unique name of the data service you want to access |
| Connection Type | Pentaho Data Services |
| Access | Native (JDBC) |
| Hostname | Hostname of the Pentaho Server or IP address. By default, this is localhost if running the Pentaho Server locally. |
| Port Number | Port number of the Pentaho Server the data service will run on. The default is 8080. |
| Web App Name | Name of the web application. The default value is pentaho, which is typically used by the other Pentaho tools. |
| Username | Name of a user who has permission to run the data service. |
| Password | Password for a user who has permission to run the data service. |
You can also set the following optional parameters.
| Optional Parameters | Description |
|---|---|
| proxyhostname | Proxy server for HTTP connection(s). |
| proxyport | Proxy server port. |
| nonproxyhosts | Hosts that do not use the proxy server. If there is more than one host name, separate them with commas. |
| debugtrans | Optional name of the file where the generated transformation is stored. This transformation is generated to debug it. Example: /tmp/debug.ktr. Specify the name of the transformation or a path plus the name of the transformation. |
| PARAMETER_[optionname]=value | Sets the value for a parameter in the transformation. [optionname] is the name of the parameter, and [value] is the value assigned to it. PARAMETER_ is placed before the option name. For example, if the name of the parameter is model, set the parameter: PARAMETER_model=E6530. |
| secure | Set this parameter to TRUE to use the HTTPS secure protocol connect to the data service. If you omit this parameter or set it to FALSE, the standard HTTP unsecure protocol is used. |