Getting Started with MIIS 2003 Walkthrough: Scenario Design

Applies To: Windows Server 2003 with SP1

Previous Steps in This Walkthrough

  1. Overview

A corporation maintains an employee database that tracks employee office information based on employee ID number. It maintains a separate database for its telephone system that stores current telephone numbers for employees. The telephone information is also indexed by the employee ID number.

The group managing the employee database wants current telephone information stored in its database; however, all telephone data must come from the telephone database.

MIIS 2003 can be used to solve this problem by importing the employee and telephone data and then exporting the telephone data to the employee database.

The Testing Environment

This walkthrough assumes the procedures are being performed on a single stand-alone server named FabrikamSVR with the following software installed:

  • Windows Server 2003, Enterprise Edition

  • SQL Server 2000 Enterprise Edition

  • Microsoft Identity Integration Server (MIIS) 2003 Service Pack 1.

    Note

    To avoid the possibility of interfering with your identity management environment, the procedures in this walkthrough should not be performed on an MIIS 2003 server that is currently acting as part of the identity management infrastructure in your production environment.

  • For complete instructions on how to build and configure the test environment for this walkthrough, see Lab Setup.

Sample Data

The scenario presented in this document requires two comma delimited text files. One file, named Employees.txt, represents data maintained by the employee database and contains the employee ID number, employee name, location, and status. The following table lists the sample employee data for this walkthrough.

Employee ID Employee Name Location Status

US124423

Mike Danseglio

A2373

Active

US385548

Christa Geller

B1142

Active

US448502

Jeune Ji

B4718

Active

US567739

Ken Kwok

A3177

Inactive

US432884

Esther Valle

D9932

Active

The second file, named Phone.txt, represents data maintained by the telephone system and contains the employee ID number and telephone number. The following table lists the sample telephone data for this walkthrough.

Employee ID Telephone Number

US448502555

2846

SVR00319555

3833

US124423555

6723

US567739555

8217

US432884555

9943

Walkthrough Steps

All of the employee data with the exception of each employee’s telephone number is stored in the Employees.txt file. You will create an MIIS 2003 solution to import the telephone data from the telephone system and add it to the employee data. The solution involves the following steps:

  • Prepare the data sources.

  • Create management agents.

  • Stage the data.

  • Synchronize the data within MIIS 2003

  • Perform inbound synchronization.

  • Perform outbound synchronization.

  • Export the synchronized data to the employee database.

Next