Greetings,
I have recently been working on a NOETIX BI upgrade that was very problematic. Since then, I have moved jobs and been asked to help with establishing a BI system more or less from scratch. In early discussions, they have told me "we already have OBIEE" and want to know if this was a viable "alternative" to something like NOETIX. Nobody really seems to be able to get their mind around starting a BI system from scratch. So, here are a couple of questions, from a newbie. So, if my terminology is flawed, please help set me straight.
Q1. Is OBIEE about the "tools" that help you build reports, cubes, dashboards, etc. or does it also drive the underlying data warehouse? NOETIX appears to me to be a "data model" more than a set of BI tools. Magnitude has preselected a set of tables from each functional group (e.g. HR - Human Resources) and has an out-of-the-box ETL that brings down those Oracle tables into their ODS database and then moves a further subset of that ODS data into the DM database, where the reports, cubes, etc. draw their data. Does OBIEE have a similar out-of-the-box "data model" that pulls the Oracle data into an ODS or are we going to have to develop our own ETL structure to populate a data model of our own making?
Q2. Does OBIEE have an ETL toolset? Since NOETIX is my only prior experience, let me compare it in this way. Does OBIEE have tools that supplant the Informatica ETL engine used by NOETIX? I am thinking Oracle Warehouse Builder is the starting point. I am assuming this is the tool set that allows you to define your sources, targets and transformations.
Let's start with those. Thanks.
Rob