4 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 3 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

Actian Pervasive Data Integrator

I wouldn't recommend Data Integrator over SSIS, but it may be a better tool than other ETL offerings. Having a background in the Microsoft Stack, I am hesitant to recommend any other products especially in a Microsoft-centric company. If this was the only option to use, I think it does a good job at integrating systems after taking time to learn the approach. "Maps" in Data Integrator is definitely different than "process flow" philosophy in SSIS.
Justin Duperre | 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

Actian Pervasive Data Integrator
7.0
Talend Open Studio
6.9
Connect to traditional data sources
Actian Pervasive Data Integrator
7.0
Talend Open Studio
7.7
Connecto to Big Data and NoSQL
Actian Pervasive Data Integrator
Talend Open Studio
6.1

Data Transformations

Actian Pervasive Data Integrator
7.0
Talend Open Studio
6.1
Simple transformations
Actian Pervasive Data Integrator
9.0
Talend Open Studio
5.8
Complex transformations
Actian Pervasive Data Integrator
5.0
Talend Open Studio
6.5

Data Modeling

Actian Pervasive Data Integrator
4.3
Talend Open Studio
6.2
Business rules and workflow
Actian Pervasive Data Integrator
5.0
Talend Open Studio
5.1
Collaboration
Actian Pervasive Data Integrator
3.0
Talend Open Studio
7.1
Testing and debugging
Actian Pervasive Data Integrator
5.0
Talend Open Studio
6.5
Data model creation
Actian Pervasive Data Integrator
Talend Open Studio
6.0
Metadata management
Actian Pervasive Data Integrator
Talend Open Studio
6.3

Data Governance

Actian Pervasive Data Integrator
Talend Open Studio
6.8
Integration with data quality tools
Actian Pervasive Data Integrator
Talend Open Studio
6.3
Integration with MDM tools
Actian Pervasive Data Integrator
Talend Open Studio
7.4

Pros

Actian Pervasive Data Integrator

  • 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.
Justin Duperre | 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

Actian Pervasive Data Integrator

  • Sometimes the screen does not load- since it is a web based software, this can be seen as a reliability issue.
  • "Maps" can become somewhat complex, and between multiple developers this can be painful when sharing or explaining others' work.
  • The concept of macros adds flexibility in how to solve problems, but is a separate language and can take time to learn and master.
Justin Duperre | 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

Actian Pervasive Data Integrator

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

Actian Pervasive Data Integrator

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

Actian Pervasive Data Integrator

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

Actian Pervasive Data Integrator

No score
No answers yet
No answers on this topic

Talend Open Studio

Talend Open Studio 3.9
Based on 3 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

Actian Pervasive Data Integrator

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.)
Justin Duperre | 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

Actian Pervasive Data Integrator

  • This tool was chosen prior to my arrival and was used to build three integrations. We have decided to switch to SSIS since we have licenses for it and it is a more common tool for ETL integrations.
  • It has been difficult to network with individuals that have experience with this tool.
  • Having been a part of a software package purchased, we have chosen to use a different tool for future integrations and plan to rewrite existing integrations.
Justin Duperre | 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

Actian Pervasive Data Integrator

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

Actian Pervasive Data Integrator
7.0
Talend Open Studio
6.9

Likelihood to Renew

Actian Pervasive Data Integrator
Talend Open Studio
10.0

Usability

Actian Pervasive Data Integrator
Talend Open Studio
3.0

Performance

Actian Pervasive Data Integrator
Talend Open Studio
4.0

Support Rating

Actian Pervasive Data Integrator
Talend Open Studio
3.9

Add comparison