Re: MIIS
- From: Jared Still <jkstill@xxxxxxxxx>
- To: ian@xxxxxxxxxxxxxxxxx
- Date: Mon, 15 Nov 2004 18:07:09 -0800
This sounds a lot like the Sybase Replication product.
Big surprise, eh?
If it is, it must operate via triggers, which may put quite
a load on your system.
I took the Sybase Replication class about 4 years ago,
so it may have changed since then, but I wouldn't be
surprised if it still required triggers.
Jared
On Mon, 15 Nov 2004 18:00:11 -0800, MacGregor, Ian A.
<ian@xxxxxxxxxxxxxxxxx> wrote:
> 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
>
--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
--
//www.freelists.org/webpage/oracle-l
Other related posts:
