WhereScape RED provides a facility for defining and managing extended database properties which can be used in a range of scenarios, one of the motives for their introduction was to aid interaction with the variety of new database technologies that RED customers want to exploit for their Business Intelligence infrastructure
To support these emerging database technologies, WhereScape provides enablement packs for a variety of target "custom" database types, which includes Snowflake, Amazon Redshift and Microsoft Azure SQL data warehouse.
One component of these packs is a set of extended properties to facilitate the connection to a specific database technology.
This feature also supports importing a set of extended property definitions into RED from an external source, and exporting extended properties defined in RED to a file. This enables you to migrate and reuse extended property definitions between different repositories.
Using the extended properties feature involves defining the extended properties to specify the variables and their scope; and then assigning values to the defined extended properties.
Extended Property Definitions
Extended property definitions primarily consist of a unique name and a scope (database type and object type), which specifies where the extended property will be available.
The extended property definitions are created and maintained in the Extended Properties Maintenance screen.
Extended Property Value Assignment
Once an extended property has been defined for a connection or table object, users can then assign values to each of the variable attributes available in the extended property.
The extended property values are specified and maintained in the Extended Properties settings in the Connection or Table object's Properties screen.
Extended Property Lookup
The extended property variables and their assigned values are referenced in PowerShell scripts. PowerShell script-based processing is available for all objects in a custom database target. However, in a non-custom database target, PowerShell scripts are only available to process Load and Export objects.
WhereScape provides a specialized enablement pack for custom database customers for their database platform, which includes a utility template with extended property lookup functions. For more information, please contact your WhereScape representative.