I am still embarking on my quest to consolidate all the AWR data from all the database into a central performance database.
My first thought to use a simple CDC tool (goldengate) failed. Goldengate will not replicate sys objects. boo.
I am in Class for ODI this week, so my curent plan is to use ODI to replicate the data from my all my sources to a single target.
So far so good, and I will update on how things go with my quest to consolidate reporting data.
If this goes well with ODI, I will will use it to also consolidate tablespace sizing data, etc from all my databases. Wahoo
My first thought to use a simple CDC tool (goldengate) failed. Goldengate will not replicate sys objects. boo.
I am in Class for ODI this week, so my curent plan is to use ODI to replicate the data from my all my sources to a single target.
So far so good, and I will update on how things go with my quest to consolidate reporting data.
If this goes well with ODI, I will will use it to also consolidate tablespace sizing data, etc from all my databases. Wahoo
No comments:
Post a Comment