HCL DataConnect vs. Oracle Warehouse Builder

HCL DataConnect

Oracle Warehouse Builder

Overview
Product	Rating	Most Used By	Product Summary	Starting Price
HCL DataConnect	Score 6.7 out of 10	Mid-Size Companies (51-1,000 employees)	HCL DataConnect (formerly Actian DataConnect) is a hybrid integration solution that enables users to integrate anything, anywhere, anytime. It can be deployed in on-premise, cloud, and/or hybrid environments and offers quick onboarding. With its emphasis data quality, data reuse, adaptability and self-service integration, DataConnect is designed to support rapid onboarding and deliver the fast time to value.	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

HCL DataConnect

Oracle Warehouse Builder

Editions & Modules

No answers on this topic

Offerings

Pricing Offerings
HCL DataConnect	Oracle Warehouse Builder
Free Trial
No	No
Free/Freemium Version
No	No
Premium Consulting/Integration Services
No	No

Entry-level Setup Fee

Optional

No setup fee

Additional Details

—

More Pricing Information

Community Pulse
	HCL DataConnect	Oracle Warehouse Builder
Top Pros	Pro Data types Pro Easy to start Pro Flat files	Pro Etl tool Pro Metadata management Pro Oracle database
Top Cons	Minus Somewhat complex Minus Web based Minus Based software	Minus Learning material Minus Training course Minus One database

Features

HCL DataConnect

Oracle Warehouse Builder

Data Source Connection

Comparison of Data Source Connection features of Product A and Product B
	HCL DataConnect 9.5 2 Ratings 15% above category average	Oracle Warehouse Builder 9.5 5 Ratings 15% above category average
Connect to traditional data sources	9.92 Ratings	10.05 Ratings
Connecto to Big Data and NoSQL	9.01 Ratings	9.02 Ratings

Data Transformations

Comparison of Data Transformations features of Product A and Product B
	HCL DataConnect 9.9 2 Ratings 17% above category average	Oracle Warehouse Builder 10.0 5 Ratings 18% above category average
Simple transformations	10.02 Ratings	10.05 Ratings
Complex transformations	9.92 Ratings	10.04 Ratings

Data Modeling

Comparison of Data Modeling features of Product A and Product B
	HCL DataConnect 9.9 2 Ratings 20% above category average	Oracle Warehouse Builder 8.2 5 Ratings 1% above category average
Data model creation	10.01 Ratings	10.04 Ratings
Metadata management	10.01 Ratings	6.04 Ratings
Business rules and workflow	9.92 Ratings	9.04 Ratings
Collaboration	9.82 Ratings	8.94 Ratings
Testing and debugging	9.92 Ratings	7.04 Ratings

Data Governance

Comparison of Data Governance features of Product A and Product B
	HCL DataConnect 9.5 1 Ratings 15% above category average	Oracle Warehouse Builder 8.0 3 Ratings 3% below category average
Integration with data quality tools	9.01 Ratings	8.03 Ratings
Integration with MDM tools	10.01 Ratings	8.02 Ratings

Best Alternatives
	HCL DataConnect	Oracle Warehouse Builder
Small Businesses	Skyvia Score 9.6 out of 10	Skyvia Score 9.6 out of 10
Medium-sized Companies	IBM InfoSphere Information Server Score 8.1 out of 10	IBM InfoSphere Information Server Score 8.1 out of 10
Enterprises	IBM InfoSphere Information Server Score 8.1 out of 10	IBM InfoSphere Information Server Score 8.1 out of 10
All Alternatives	View all alternatives	View all alternatives

User Ratings
	HCL DataConnect	Oracle Warehouse Builder
Likelihood to Recommend	8.9 (2 ratings)	8.0 (5 ratings)

User Testimonials
	HCL DataConnect	Oracle Warehouse Builder
Likelihood to Recommend	HCL Technologies The choice to use Actian DataConnect really comes down to pricing and the type of integration project you are performing, specifically with the requirements, whether you want the integration to be on-premise or in the cloud, can you install agents on your servers etc. For integration tools it runs head to head with its competitors. Incentivized David Byrd Sr Integration Engineer - Dual Certified in Dell Boomi Developer 1 & 2, and Actian DataConnect 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	HCL Technologies Map multiple source and destination tables - what would be done in many steps in SSIS can be done in one or two "maps" in Data Integrator. Platform independent, cloud based, no client software. Conversion of data types, write flat files - this helps us with integrating systems. Fairly straightforward to use if the user has ETL experience. Incentivized Justin Duperre Data Management Support Specialist 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	HCL Technologies Integration Manager needs better scheduling improvements. Like dependencies, and not running a process again if the prior run is still running. New connector development does not seem a priority. Incentivized David Byrd Sr Integration Engineer - Dual Certified in Dell Boomi Developer 1 & 2, and Actian DataConnect 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
Alternatives Considered	HCL Technologies Data Integrator was initially a part of a package deal for us with our new Student Information System. It was chosen prior to my arrival at the institution. Since I discovered we have SQL Server licenses, we have decided to use SSIS instead since I have a background in the MSBI stack and SSIS appears to be more straightforward (process flow philosophy vs "map" philosophy.) Incentivized Justin Duperre Data Management Support Specialist Read full review	Oracle Ab>initio, IBM Datastage 8.0 Incentivized Verified User Anonymous Read full review
Return on Investment	HCL Technologies Our customer likes the consistent reliable integrations we have built so we [got] a definite return on investment. Problems are fairly easy to handle and rework. Incentivized David Byrd Sr Integration Engineer - Dual Certified in Dell Boomi Developer 1 & 2, and Actian DataConnect 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	HCL DataConnect Screenshots