Migrator for Notes to Exchange 4.16.1

This section applies only if your AD/Exchange environment is configured for a resource forest and a user forest, with corresponding user accounts. In that case, you must configure the Global Default Settings in Notes Migration Manager, and then prepare (or verify) the values in a column of the exported directory data, for the Data Migration Wizard to properly associate the resource accounts with the user accounts and properly enable mailboxes.

Before you begin, you must determine which column in the SQL database will correspond to which AD attribute, for the wizard to match corresponding user accounts in the resource forest and user forest. The column (AdSearchCol) and attribute (AdAttribute) are both specified in the [ActiveDirectory2] section of the Global Default Settings of Notes Migration Manager:

•

AdSearchCol: The column in the SQL database whose values the program should search for each particular AdAttribute value, to match corresponding user accounts in the resource forest and user forest. Note that the column specified here and its per-user values must exist before the Data Migration Wizard is run.


	IMPORTANT: In the current Migrator for Notes to Exchange version, this AdSearchCol parameter value must be set to SearchKey2 (the default for this parameter) for the mailbox-enabling process to succeed.

•

AdAttribute: The AD attribute whose values the program should read in the AdSearchCol column of the SQL database, to match corresponding user accounts in the resource and user forests. For example:

[ActiveDirectory2]
AdSearchCol=SearchKey2
AdAttribute=userPrincipalName

... tells the wizard to match AD objects with users such that the value of each AD object’s userPrincipalName attribute matches the value of the corresponding user’s SearchKey2 column in the SQL database.

To configure the Global Default settings:

Within Notes Migration Manager, select File | Global Default Settings. The program then opens the program’s configuration settings into Windows Notepad. Within Notepad, the settings look like the contents of an INI file, but they are saved as a part of the SQL database rather than as an independent INI file.

In the [ActiveDirectory2] section, set the appropriate parameter value for AdAttribute, as described above.

Close Notepad. Notes Migration Manager will then copy the new parameter value back into the SQL database.

If you need to enter or edit the AdSearchCol column values in the SQL database:

Within Notes Migration Manager, in the Export Notes Directory screen: Click Export objects to TSV. A dialog box will prompt you for a destination folder and filename for the exported file.

Use Microsoft Excel (or some other program that can edit a tsv-format file) to enter or edit the contents of the column you have designated as the AdSearchCol column.

In the Export Notes Directory screen: Click Import objects from TSV to import the edited .tsv file into the SQL database. A dialog box will prompt you for the filename and its location.

How do I add to the list of AD attributes available for the merge function?

The Provisioning Wizard associates contacts with AD objects by comparing the unique values of a particular AD object attribute to the unique values of a corresponding column in the SQL database. Where these values match, the associated contact and AD object are assumed to represent the same entity, and the two are merged. During the wizard run, the Choose Your Method... screen requires that you specify the AD attribute and the database column to use for the comparisons. You specify the attributes and columns using drop-down lists of available options for the database column and AD attribute, respectively.

By default, the list of choices for the AD attribute contains these 26 options:


	cn mail mailNickname proxyAddresses	sAMAcountName userPrincipalName targetAddress employeeNumber	distinguishedName altRecipient legacyExchangeDN	extensionAttribute1 extensionAttribute2 extensionAttribute3 ... [to 15]

The 26 defaults are defined by a series of ADML[#] parameters in the [ActiveDirectoryMatchList] section of the Global Defaults and Task Parameters:

[ActiveDirectoryMatchList]
Count=26
ADML0=cn
ADML1=mail
ADML2=mailNickname
ADML3=proxyAddresses
ADML4=sAMAccountName
[...]
ADML25=extensionAttribute15

If the AD attribute you want to use is not among the 26 defaults, you can add one or more other attributes to the list by defining each addition in the Global Defaults or Task Parameters. See How do I add or edit program parameters? above for the procedure to add and edit these parameter(s):

•

ADML[#]=<AttribName>

Each ADML[#] parameter names an AD attribute that the Provisioning Wizard will include in its list of options, from which one attribute must be chosen to facilitate the matching of contacts with AD objects. The digit(s) appended to an ADML[#] key name differentiate one parameter from another. The multiple ADML[#] parameters need not appear in numerical order, and need not form an unirupted numerical sequence. But the wizard will read only ADML[#] parameters whose differentiating digits are less than a value specified by a Count parameter (see below).


	NOTE: Migrator for Notes to Exchange’s Provisioning Wizard merge function requires that any AD attribute added to the list be replicated to the Global Catalog. You can configure AD to replicate an attribute to the Global Catalog; see How do I configure AD to replicate an AD attribute to the Global Catalog?

•

Count=<##>

A limit to the number of ADML[#] parameters (see above) that the Provisioning Wizard will process in this section. The wizard will read only ADML[#] parameters whose differentiating digits are less than the Count parameter value. For example, if:

[ActiveDirectoryMatchList]
Count=6
ADML0=cn
ADML1=mail
ADML2=mailNickname
ADML3=proxyAddresses
ADML4=sAMAccountName
ADML5=userPrincipalName
ADML6=targetAddress
ADML7=employeeNumber

... then the wizard will read all the parameters except ADML6 and ADML7, since Count=6, and neither 6 nor 7 is less than 6.

If unspecified, the Count parameter defaults to 26. If specified, the parameter must occur as the first line of the section, as shown above.

For example: If the ADML[#] parameters are set for only their 26 defaults, and you want to add a single new AD attribute option, you would add an ADML26 parameter and change the Count parameter to 27, like this:

[ActiveDirectoryMatchList]
Count=27
ADML0=cn
ADML1=mail
ADML2=mailNickname
ADML3=proxyAddresses
ADML4=sAMAccountName
[...]
ADML25=extensionAttribute15
ADML26=NewAttributeName

How do I configure AD to replicate an AD attribute to the Global Catalog?

If the AD attribute you want to use for the Provisioning Wizard is not among the 26 defaults, you can add one or more other attributes to the list by defining each addition in the Global Defaults or Task Parameters. This procedure is explained elsewhere in this Appendix (see How do I add to the list of AD attributes available for the merge function?).

Any AD attribute added to the list must be replicated to the Global Catalog, or the merge function will fail. You can configure AD to replicate an AD attribute to the Global Catalog as explained in the following procedure:


	CAUTION: This procedure manipulates AD configuration parameters, and an error could generate adverse consequences throughout the Active Directory environment. Use extreme caution whenever manipulating AD configuration parameters in this way.