Database Table

A Database Table object represents an externally-stored database table which can be queried from Grooper.

Remarks

Database Table objects do not store a copy of the data, but rather provide a placeholder object which can be used to reference the database table and create mappings between database table columns and other entities.

Database Table objects are created in the property panel for the Data Connection object, and are used by various entities throughout Grooper. For example the Database Export activity configuration includes a Data Table objects property.

Inherits from: Grooper Node

Properties

The following 1 properties are defined.

Property Name Description
General
Description Type: String

Generic property allowing an administrator to document the purpose of this Grooper Node.

Commands

Command Name Shortcut Keys Description
Add Multiple Items Creates multiple items as children of the selected object.
Clear Children Deletes all children of the selected object(s).
Database Table - Clear Table Deletes all data contained in this Database Table.
Export to Zip Archive Exports a set of Grooper nodes to a ZIP archive.
Publish to Grooper Repository Publishes one or more Nodes to one or more Target Grooper Repositories.
Unpublish Unpublishes a set of Grooper Nodes to a Target Grooper Repository.
Database Table - Update Columns Updates the columns associated with this Database Table.

Tabs

Tab Name Description
Database Table - GeneralProvides a user interface displaying column information for the Database Table as well as a preview of table data.
Grooper Node - ScriptingProvides script viewing, compilation, management, and basic editing features.
Grooper Node - ContentsProvides a user interface for viewing and managing the children of a Grooper Node.
Grooper Node - AdvancedDisplays detailed information about Grooper Node objects, and provides administrative functions for managing them.

Used By

Database Export, Embedded Extractor, Lexicon