Remove Invalid Characters and Deduplicate

This accelerator replaces invalid characters found in the target.name.systemName field of RECORD and CONTAINER documents and creates a unique name. This is useful for ensuring that the target system does not encounter any incompatible characters that would cause issues in the load stage of the migration.

Furthermore, this accelerator deduplicates the target.name.systemName for RECORD and CONTAINER documents within each container. It does this by adding a underscore with a number at the end of the name. This ensures that all transformed hierarchies are unique.

Settings

mongoConnection

The Mongo connection string including the database name to connect to.

replacementChar

The character that will replace the invalid characters.

invalidChars

The characters that will be replaced by the replacementChar. Example: [":", "<", ">", "?", "/", "\\\\", "|", "~", "#", "{", "}", "&"]

systemNameContainsExtension

When set to true, the underscore together with the number will be added before the extension. When set to false, it will be added to the end of the name. Can either be true or false.

uniqueNameContainersAndRecords

When set to true, both RECORD and CONTAINER names will be deduplicated when they are in the same container. When set to false, a RECORD and CONTAINER may have the same name in their container. Can either be true or false.