Amazon Athena vs. Oracle Warehouse Builder

Amazon Athena

Oracle Warehouse Builder

Overview
Product	Rating	Most Used By	Product Summary	Starting Price
Amazon Athena	Score 7.9 out of 10	N/A	Amazon Athena is an interactive query service that makes it easy to analyze data directly in Amazon S3 using standard SQL. With a few clicks in the AWS Management Console, customers can point Athena at their data stored in S3 and begin using standard SQL to run ad-hoc queries and get results in seconds. Athena is serverless, so there is no infrastructure to setup or manage, and customers pay only for the queries they run. You can use Athena to process logs, perform ad-hoc analysis, and run…	$5 per TB of Data Scanned
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

Amazon Athena

Oracle Warehouse Builder

Editions & Modules

Price per Query: $5.00
per TB of Data Scanned

No answers on this topic

Offerings

Pricing Offerings
Amazon Athena	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
	Amazon Athena	Oracle Warehouse Builder

Features

Amazon Athena

Oracle Warehouse Builder

Database-as-a-Service

Comparison of Database-as-a-Service features of Product A and Product B
	Amazon Athena 8.6 4 Ratings 1% above category average	Oracle Warehouse Builder - Ratings
Automatic software patching	8.22 Ratings	00 Ratings
Database scalability	9.03 Ratings	00 Ratings
Automated backups	7.73 Ratings	00 Ratings
Database security provisions	9.22 Ratings	00 Ratings
Monitoring and metrics	8.04 Ratings	00 Ratings
Automatic host deployment	9.22 Ratings	00 Ratings

Data Source Connection

Comparison of Data Source Connection features of Product A and Product B
	Amazon Athena - Ratings	Oracle Warehouse Builder 9.5 5 Ratings 14% above category average
Connect to traditional data sources	00 Ratings	10.05 Ratings
Connecto to Big Data and NoSQL	00 Ratings	9.02 Ratings

Data Transformations

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

Data Modeling

Comparison of Data Modeling features of Product A and Product B
	Amazon Athena - Ratings	Oracle Warehouse Builder 8.2 5 Ratings 4% above category average
Data model creation	00 Ratings	10.04 Ratings
Metadata management	00 Ratings	6.04 Ratings
Business rules and workflow	00 Ratings	9.04 Ratings
Collaboration	00 Ratings	8.94 Ratings
Testing and debugging	00 Ratings	7.04 Ratings

Data Governance

Comparison of Data Governance features of Product A and Product B
	Amazon Athena - Ratings	Oracle Warehouse Builder 8.0 3 Ratings 0% below category average
Integration with data quality tools	00 Ratings	8.03 Ratings
Integration with MDM tools	00 Ratings	8.02 Ratings

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

User Ratings
	Amazon Athena	Oracle Warehouse Builder
Likelihood to Recommend	10.0 (4 ratings)	8.0 (5 ratings)
Usability	10.0 (1 ratings)	- (0 ratings)

User Testimonials
	Amazon Athena	Oracle Warehouse Builder
Likelihood to Recommend	Amazon AWS If you are looking to take a lot of the traditional "database administration" work off someone's plate, going with Amazon Athena certainly has "no code" options to optimize lots of database tasks. I would say this option is less appropriate if you have other Microsoft things at play, such as Power BI. Incentivized Scott Kennedy Sr Director, BI 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	Amazon AWS Nested Schemas like JSON data structure Ability to adapt the data model to fit your queries better Performance Improvement Incentivized RK Riyaz Khan Data Engineer 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	Amazon AWS Response caching can be improved. Data Partitioning is tricky and understanding of the same could be improved. Incentivized Alok Pabalkar Co-Founder & CTO 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	Amazon AWS Easy to use. Scalable. Gets the job of data warehousing setup done. Using the datalake on S3 has become super convenient. Incentivized Alok Pabalkar Co-Founder & CTO Read full review	Oracle No answers on this topic
Alternatives Considered	Amazon AWS Incentivized Verified User Anonymous Read full review	Oracle Ab>initio, IBM Datastage 8.0 Incentivized Verified User Anonymous Read full review
Return on Investment	Amazon AWS The query speeds help us make more decisions in a day (speed). If you need more horsepower for specific times in the day this option helps scale. The security of your environment is well protected too. Incentivized Scott Kennedy Sr Director, BI 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