Oracle Data Service Integrator vs. Oracle Warehouse Builder

Overview
ProductRatingMost Used ByProduct SummaryStarting Price
Oracle Data Service Integrator
Score 6.4 out of 10
N/A
Oracle Data Service Integrator provides companies the ability to develop and manage federated data services for accessing single views of disparate information. Oracle Data Service Integrator is standards based, declarative, and enables re-usability of data services.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.N/A
Pricing
Oracle Data Service IntegratorOracle Warehouse Builder
Editions & Modules
No answers on this topic
No answers on this topic
Offerings
Pricing Offerings
Oracle Data Service IntegratorOracle Warehouse Builder
Free Trial
NoNo
Free/Freemium Version
NoNo
Premium Consulting/Integration Services
NoNo
Entry-level Setup FeeNo setup feeNo setup fee
Additional Details
More Pricing Information
Community Pulse
Oracle Data Service IntegratorOracle Warehouse Builder
Top Pros
Top Cons
Features
Oracle Data Service IntegratorOracle Warehouse Builder
Data Source Connection
Comparison of Data Source Connection features of Product A and Product B
Oracle Data Service Integrator
-
Ratings
Oracle Warehouse Builder
9.5
5 Ratings
14% above category average
Connect to traditional data sources00 Ratings10.05 Ratings
Connecto to Big Data and NoSQL00 Ratings9.02 Ratings
Data Transformations
Comparison of Data Transformations features of Product A and Product B
Oracle Data Service Integrator
-
Ratings
Oracle Warehouse Builder
10.0
5 Ratings
17% above category average
Simple transformations00 Ratings10.05 Ratings
Complex transformations00 Ratings10.04 Ratings
Data Modeling
Comparison of Data Modeling features of Product A and Product B
Oracle Data Service Integrator
-
Ratings
Oracle Warehouse Builder
8.2
5 Ratings
0% above category average
Data model creation00 Ratings10.04 Ratings
Metadata management00 Ratings6.04 Ratings
Business rules and workflow00 Ratings9.04 Ratings
Collaboration00 Ratings8.94 Ratings
Testing and debugging00 Ratings7.04 Ratings
Data Governance
Comparison of Data Governance features of Product A and Product B
Oracle Data Service Integrator
-
Ratings
Oracle Warehouse Builder
8.0
3 Ratings
3% below category average
Integration with data quality tools00 Ratings8.03 Ratings
Integration with MDM tools00 Ratings8.02 Ratings
Best Alternatives
Oracle Data Service IntegratorOracle Warehouse Builder
Small Businesses

No answers on this topic

Skyvia
Skyvia
Score 9.6 out of 10
Medium-sized Companies
SAP HANA Cloud
SAP HANA Cloud
Score 8.5 out of 10
InfoSphere
InfoSphere
Score 8.2 out of 10
Enterprises
Delphix
Delphix
Score 8.9 out of 10
InfoSphere
InfoSphere
Score 8.2 out of 10
All AlternativesView all alternativesView all alternatives
User Ratings
Oracle Data Service IntegratorOracle Warehouse Builder
Likelihood to Recommend
6.5
(2 ratings)
8.0
(5 ratings)
User Testimonials
Oracle Data Service IntegratorOracle Warehouse Builder
Likelihood to Recommend
Oracle
Once Oracle Data Service Integrator is set up properly, it is quite simple to snatch data from a myriad of disparate sources and put them into a single repository. Due to cost factors, it is not for the faint of heart; however, if you can handle it, the benefits will quickly outpace the initial investment. To take full advantage of the power of ODSI, I would recommend the training that Oracle provides.
Read full review
Oracle
The best place for Oracle Warehouse Builder is at the business IT level. It's not suited for business-level users. They are easy confused. One way to reduce the confusion for the developers is to set up the workspaces based on the requirements that are discovered in design sessions. Once this is complete, the implementation of Oracle Warehouse Builder can take flight and be successful.
Read full review
Pros
Oracle
  • Very easy to use. Very easy to just grab data when needed.
  • Very robust and has so many features to move and transform data.
  • Functionality is very easy to implement with other Oracle data products.
Read full review
Oracle
  • Easy transformation.
  • Easy implementation from Oracle to Oracle systems.
  • Ease of usage and easy to learn.
  • Starting component of metadata management.
Read full review
Cons
Oracle
  • If not bundled with other products, the price can be prohibitively expensive
  • SAP connectors tend to be a little expensive and slightly difficult to use
  • The audit module had some difficulties debugging failed instances
Read full review
Oracle
  • What I noticed is that sometimes OWB doesn't generate the best SQL in the package especially when there are a high number of source tables in the ETL. It would be nice if ETL developers were allowed to update the generated packages in the database directly.
  • Another thing - moving OWB ETLs from one database to another one could be easier - for example it would be nice to just copy the generated packages from one database to the other one without doing the deployment of these ETLs through OWB.
Read full review
Alternatives Considered
Oracle
While we tested and evaluated multiple data service providers, we came to choose Oracle Data Service Integrator since our infrastructure was so heavily dependent on Oracle software. The implementation would be easier and the difference in the number of features and performance wasn't enough to sway us in another direction.
Read full review
Oracle
Ab>initio, IBM Datastage 8.0
Read full review
Return on Investment
Oracle
  • It provided terrific bulk data movement and data transformation services which we desperately needed
  • It allowed to reduce development costs and lower the total cost of ownership among disparate architectures
  • The enterprise edition's ELT allowed us to generate native code for wildly varied RDBMS
Read full review
Oracle
  • It improved understanding of ETL functions. Data is consistent. The speed is pretty good.
Read full review
ScreenShots