IBM InfoSphere Information Server is a data integration platform used to understand, cleanse, monitor and transform data. The offerings provide massively parallel processing (MPP) capabilities.
N/A
Oracle Warehouse Builder
Score 8.7 out of 10
N/A
Oracle Warehouse Builder (OWB) is a data-warehousing centered data integration solution, from Oracle. It offers basic ETL functionality for building a simple data warehouse, as well as advanced ETL functionality supporting enterprise data integration projects, along with connectivity for Oracle and SAP applications.
I particularly believe that Information Server, especially DataStage, is superior in many aspects to the Oracle Data Integrator tool. Several market analysts such as Gartner and / or Forrester better position DataStage on the Oracle solution.
Information Server and Informatica PowerCenter are the two leading integration platforms worldwide. Information Server has a better integration with other IBM products such as MDM or Cognos but the decision to use one or another platform is more a price decision and quantity of …
Information can be used for large but simple implementation. InfoSphere provides more intergaration options with outside world. Abinitio is great product but stopped innvoating and is not kept up to date with market needs and changes. Talend is good new product. Good Big Data …
I think that Oracle Warehouse Builder is easier to use the Oracle Data Integrator (ODI). The connections in Oracle Warehouse Builder (OWB) are easier to understand when troubleshooting. Anything that makes troubleshooting easier gets higher marks in my book. ODI wins in the …
Depending on investment, I would prefer Oracle Data Integrator, since it complies with all versions of all types of databases including Big Data, Hadoop and NoSQL environment as well as the cloud and is the strategic heterogenous data integration product of Oracle, as it is …
Currently we work with Informatica and compared to OWB Informatica is a little bit more difficult to use, however Informatica has more features and is a more powerful BI tool.
You can use infosphere: -If you have multiple targets and source systems and they are different than each other. -If your infostructure is so big and unplaned well so you can't find what you want to see. -If your databases not so strong to process your data
If you plan to upgrade your databases to newer versions, you need to migrate your Oracle Warehouse Builder jobs to Oracle Data Integrator (fastest and easiest way) or an other ETL tool, because Oracle Warehouse Builder came to an end and does not support newer versions of databases as it is described in statement of direction. There will be no major releases of Oracle Warehouse Builder (latest release is 11GR2 - 11.2.0.4), but bug resolving and minor releasing will continue.
I particularly believe that Information Server, especially DataStage, is superior in many aspects to the Oracle Data Integrator tool. Several market analysts such as Gartner and / or Forrester better position DataStage on the Oracle solution.
I think that Oracle Warehouse Builder is easier to use the Oracle Data Integrator (ODI). The connections in Oracle Warehouse Builder (OWB) are easier to understand when troubleshooting. Anything that makes troubleshooting easier gets higher marks in my book. ODI wins in the heavy lifting and enterprise solution realm. ODI is much easier to implement at that level. The web interface that can be setup for business users to kick off scenarios is better than the interface that we can give access to in OWB.
Information Server can positively impact the costs of companies by increasing the productivity of development and therefore reduce their time and costs. It is estimated that DataStage can increase a developer's productivity by 40% on average.
OWB allows you to quickly develop even complex ETLs thus saving lots of time for the developers to work on other things. I would say OWB is a very convenient and easy to use tool.