DefinitioniManage data cleansing, defined
iManage data cleansing is the work of correcting and standardising the Salesforce values that become
iManage workspace names and profile metadata, then carrying those corrections through to the workspaces that
already exist. It covers values that are inaccurate, incomplete, outdated or inconsistent in the
Accounts, Contacts and client or matter records your connector is configured on, and the processes that keep
them correct afterwards.
Three parties are involved. Salesforce holds the values and provides the tools to correct
and guard them: validation rules, picklists, Flow and bulk updates. The iManage connector, the
iManage Integration for Salesforce powered by Mitratech CaseCloud, reads those values into workspace names and
custom profiles, but neither Mitratech nor iManage documents any data cleansing or profiling tooling of its
own. Twopir Consulting does the cleansing on the Salesforce side, works with your iManage
admin on aliases and existing workspaces, and builds the checks that stop bad values coming back.
Cleansing deals with values that are wrong. Records that exist twice are a deduplication job, which we run as
a separate service. A fixed-scope assessment that ends in a findings report is a data quality audit, and the
standards and ownership model that decide what "correct" means are data quality consulting.
For how the connector is set up and mapped, read our guide to iManage Salesforce integration options, setup and pitfalls.