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 are 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.