RdsDictionaryConverter

Assembly: Rds;

Description

The RdsDictionaryConverter class is used to convert an MDM dictionary to a table MDM dictionary.

Comments

If MDM repository contains outdated dictionary types: MDM dictionaries and composite MDM dictionaries, then convert those dictionaries into table MDM dictionaries. Foresight. Analytics Platform does not support outdated dictionary types.

Converted table MDM dictionaries are more powerful and support working with a big number of elements. Conversion enables the use of a separate data storage table that will be created in any place of the repository and not only in the MDM repository.

An MDM dictionary is converted taking into account permissions and privileges of the user who executes this operation:

The user must have valid access permissions for the source dictionary, to read, edit and delete its data.
The user must have read permission for the MDM repository that contains the source dictionary and database of this MDM repository.
If the Use Application Role checkbox is active for the MDM repository database, the user must have permissions to create tables in DBMS.

Restrictions and features of converting an MDM dictionary to a table MDM dictionary:

You cannot convert an MDM dictionary that contains attributes that may have multiple values.
You cannot convert a version MDM dictionary.
You cannot convert an MDM dictionary that contains the GUID attribute.
On converting related MDM dictionaries, first translate the dictionary that is referred to, and then the dictionary that refers to it
It is not allowed to convert an MDM dictionary that contains import or export scheme with the P7_RDS_CONVERT_OBJECT_SCHEMA identifier.

The table dictionary obtained after conversion has the same parameters, settings, attributes, data, configured security subjects and access permissions, import and export schemas, and object key.

NOTE. Converting may result in error, if the metadata schema was previously moved from Microsoft SQL Server 2008 to Microsoft SQL Server 2012. Moving of schemas between different DBMS versions is not supported because of difference in SQL syntax, that is why MDM dictionaries will not be converted.

Class object properties inherited from IRdsDictionaryConverter

	Property name	Brief description
	AllDictionary	The AllDictionary property returns the list of MDM dictionaries converted to table MDM dictionaries.

Class object methods inherited from IRdsDictionaryConverter

	Method name	Brief description
	AllRdsDatabase	The AllRdsDatabase method checks MDM repository and returns the list of MDM dictionaries converted to table MDM dictionaries.
	Convert	The Convert method converts an MDM dictionary to a table MDM dictionary.
	ConvertAll	The ConvertAll method converts all MDM dictionaries to table MDM dictionaries.