What users are saying about

Amazon Web Services

310 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>
Score 8.7 out of 101

Oracle Data Integrator

92 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>
Score 7.8 out of 101

Add comparison

Likelihood to Recommend

Amazon Web Services

Amazon Web Services is well suited for companies that don't want to have deal with physical infrastructure and want a high level of security and availability. In most cases Amazon Web Services is a great option for most, but may not be an option if you have met the tipping point of physical cost vs. Amazon Web Services cost. It may end up being a better option in the long run to manage the infrastructure yourself if the cost per hour of Amazon Web Services is greater than what you can provide if your level of availability is equal to or greater than Amazon Web Services.
No photo available

Oracle Data Integrator

Oracle Data Integrator is well suited in all the situations where you need to integrate data from and to different systems/technologies/environments or to schedule some tasks. I've used it on Oracle Database (Data Warehouses or Data Marts), with great loading and transforming performances to accomplish any kind of relational task. This is true for all Oracle applications (like Hyperion Planning, Hyperion Essbase, Hyperion Financial Management, and so on).I've also used it to manage files on different operating systems, to execute procedures in various languages and to read and write data from and to non-Oracle technologies, and I can confirm that its performances have always been very good.It can become less appropriate depending on the expenses that can be afforded by the customer since its license costs are quite high.
Paolo Borghi profile photo

Feature Rating Comparison

Infrastructure-as-a-Service (IaaS)

Amazon Web Services
8.4
Oracle Data Integrator
Service-level Agreement (SLA) uptime
Amazon Web Services
8.7
Oracle Data Integrator
Dynamic scaling
Amazon Web Services
8.9
Oracle Data Integrator
Elastic load balancing
Amazon Web Services
9.0
Oracle Data Integrator
Pre-configured templates
Amazon Web Services
7.7
Oracle Data Integrator
Monitoring tools
Amazon Web Services
7.9
Oracle Data Integrator
Pre-defined machine images
Amazon Web Services
7.9
Oracle Data Integrator
Operating system support
Amazon Web Services
8.5
Oracle Data Integrator
Security controls
Amazon Web Services
8.2
Oracle Data Integrator

Platform-as-a-Service

Amazon Web Services
Oracle Data Integrator
7.1
Ease of building user interfaces
Amazon Web Services
Oracle Data Integrator
7.3
Scalability
Amazon Web Services
Oracle Data Integrator
8.2
Platform management overhead
Amazon Web Services
Oracle Data Integrator
6.4
Workflow engine capability
Amazon Web Services
Oracle Data Integrator
8.2
Platform access control
Amazon Web Services
Oracle Data Integrator
7.3
Development environment creation
Amazon Web Services
Oracle Data Integrator
7.3
Development environment replication
Amazon Web Services
Oracle Data Integrator
7.3
Issue monitoring and notification
Amazon Web Services
Oracle Data Integrator
6.4
Issue recovery
Amazon Web Services
Oracle Data Integrator
6.4
Upgrades and platform fixes
Amazon Web Services
Oracle Data Integrator
6.4

Pros

  • The development and administration tools work well, including a consistent API and adequate management console. In terms of business process, it provided an effective "escape valve" for new product development that would have been much more onerous to deploy if we had to provision physical hardware and arrange for associated IT resources.
No photo available
  • Is simple and easy to learn, thanks to the low number of development objects that it has (mainly: interfaces, procedures and packages, plus variables).
  • It allows you to integrate data from and to any kind of technology. This is a strong point since it's able to connect practically to any technology, Oracle and not.
  • It allows you to create integration flows that manage through steps on any task.
  • It provides both an automatic and a customizable management of integration mistakes.
  • If you feel stronger in developing through hard code, ODI allows you to integrate anything through procedures.
  • It supports almost any kind of developing language, like SQL, PLSQL, Java, Javascript, C#, and so on.
  • It's easy to backup, since it provides a native way to export all the developments but also its relational repositories (master and work) can be exported from the database where they reside.
Paolo Borghi profile photo

