This content has been marked as final. Show 4 replies
Mark1970 wrote:Oracle corporation's statement of direction says ODI is their strategic ETL tool and if you and investing into Oracle ETl for the 1st time then it is better to invest in ODI .
Having to decide whether to choose Oracle Data Integrator or Oracle Warehouse Builder like tool for creating a dataware house and loading data into it, what should I choose and why?
I'm an old pl/sql developer but new on datawarehousing (I've been dealing with it for few months) and I'd like to undestand what fits better for me. It seems to me that OWB and ODI look not very different to each other, don't they?
My Oracle vers. is 10gR2
OWB will be supported and finally OWB and ODI will get merged into a single tool.
For a pl/sql guy like you , the code generated by OWB is easy to understand as OWB mainly generates pl/sql code ( apart from sql loader and sap abap code ) . But that should not deter you to use ODI as ODI generates mainly SQL code (plus sove native code depending upon the technology used and KM) .
Thanks for the advice, but as I've got 10gR2, does Oracle Data Integrator work on it? It seems to me that Oracle Data Integrator is only for 11g, or am I mistaken?
1 person found this helpful
Mark1970 wrote:Yes .. it can work on 10gR2
Thanks for the advice, but as I've got 10gR2, does Oracle Data Integrator work on it?
It seems to me that Oracle Data Integrator is only for 11g, or am I mistaken?Which version you are talking about ?
Looking here http://www.oracle.com/technetwork/middleware/data-integrator/downloads/index.html I see that it refers only to ODI 11g versions but if you say that ODI 11g works on database 10gR2 as well, it's oK