Assembly: Rds;
The IRdsDictionaryConverter interface is used to convert an MDM dictionary to a table MDM dictionary.
IRdsDictionaryConverter
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 multiple attributes.
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.
When converting MDM dictionaries, remember that identifiers of MDM dictionary attributes must not match SQL language keywords, such as GROUP.
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.
Property name | Brief description | |
AllDictionary | The AllDictionary property returns the list of MDM dictionaries converted to table MDM dictionaries. |
Method name | Brief description | |
The AllRdsDatabase method checks MDM repository and returns the list of MDM dictionaries converted to table MDM dictionaries. | ||
The Convert method converts an MDM dictionary to a table MDM dictionary. | ||
The ConvertAll method converts all MDM dictionaries to table MDM dictionaries. |
See also: