Amazon Athena vs. Oracle Warehouse Builder

Overview
ProductRatingMost Used ByProduct SummaryStarting 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 AthenaOracle Warehouse Builder
Editions & Modules
Price per Query
$5.00
per TB of Data Scanned
No answers on this topic
Offerings
Pricing Offerings
Amazon AthenaOracle 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
Amazon AthenaOracle Warehouse Builder
Features
Amazon AthenaOracle 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 patching8.22 Ratings00 Ratings
Database scalability9.03 Ratings00 Ratings
Automated backups7.73 Ratings00 Ratings
Database security provisions9.22 Ratings00 Ratings
Monitoring and metrics8.04 Ratings00 Ratings
Automatic host deployment9.22 Ratings00 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 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
Amazon Athena
-
Ratings
Oracle Warehouse Builder
10.0
5 Ratings
20% 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
Amazon Athena
-
Ratings
Oracle Warehouse Builder
8.2
5 Ratings
4% 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
Amazon Athena
-
Ratings
Oracle Warehouse Builder
8.0
3 Ratings
0% below category average
Integration with data quality tools00 Ratings8.03 Ratings
Integration with MDM tools00 Ratings8.02 Ratings
Best Alternatives
Amazon AthenaOracle Warehouse Builder
Small Businesses
IBM Cloudant
IBM Cloudant
Score 7.4 out of 10
Skyvia
Skyvia
Score 10.0 out of 10
Medium-sized Companies
IBM Cloudant
IBM Cloudant
Score 7.4 out of 10
IBM InfoSphere Information Server
IBM InfoSphere Information Server
Score 8.0 out of 10
Enterprises
IBM Cloudant
IBM Cloudant
Score 7.4 out of 10
IBM InfoSphere Information Server
IBM InfoSphere Information Server
Score 8.0 out of 10
All AlternativesView all alternativesView all alternatives
User Ratings
Amazon AthenaOracle Warehouse Builder
Likelihood to Recommend
10.0
(4 ratings)
8.0
(5 ratings)
Usability
10.0
(1 ratings)
-
(0 ratings)
User Testimonials
Amazon AthenaOracle 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.
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
Amazon AWS
  • Nested Schemas like JSON data structure
  • Ability to adapt the data model to fit your queries better
  • Performance Improvement
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
Amazon AWS
  • Response caching can be improved.
  • Data Partitioning is tricky and understanding of the same could be improved.
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
Usability
Amazon AWS
Easy to use. Scalable. Gets the job of data warehousing setup done. Using the datalake on S3 has become super convenient.
Read full review
Oracle
No answers on this topic
Alternatives Considered
Amazon AWS
Read full review
Oracle
Ab>initio, IBM Datastage 8.0
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.
Read full review
Oracle
  • It improved understanding of ETL functions. Data is consistent. The speed is pretty good.
Read full review
ScreenShots