RE: MIIS
- From: "MacGregor, Ian A." <ian@xxxxxxxxxxxxxxxxx>
- To: "Oracle Discussion List" <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 17 Nov 2004 08:29:30 -0800
MIIS is not based on Sybase's replication product. It is software =
Microsoft acquired from another company a few years ago, and MIIS is =
their latest release on of it. It's primary purpose is to synchronize =
identity information betwee such repositories as SunOne and Active =
Directory. But, it also will synchronize such information between =
Oracle databases. It does not require any triggers. Data is pulled =
from the various participating databases and compared by MIIS. Any =
differences found are then fixed according to the rules in MIIS. The =
central SQL Server database provides an audit trail, and can also be =
accessed directly for current identiy information.
It is not as was being touted by our Windows group a solution to =
replication. Its method of identifying new records via comparing =
different datasets restricts its use to small datasets. Oracle has a =
product, Oracle Identity Manager, Tuvoli has one also, and I think Sun =
does as well.
I'm going to try to have Oracle demo theirs. =20
Ian
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx =
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of MacGregor, Ian A.
Sent: Monday, November 15, 2004 6:00 PM
To: Oracle Discussion List
Subject: MIIS
Anyone using MIIS, Microsoft Identity Integration Server, for =3D =
replication between Oracle databases. It appears it works something =3D =
like an ETL in that you map fields from one database onto fields for =
=3D another. It also maintains its own database in SQL Server so it can =
=3D perform fast refreshes. Much like at ETL data is pulled from one =
=3D database and pushed to others. Unlike an ETL which usually gathers =
=3D infromation from various sources and pushes the data out to a =
warehouse, =3D data can flow in any direction. Rules in MIIS say who is =
the =3D authorative source for the data and will even revert data back =
to the =3D value found in the authoritative source should that data be =
changed in =3D another database.
I'm not sure how all this works. Snapshots which we use quite a bit =3D =
here do not provide the same functionality. Perhaps Advanced Queuing =
=3D comes closer. Lot's of people like having a centralized place to =
=3D control data distributions which MIIS provides. I'm a bit leery of =
=3D placcing any dependency on Microsoft. The product does have =
momentum. =3D Data protection rules which we were said to be immutable =
may be changed =3D to accommodate this product.
Not to be too negative, the product does fill a need. I'm looking for =
=3D another answer.
Ian
=3D20
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
