Sqrrl
Note: This capability is not available at this time.
This page describes Pentaho's integration with Sqrrl.
Sqrrl Input Step
The Sqrrl Input Step allows a DI Developer to connect to a Sqrrl server, enter a Sqrrl query, and get results back for use within a PDI Transformation. Define your connection settings, query, and then get the fields on the fields tab to determine the query metadata. Once you've completed those steps, it's now possible to stream data from Sqrrl into your transformation.
Prerequisites
Before using the Sqrrl Input Step, you must have read access to a Sqrrl server. Please contact the Sqrrl system administrator for Host and Port details.
Connection Settings
Option |
Description |
---|---|
Host name or IP Address |
The host name or IP address of the Sqrrl server. |
Port |
The port of the Sqrrl server, the default value is 42425, but your administrator may have changed the port number. |
Username |
The username to authenticate with. |
Password |
The password to authenticate with. |
Query Definition
Option |
Description |
---|---|
Execute for Each Row |
If checked, for each row of data coming into the step, a new query will be issued. It's possible to reference incoming fields of data using the ?{<Field>} syntax. For instance, if you wanted to use the incoming field "Size" to drive the limit of results coming in, you could define the following query: select * limit ?{Size} |
Sqrrl dataset |
The name of the dataset to read from |
Sqrrl query expression |
The Sqrrl expression to execute. Please see Sqrrl Documentation for correct syntax. |
Sqrrl Output Step
The Sqrrl Output Step allows a DI Developer to connect to a Sqrrl server, and write records to a dataset.
Prerequisites
Before using the Sqrrl Output Step, you must have write access to a Sqrrl server. Please contact the Sqrrl system administrator for Host and Port details.
Connection Settings
Option |
Description |
---|---|
Hostname |
The host name or IP address of the Sqrrl server. |
Port |
The port of the Sqrrl server, the default value is 42425, but your administrator may have changed the port number. |
Username |
The username to authenticate with. |
Password |
The password to authenticate with. |
Socket Timeout |
The amount of time the socket should stay open without receiving information from the server. |
Output Options
Option |
Description |
---|---|
Dataset |
The name of the dataset to write to |
Truncate dataset |
If true, this deletes the dataset and recreates it based on the same metadata of the previous version |
Fields
The Fields table allow mapping of incoming fields to a Sqrrl JSON submission. To allow for updating, specify Y in the "Update UUID Field" column for the field that references the UUID. To prevent null UUIDs from being written as new entries, specify "Update" only as the write "Modifier apply policy".