CData Sync vs. Oracle Warehouse Builder

CData Sync

Oracle Warehouse Builder

Overview
Product	Rating	Most Used By	Product Summary	Starting Price
CData Sync	Score 7.0 out of 10	N/A	CData's Sync is a data pipeline tool able to connect data sources to the user's database or data warehouse, supporting at present over 200 possible sources, and a range of destinations (e.g. Snowflake, S3, Redshift), connecting on-premise or SaaS sources and destinations.	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

CData Sync

Oracle Warehouse Builder

Editions & Modules

No answers on this topic

Offerings

Pricing Offerings
CData Sync	Oracle Warehouse Builder
Free Trial
No	No
Free/Freemium Version
No	No
Premium Consulting/Integration Services
No	No

Entry-level Setup Fee

No setup fee

Additional Details

—

More Pricing Information

Community Pulse
	CData Sync	Oracle Warehouse Builder

Features

CData Sync

Oracle Warehouse Builder

Data Source Connection

Comparison of Data Source Connection features of Product A and Product B
	CData Sync 8.0 1 Ratings 3% below category average	Oracle Warehouse Builder 9.5 5 Ratings 14% above category average
Connect to traditional data sources	8.01 Ratings	10.05 Ratings
Connecto to Big Data and NoSQL	00 Ratings	9.02 Ratings

Data Modeling

Comparison of Data Modeling features of Product A and Product B
	CData Sync 7.5 1 Ratings 4% below category average	Oracle Warehouse Builder 8.2 5 Ratings 5% above category average
Collaboration	8.01 Ratings	8.94 Ratings
Testing and debugging	7.01 Ratings	7.04 Ratings
Data model creation	00 Ratings	10.04 Ratings
Metadata management	00 Ratings	6.04 Ratings
Business rules and workflow	00 Ratings	9.04 Ratings

Data Transformations

Comparison of Data Transformations features of Product A and Product B
	CData Sync - Ratings	Oracle Warehouse Builder 10.0 5 Ratings 21% above category average
Simple transformations	00 Ratings	10.05 Ratings
Complex transformations	00 Ratings	10.04 Ratings

Data Governance

Comparison of Data Governance features of Product A and Product B
	CData Sync - Ratings	Oracle Warehouse Builder 8.0 3 Ratings 1% above category average
Integration with data quality tools	00 Ratings	8.03 Ratings
Integration with MDM tools	00 Ratings	8.02 Ratings

Best Alternatives
	CData Sync	Oracle Warehouse Builder
Small Businesses	Skyvia Score 10.0 out of 10	Skyvia Score 10.0 out of 10
Medium-sized Companies	IBM InfoSphere Information Server Score 8.0 out of 10	IBM InfoSphere Information Server Score 8.0 out of 10
Enterprises	IBM InfoSphere Information Server Score 8.0 out of 10	IBM InfoSphere Information Server Score 8.0 out of 10
All Alternatives	View all alternatives	View all alternatives

User Ratings
	CData Sync	Oracle Warehouse Builder
Likelihood to Recommend	8.0 (1 ratings)	8.0 (5 ratings)

User Testimonials
	CData Sync	Oracle Warehouse Builder
Likelihood to Recommend	CData Software Evidently, CData Sync is an excellent middleware tool that is perfect for syncing data between systems. It is especially suitable and works well on SQL servers, DB2, MySQL, and Snowflake, and some of their brothering domains. However, it is a limitation in working with Sage 50 API. But if it is extracted with ODBC, it works well. Incentivized JS Jamie Smith Chief Computer Analyst and Product Manager 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. Incentivized Verified User Anonymous Read full review
Pros	CData Software UPSERT Friendly interface Incentivized Verified User Anonymous 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. Incentivized Gurcan Orhan Enterprise Data WareHouse Architect Read full review
Cons	CData Software Although efficient for SQL servers and MySQL, as well as Snowflake. It is not strong for other database engines, and an upgrade on this would do a lot. The installation process is manual as opposed to the cloud installation it should be. A feature of syncing auto increment ID key, that will help in existing data management. Incentivized JS Jamie Smith Chief Computer Analyst and Product Manager 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. Incentivized KN Kate Nadolinski Senior Consultant Read full review
Usability	CData Software It is easy to setup and use Incentivized Verified User Anonymous Read full review	Oracle No answers on this topic
Alternatives Considered	CData Software Tableau is another similar software tool, unlike CData Sync, rather transforms data into actionable insights. While CData Sync works with automation, Tableau uses a drag box on its AVA, which in turn slows the work speed on the syncing of data. Over the years, I enjoyed the friendly and customizable option of CData Sync over Tableau's. Incentivized JS Jamie Smith Chief Computer Analyst and Product Manager Read full review	Oracle Ab>initio, IBM Datastage 8.0 Incentivized Verified User Anonymous Read full review
Return on Investment	CData Software Positive: Easy way to bring data for our DWH Negative: Frequent issue in CData Sync Server Incentivized Verified User Anonymous Read full review	Oracle It improved understanding of ETL functions. Data is consistent. The speed is pretty good. Incentivized Dina Britan SIS Lead Analyst Read full review
ScreenShots