Getting Started with MIIS 2003 Walkthrough: Scenario Design
Applies To: Windows Server 2003 with SP1
Previous Steps in This Walkthrough
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.