OBIEE and UCM
By Raoul on Sep 02, 2008
One of the exciting things about our (former Stellent) integration into Oracle is the ease with which our products fit into the fusion middleware stack and other Oracle offerings. It's a testament to foresightedness of our development team's decision to use SOA before the term existed and to continue to develop and follow that path to get us where we are today.
I've been involved in a couple of projects recently with the Business Intelligence team and we were all very pleasantly surprised at the ease of integration between OBIEE (Oracle Business Intelligence Enterprise Edition) and UCM. Pretty much all we had to do was provide a database schema (and explanation) to the BI solution consultants and they were able to build reports and dashboards showing content access, workflow progress, subscription activity, etc. It really seems like a great solution for large businesses to track their content and workflow as part of the overall business information flow. What made things even nicer was that using web services, it's fairly simple to provide links on dashboards or reports to the actual content or workflow pages.
In the other direction, OBIEE has a component called Presentation Services that exposes all their functionality in a web interface. So for us to integrate these reports and dashboards into a WCM presentation environment or WebCenter portal is trivial too.