Cons

  • AWS has a record of occasional severe outages, which has a cascading effect on the large number of high-profile services that now run on its infrastructure. Despite the spectacular nature of these outages, it is unlikely that a self-managed data center would achieve significantly better uptime.
  • It is also the case that AWS outages can be mitigated with effective use of multiple deployment 'zones' and regions. This is something that any mission-critical application should be doing anyway as part of disaster recovery preparations.
No photo available
  • The Java framework does not stand up to the mark. It crashes frequently. There is a long [list] of improvements required in terms of client tools framework.
  • Though Oracle Data Integrator lets people login from a web browser to monitor different activities, it crashes and performs very poorly when logged in out of network. Even Oracle Data Integrator client tools don't perform well on a remote desktop. Increasing Java buffer is one of the workarounds, that might work. So, a better client tools and interface is a big advantage.
  • Navigation is another pain area. It is very difficult to find out the precise error, in case of a failure, in Oracle Data Integrator. In Informatica, it is a cake walk to pull out a session log that shows up the exact reason for failure. Although Oracle Data Integrator is tightly integrated to database, it is very poor in providing the exact error at high level. One has to dig through to get it.
No photo available

Likelihood to Renew

Amazon Web Services9.4
Based on 10 answers
Support at AWS is great! The cost is low. Their business model is sound. They tend to benefit us.
Doug Symes profile photo
Oracle Data Integrator10.0
Based on 4 answers
ODI is your power to any kind of database, operating system, big data or others.
Gurcan Orhan profile photo

Usability

Amazon Web Services9.0
Based on 3 answers
Easy to use/learning curve. If you are new to the use of cloud storage, AWS is your entry point. If you have experience in that field, AWS is the way to go.
Miguel Angel Merino Vega profile photo
No score
No answers yet
No answers on this topic

Reliability and Availability

Amazon Web Services9.0
Based on 1 answer
Availability is very good, with the exception of occasional spectacular outages.
No photo available
No score
No answers yet
No answers on this topic

Performance

AWS does not provide the raw performance that you can get by building your own custom infrastructure. However, it is often the case that the benefits of specialized, high-performance hardware do not necessarily outweigh the significant extra cost and risk. Performance as perceived by the user is very different from raw throughput.
No photo available
No answers on this topic

Support

Amazon Web Services3.0
Based on 3 answers
unless you paid the premium, no support at all
No photo available
No score
No answers yet
No answers on this topic

Implementation

Amazon Web Services10.0
Based on 3 answers
The API's were very well documented and was Janova's main point of entry into the services.
Brian Lusenhop profile photo
Oracle Data Integrator7.0
Based on 1 answer
No answer on this topic is available.

Alternatives Considered

We looked into other server hosts, but the cost was out of our budget. We were quoted a monthly fee of $500 to $750, plus an initial fee of over $1,000. AWS made the most financial sense as well as other reviews and recommendations
Stella Gillham profile photo
Oracle's own ETL tool was Oracle Warehouse Builder, initially. When Oracle built the Oracle Business Intelligence Applications Suite, Oracle is in need of a strong ETL. As Oracle Warehouse Builder is not a strong ETL that customers prefer and as already Informatica captured most of the ETL market, Oracle choose Informatica as it's ETL tool for Oracle Business Intelligence Applications Suite. In parallel, Oracle started developing it's own ETL tool which can replace Informatica in their OBIA Suite. The outcome is Oracle Data Integrator. Oracle Data Integrator is built keeping customers in mind and what customers are trying to achieve over the last decade. Though, OBIA 11g customers are now left with only one choice of ETL Tool - ODI, they love it for it's simplicity and light foot print. Pentaho on the other hand is not comparable to either ODI or Informatica. I mentioned it as I used it for a short period.
No photo available

Return on Investment

  • Positive: Faster provisioning of infrastructure.
  • Positive: Lower upfront costs.
  • Negative: Integration of AWS to enterprise apps.
Billy Tiangco profile photo
  • It quickened our development of interfaces.
  • Allow us to replace some interfaces based on TXT files with direct connection, and thus turning our environment more safe and SOX compliant.
Federico Shortrede profile photo

Pricing Details

Amazon Web Services

General
Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No
Additional Pricing Details

Oracle Data Integrator

General
Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No
Additional Pricing Details