MashZone NextGen 10.2 | Appendix | Operators | Data source operators | Terracotta DB
 
Terracotta DB
Extracts data from a preconfigured Terracotta DB server.
To use the RAQL source operator, you have to configure a Terracotta DB connection in MashZone NextGen in advance. Terracotta DB connections can be defined in the MashZone NextGen Admin console. See Manage Terracotta DB connections.
The following parameters are available.
Parameters
Description
Dataset alias
List of available Terracotta DB datasets for the configured connection aliases.
Only Dataset aliases for that you have the Usage privilege are available. Select a Dataset alias. See Manage Terracotta DB connections for details.
Refresh rate ()
Specifies the time until the source file is read in again. Default value is 12 h.
RAQL query
Input field to enter any RAQL statement.
Preset query: SELECT * FROM Dataset
Dataset is the selected entry from the Dataset Alias dropdown box.
Insert parameter ()
Inserts user defined input parameters at cursor position. The button is only clickable if at least one user input parameter, for example, Text user input, has already been inserted in the feed definition.
Expand () / Collapse ()
Expands or collapses the query input box.
Configure columns
Configures the columns of the dataset.
When selecting a dataset, schema guessing is used to derive its columns. Using 1000 records, the guessing mechanism derives the set of all unique cell definitions of those records and defines corresponding columns. Use Configure columns to display or modify that schema.
Unselect a column to exclude it from processing. Select or enter a (positive) Sample size and click Derive columns to re-run the schema guessing with a larger sample size, thereby omitting the current configuration. Note that the larger the sample size is, the longer the schema guessing takes.
Click Add column to manually add a new column. Enter a unique column name and select a data type for the new column. Note that the combination of name and type has to fit to the cell definition in the store. If not, the corresponding values will always be null. For example, if the cell definition is age with type INT and you specify age with type DOUBLE, the column definition does not fit to the cell definition and the values are null.

Copyright © 2013-2018 | Software AG, Darmstadt, Germany and/or Software AG USA, Inc., Reston, VA, USA, and/or its subsidiaries and/or its affiliates and/or their licensors.
Innovation Release