What users are saying about
210 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 7.9 out of 100
44 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 7.3 out of 100

Likelihood to Recommend

Oracle Data Warehouse

Including other products, Oracle is very specialized in business support. Choosing Oracle Data Warehouse would be a safe choice for an enterprise-level company (more than a thousand employees). Healthcare organizations may want to consider Oracle, as they are typically conservative with privacy and security issues with patient data. Although cloud-based systems are widely being adopted in the healthcare industry (such as population research or genomics), core data sets (such as patients' sensitive medical records) may be better stored with a home-grown data center and warehouse solution.
Anonymous | TrustRadius Reviewer

Talend Open Studio

For quick daily integrations Talend is a very good tool and it makes development time so short and easy. Citizen developers who are not great programmers can pick up and start using Talend Open Studio within weeks. It's well suited for all kinds of data migration between various systems. It is less appropriate for smaller synchronous services where you need to trace the complete transaction and how data moved between them. It's also less appropriate for small data movements where other tools can be easier to use and manage.
Anonymous | TrustRadius Reviewer

Feature Rating Comparison

Data Source Connection

Oracle Data Warehouse
Talend Open Studio
7.0
Connect to traditional data sources
Oracle Data Warehouse
Talend Open Studio
7.5
Connecto to Big Data and NoSQL
Oracle Data Warehouse
Talend Open Studio
6.4

Data Transformations

Oracle Data Warehouse
Talend Open Studio
6.2
Simple transformations
Oracle Data Warehouse
Talend Open Studio
5.8
Complex transformations
Oracle Data Warehouse
Talend Open Studio
6.6

Data Modeling

Oracle Data Warehouse
Talend Open Studio
6.4
Data model creation
Oracle Data Warehouse
Talend Open Studio
6.0
Metadata management
Oracle Data Warehouse
Talend Open Studio
6.5
Business rules and workflow
Oracle Data Warehouse
Talend Open Studio
5.4
Collaboration
Oracle Data Warehouse
Talend Open Studio
7.1
Testing and debugging
Oracle Data Warehouse
Talend Open Studio
6.8

Data Governance

Oracle Data Warehouse
Talend Open Studio
6.7
Integration with data quality tools
Oracle Data Warehouse
Talend Open Studio
6.2
Integration with MDM tools
Oracle Data Warehouse
Talend Open Studio
7.3

Pros

Oracle Data Warehouse

  • Able to handle very large data sizes efficiently from a performance, high availability and manageability perspective. This is accomplished through the Oracle Partitioning functionality. Partitioning allows large segments (tables, IOT index-organized tables, indexes) to be broken into smaller segments at the physical layer but treated as a whole at the logical layer.
  • Provides support for dual-format architecture through Oracle In-Memory functionality. Without any change to application code one can obtain in-memory performance. This functionality enables us to have the tables represented in both the row format and the column format using in-memory format. This is a huge boost for BI/analytic queries since the Oracle optimizer is able to intelligently choose the appropriate format.
  • Provision to materialize a subset of table data or table joins. This is through materialized views and the optimizer will rewrite the query against the base tables to make use of this materialized view. This provides a huge performance boost and is critical in VLDBs as in a data warehouse. The query rewrite is fully transparent to users.
  • Provides multiple compression capabilities. This is very useful not only for deducing the storage foot print but as well as increase performance at different layers of the infrastructure including query performance. The compression functionality can be applied against both structured and unstructured data.
  • With the advent of Engineered Systems (Exadata, Database Machine, SuperCluster) there are specific features and functionalities that can further boost the Oracle data warehouse. These are related to consolidation, Smart Scan, Storage Indexes, EHCC (Exadata hybrid columnar compression) and much more.
  • RAC - Real Application Clusters (with 2 or more nodes) provides functionality for high availability, performance and scaling as the work load increases. The parallelism is provided both within a node and as well as across nodes. If for any reason a node goes down the data warehouse is still available through other nodes and the running queries are transparently failed over to the surviving nodes.
Suresh Muddaveerappa | TrustRadius Reviewer

Talend Open Studio

  • Your developers will be able to design SOA services graphically, and it is very easy to document and implement the code.
  • Talend Open Studio is based on Eclipse IDE, so your developers will be very comfy using it
  • Open is Key in Talend Open Studio = Open Source
Jose Miguel Siu Navarro | TrustRadius Reviewer

Cons

Oracle Data Warehouse

  • Customer support isn't the best out there. We usually have to wait about an hour to get some form of assistance.
  • Pricing is a bit higher than many of its competitors such as AWS Redshift.
  • Tweaking features requires dedicated staff. Software is fairly advanced. Would be difficult to use for newcomers.
Anonymous | TrustRadius Reviewer

Talend Open Studio

  • The community is not that up to date and forum is not that great in response. Probably we should make people aware of the tool more on how to use and its implementations.
  • Talend crashes when transforming a lot of data (millions of rows).
  • Proper training documentation is a must for talend which is currently lagging. This will help users to learn more about Talend and use it effectively.
Anonymous | TrustRadius Reviewer

Likelihood to Renew

Oracle Data Warehouse

No score
No answers yet
No answers on this topic

Talend Open Studio

Talend Open Studio 10.0
Based on 1 answer
There is no licence requirement for Talend Open Studio. So, this is not relevant question. However, if you are asking whether we will use Talend in future. Yes. We will continue to use it. It's very powerful free tool which caters to all our extra, transform, load capabilities. We just love Talend for it's great functionality and ease of use.
Anonymous | TrustRadius Reviewer

Usability

Oracle Data Warehouse

No score
No answers yet
No answers on this topic

Talend Open Studio

Talend Open Studio 3.0
Based on 1 answer
Talend Open Studio is based on Eclipse and is full of redundant procedures to do one thing, like when installing libraries. Sometimes I cannot manually download the libraries that it can't find.
federico nastasi | TrustRadius Reviewer

Performance

Oracle Data Warehouse

No score
No answers yet
No answers on this topic

Talend Open Studio

Talend Open Studio 4.0
Based on 1 answer
Many times, Talend freezes. When you give a cancel command, it takes several minutes to stop. It also takes a great toll on our PC with 16 GB of ram and I7 CPU, even in idle status. If you are downloading Maven Jar/Libraries, you cannot do anything and have to wait until the task is finished.
federico nastasi | TrustRadius Reviewer

Support Rating

Oracle Data Warehouse

No score
No answers yet
No answers on this topic

Talend Open Studio

Talend Open Studio 4.4
Based on 4 answers
Talend Open Studio is free and we are not using the enterprise version which comes with licence and support. So, mostly depend on the open source community for any issues that we face. The document is good and we didn't have to use any support so far. We did evaluate the enterprise version and so far sticking to the free version.
Anonymous | TrustRadius Reviewer

Alternatives Considered

Oracle Data Warehouse

Oracle is, in my opinion, the top dog in this space. I feel like the other vendors are playing catch-up to where Oracle is right now. It is also likely the most expensive option out there.
Anonymous | TrustRadius Reviewer

Talend Open Studio

Informatica has a limited number of components that you can use. This places a heavy limitation on the capabilities of Informatica. On the other hand, Talend allows you to create your own custom components using Java. For businesses that need to perform a wide variety of data operations, it can be quite useful to have the option of creating your own custom components to satisfy business needs.
Anonymous | TrustRadius Reviewer

Return on Investment

Oracle Data Warehouse

  • Very cost effective for large databases.
  • Very fast results on simple queries.
  • Analytical functionalities are of wide range, which makes it very cost effective.
  • For smaller businesses, it might be a great asset.
  • Some features are supposed to be bought separately, so one needs to consider this before licensing with Oracle DW.
Kartik Chavan | TrustRadius Reviewer

Talend Open Studio

  • I delivered projects the client did not believe were possible, and I provided intermediate value by providing visibility to hidden data problems in their systems they could not detect before.
  • I was able to work 3 projects at a time, pausing gracefully in one while switching to the other, with minimal effort.
Mike Blizman | TrustRadius Reviewer

Pricing Details

Oracle Data Warehouse

General

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

Talend Open Studio

General

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

Rating Summary

Likelihood to Recommend

Oracle Data Warehouse
6.4
Talend Open Studio
7.0

Likelihood to Renew

Oracle Data Warehouse
Talend Open Studio
10.0

Usability

Oracle Data Warehouse
Talend Open Studio
3.0

Performance

Oracle Data Warehouse
Talend Open Studio
4.0

Support Rating

Oracle Data Warehouse
Talend Open Studio
4.4

Add comparison