MIIS
- From: "MacGregor, Ian A." <ian@xxxxxxxxxxxxxxxxx>
- To: "Oracle Discussion List" <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 15 Nov 2004 18:00:11 -0800
Anyone using MIIS, Microsoft Identity Integration Server, for =
replication between Oracle databases. It appears it works something =
like an ETL in that you map fields from one database onto fields for =
another. It also maintains its own database in SQL Server so it can =
perform fast refreshes. Much like at ETL data is pulled from one =
database and pushed to others. Unlike an ETL which usually gathers =
infromation from various sources and pushes the data out to a warehouse, =
data can flow in any direction. Rules in MIIS say who is the =
authorative source for the data and will even revert data back to the =
value found in the authoritative source should that data be changed in =
another database.
I'm not sure how all this works. Snapshots which we use quite a bit =
here do not provide the same functionality. Perhaps Advanced Queuing =
comes closer. Lot's of people like having a centralized place to =
control data distributions which MIIS provides. I'm a bit leery of =
placcing any dependency on Microsoft. The product does have momentum. =
Data protection rules which we were said to be immutable may be changed =
to accommodate this product.
Not to be too negative, the product does fill a need. I'm looking for =
another answer.
Ian
=20
--
//www.freelists.org/webpage/oracle-l
Other related posts:
