What users are saying about
<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow noopener noreferrer'>Customer Verified: Read more.</a>
Top Rated
143 Ratings
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

Matillion

<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow noopener noreferrer'>Customer Verified: Read more.</a>
Top Rated
143 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 9 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

Matillion

Matillion is great for handling bulk and 'delta' loads to your warehouse, i.e. updating the warehouse with only those records updated since the last execution of the pipeline. The components and Python scripting provide a huge amount of flexibility in what the pipeline does, but you do need to have the expertise to know how to implement it properly.Matillion has been less good at extracting data from APIs. The functionality was found to be complex and it was unclear how to manage things like pagination and rate limiting in API calls.
Anonymous | TrustRadius Reviewer

Feature Rating Comparison

Data Source Connection

Actian Pervasive Data Integrator
7.0
Matillion
7.9
Connect to traditional data sources
Actian Pervasive Data Integrator
7.0
Matillion
8.3
Connecto to Big Data and NoSQL
Actian Pervasive Data Integrator
Matillion
7.6

Data Transformations

Actian Pervasive Data Integrator
7.0
Matillion
8.1
Simple transformations
Actian Pervasive Data Integrator
9.0
Matillion
8.6
Complex transformations
Actian Pervasive Data Integrator
5.0
Matillion
7.5

Data Modeling

Actian Pervasive Data Integrator
4.3
Matillion
7.2
Business rules and workflow
Actian Pervasive Data Integrator
5.0
Matillion
7.4
Collaboration
Actian Pervasive Data Integrator
3.0
Matillion
6.8
Testing and debugging
Actian Pervasive Data Integrator
5.0
Matillion
6.3
Data model creation
Actian Pervasive Data Integrator
Matillion
7.6
Metadata management
Actian Pervasive Data Integrator
Matillion
6.6
feature 1
Actian Pervasive Data Integrator
Matillion
8.2

Data Governance

Actian Pervasive Data Integrator
Matillion
6.5
Integration with data quality tools
Actian Pervasive Data Integrator
Matillion
6.6
Integration with MDM tools
Actian Pervasive Data Integrator
Matillion
6.3

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

Matillion

  • The workspace is drag and drop, which makes it intuitive and easy to use.
  • Server creation and management is robust. We haven't had to worry too much about it once we got it created.
  • The job scheduler is very simple and intuitive.
  • Matillion allows you to run Python, which grants almost unlimited flexibility, even without using any other components.
Hyrum Ward | 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

Matillion

  • Limited selection of instance sizes - Larger organizations and groups my need to set up multilple instances depending on estimations on concurrent users.
  • Lack of complete github, gitlab, or other source control integration - it has internal versioning but it is limited. Manual job exports currently don't lend well for useful DIFFs comparison when using those technologies.
  • Needs more options for authentication and security - User creation is very manual and can be tedious and difficult to manage for larger installations.
Patrick Hildreth | TrustRadius Reviewer

Likelihood to Renew

Actian Pervasive Data Integrator

No score
No answers yet
No answers on this topic

Matillion

Matillion 7.1
Based on 2 answers
With the current experience of Matillion, we are likely to renew with the current feature option but will also look for improvement in various areas including scalability and dependability. 1. Connectors: It offers various connectors option but isn't full proof which we will be looking forward as we grow.2. Scalability: As usage increase, we want Matillion system to be more stable.
Sudarshan Kothari | TrustRadius Reviewer

Usability

Actian Pervasive Data Integrator

No score
No answers yet
No answers on this topic

Matillion

Matillion 7.8
Based on 87 answers
Pretty good UI, especially for a completely web-based system. Source control integration is a bit clunky at times, but overall makes code versioning and branching much more simple, since it's largely within the same context as the rest of the code. Finding some core settings can be difficult - they're just not where one would expect them to be.
Britton Gray | TrustRadius Reviewer

Support Rating

Actian Pervasive Data Integrator

No score
No answers yet
No answers on this topic

Matillion

Matillion 7.6
Based on 4 answers
For most of users support can provide needed help. And it is always in a really short time frame.In some really advanced cases there was necessary to include highly tech people and there was a lot of back and forth. Because I have a case that is not resolved for more than a year and the bug is based on initial bad implementation (Google AdManager component) I would suggest that sometimes don't rush to publish something that is not ready.
Aleksa Topalović | TrustRadius Reviewer

Implementation Rating

Actian Pervasive Data Integrator

No score
No answers yet
No answers on this topic

Matillion

Matillion 8.2
Based on 1 answer
Not really a part of the implementation to give fare insight.
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

Matillion

There's a number of systems not available to enter in here that we also took a look at: AWS Data pipeline, Airflow, Xplenty, etc. The reason we chose Matillion is for the balance of features (ability to connect into cloud data sources like Jira), a simple interface to put together Data pipelines (that required little to no coding), and a reasonable price point. Matillion is pretty unique in that it hits a balance of all three of those requirements.
Kris Shinn | TrustRadius Reviewer

Scalability

Actian Pervasive Data Integrator

No score
No answers yet
No answers on this topic

Matillion

Matillion 6.7
Based on 79 answers
Instance size can be upgraded or downgraded with few clicks and hourly billing rate will change immediately. No need to restart Matillion instance. Matillion Enterprise edition has several benefits and will be activated automatically by configuring ">=m4." large instance size
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

Matillion

  • Matillion has dramatically decreased the time it takes to create new ETL
  • Matillion has reduced the amount of time it takes to execute our daily ETL processing (by 50% or more)
  • Matillion has increased the number of people who can develop ETL by making ETL development easier
  • Matillion has increased the variety of data sources we can bring into our data warehouse
  • Matillion has made it a little harder to manage source control and deployment
Matthew Burr | TrustRadius Reviewer

Screenshots

Pricing Details

Actian Pervasive Data Integrator

General

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

Matillion

General

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

Rating Summary

Likelihood to Recommend

Actian Pervasive Data Integrator
7.0
Matillion
7.6

Likelihood to Renew

Actian Pervasive Data Integrator
Matillion
7.1

Usability

Actian Pervasive Data Integrator
Matillion
7.8

Support Rating

Actian Pervasive Data Integrator
Matillion
7.6

Implementation Rating

Actian Pervasive Data Integrator
Matillion
8.2

Scalability

Actian Pervasive Data Integrator
Matillion
6.7

Add comparison