Are you afraid that offshore will deliver spaghetti code? Here are some steps to take to ensure that doesn’t happen.

Dispel the myths of Agile

Don’t make security of your OBIEE or, for that matter, any BI deployment, an afterthought. I did this presentation this week at an Oracle Users group. It illustrates ways to secure your OBIEE implementation to restrict access to users and ways to limit access to only the data they need (e.g. restrictions by cost center). It also explains how to integrate your OBIEE application with eBusiness Suite single sign-on and responsibilities. Further, if you are looking for an easy way to encrypt sensitive data in your warehouse (like social security numbers …

Back after a fairly long hiatus… I was engaged in two very interesting and very different projects and I will write about them in the coming months. Here is the case for one of them – a rather interesting conundrum – I have designed it, but if you are a data architect, I would love to hear your design ideas for a data mart…

Yes, it is time for me to stick my foot in the Kimball vs. Inmon debate. Many people have debated these two methods of building a data warehouse, including Kimball himself in this article in the Intelligent Enterprise magazine.
I am not indoctrinated to either approach. The Inmon approach works very well if you have to extract data from many different source systems, and you need an integrated business model to control the common business definitions better. In such cases, it might be very helpful to model the transactions in a …