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

Alteryx Platform

I wish I had found and used Alteryx Analytics years ago. Having multiple data sources with a variety of naming conventions for our businesses we spent WEEKS cleaning/reorganizing/renaming fields in our data to be able to consolidate. We did this on one set of reports for one use. Each time we wanted an update this process would need to be repeated. This took tons of useless admin time. Had we had Alteryx we could have created 1 identifier, noted all the different naming conventions or issues, selected the ones we wanted and created the workflow to use it over and over and over again on any data we wanted. Build once - use multiple times. It would have been (and now is) a HUGE time saver. Plus any new anomalies are identified by the program as errors so you can "autocorrect" them in the same workflow. Alteryx is a miracle in my opinion.
Susan Knolla | TrustRadius Reviewer

Feature Rating Comparison

Data Source Connection

Actian Pervasive Data Integrator
7.0
Alteryx Platform
Connect to traditional data sources
Actian Pervasive Data Integrator
7.0
Alteryx Platform

Data Transformations

Actian Pervasive Data Integrator
7.0
Alteryx Platform
Simple transformations
Actian Pervasive Data Integrator
9.0
Alteryx Platform
Complex transformations
Actian Pervasive Data Integrator
5.0
Alteryx Platform

Data Modeling

Actian Pervasive Data Integrator
4.3
Alteryx Platform
Business rules and workflow
Actian Pervasive Data Integrator
5.0
Alteryx Platform
Collaboration
Actian Pervasive Data Integrator
3.0
Alteryx Platform
Testing and debugging
Actian Pervasive Data Integrator
5.0
Alteryx Platform

BI Standard Reporting

Actian Pervasive Data Integrator
Alteryx Platform
5.4
Pixel Perfect reports
Actian Pervasive Data Integrator
Alteryx Platform
5.0
Customizable dashboards
Actian Pervasive Data Integrator
Alteryx Platform
6.1
Report Formatting Templates
Actian Pervasive Data Integrator
Alteryx Platform
5.0

Ad-hoc Reporting

Actian Pervasive Data Integrator
Alteryx Platform
7.7
Drill-down analysis
Actian Pervasive Data Integrator
Alteryx Platform
7.1
Formatting capabilities
Actian Pervasive Data Integrator
Alteryx Platform
7.6
Integration with R or other statistical packages
Actian Pervasive Data Integrator
Alteryx Platform
8.3
Report sharing and collaboration
Actian Pervasive Data Integrator
Alteryx Platform
7.7

Report Output and Scheduling

Actian Pervasive Data Integrator
Alteryx Platform
7.1
Publish to Web
Actian Pervasive Data Integrator
Alteryx Platform
7.5
Publish to PDF
Actian Pervasive Data Integrator
Alteryx Platform
7.0
Report Versioning
Actian Pervasive Data Integrator
Alteryx Platform
4.0
Report Delivery Scheduling
Actian Pervasive Data Integrator
Alteryx Platform
7.8
Delivery to Remote Servers
Actian Pervasive Data Integrator
Alteryx Platform
9.0

Data Discovery and Visualization

Actian Pervasive Data Integrator
Alteryx Platform
7.3
Pre-built visualization formats (heatmaps, scatter plots etc.)
Actian Pervasive Data Integrator
Alteryx Platform
6.0
Location Analytics / Geographic Visualization
Actian Pervasive Data Integrator
Alteryx Platform
7.9
Predictive Analytics
Actian Pervasive Data Integrator
Alteryx Platform
8.1

Access Control and Security

Actian Pervasive Data Integrator
Alteryx Platform
8.0
Multi-User Support (named login)
Actian Pervasive Data Integrator
Alteryx Platform
8.0
Role-Based Security Model
Actian Pervasive Data Integrator
Alteryx Platform
8.0
Multiple Access Permission Levels (Create, Read, Delete)
Actian Pervasive Data Integrator
Alteryx Platform
8.0
Single Sign-On (SSO)
Actian Pervasive Data Integrator
Alteryx Platform
8.0

Mobile Capabilities

Actian Pervasive Data Integrator
Alteryx Platform
4.0
Responsive Design for Web Access
Actian Pervasive Data Integrator
Alteryx Platform
4.0

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

Alteryx Platform

  • Alteryx does a great job of allowing more beginner Analysts to automate many of their routine process but also allowing advanced Analysts to ability to leverage deep statistical modelling for predictive analytics.
  • Given the visual workflow nature of Alteyrx, the learning curve is not steep.
  • The Alteryx Gallery allows non-technical consumers to execute complex workflows by leveraging an intuitive web interface.
  • Alteryx allows data scientists to bring their own programming language to Altyerx, such as R or Python.
Anonymous | 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

Alteryx Platform

  • Sometimes the desktop version of authoring tool crashes! It's been unstable in the previous versions but gets better. Even if it doesn't crash, it used to be slow or not responding.
  • When running several version of database drivers in local machine or server, it is tricky to set up database connections. Often you have to figure out it by googling the problem and solution. There are not many knowledge bases from Alteryx.
  • Alteryx project file creates .bak file automatically. It is useful to prevent for the purpose of back up, sometimes it's not necessary. But it is not changeable for some reason. By default, it always creates backups.
Anonymous | TrustRadius Reviewer

Likelihood to Renew

Actian Pervasive Data Integrator

No score
No answers yet
No answers on this topic

Alteryx Platform

Alteryx Platform 6.5
Based on 14 answers
We've developed a working partnership with Alteryx. As an enablement suite, we're continuing to innovate and deliver great products with use of Alteryx in our solutions. Alteryx use expands to our global product development teams and is in use in multiple parts of our organization. Alteryx also delivers Experian demographic content to other clients in their product offering. We're highly likely to renew, but that decision is way above my pay grade.
Mark Frisch | TrustRadius Reviewer

Usability

Actian Pervasive Data Integrator

No score
No answers yet
No answers on this topic

Alteryx Platform

Alteryx Platform 10.0
Based on 2 answers
Through a graphical UI one can perform engineering and development, other vendors do not have such a code-less interface.
Anonymous | TrustRadius Reviewer

Reliability and Availability

Actian Pervasive Data Integrator

No score
No answers yet
No answers on this topic

Alteryx Platform

Alteryx Platform 10.0
Based on 1 answer
I use many programs and compared to others, Alteryx virtually never goes down, freezes up or gives an application error. Over a 4 year time period that I have used this program, any of these may have happened 3 times. It is an incredibly stable program that I feel completely confident in.
Dan Chapman | TrustRadius Reviewer

Support Rating

Actian Pervasive Data Integrator

No score
No answers yet
No answers on this topic

Alteryx Platform

Alteryx Platform 9.8
Based on 3 answers
Overall pretty good. Depending on the quality of the question posed the CS team will get back as they are available
Anonymous | TrustRadius Reviewer

Implementation Rating

Actian Pervasive Data Integrator

No score
No answers yet
No answers on this topic

Alteryx Platform

Alteryx Platform 10.0
Based on 1 answer
There is really not much to it (the installation, that is). Once you get it installed, along with any of the add-ons (demographics, R, etc.), you are up and running almost immediately. There is really no additional setup. You can immediately begin blending data, running demographics, performing spatial queries, running predictive analysis, etc. And for many of these functions, the learning curve is quite easy.
Dan Chapman | 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

Alteryx Platform

Talend is primarily for data integration and has quite advanced capabilities. But the user has to be more technical. Alteryx makes the process simple and any user can make use of its features.Tableau was a good choice for data visualization. We needed beautiful charts and ways to represent data. Alteryx falls short in this aspect.
Sanket Bharaswadkar | 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

Alteryx Platform

  • Alteryx does an excellent job of integrating consumer and spatial data to calculate and visualize things like locations within a certain drive-time radius.
  • For visualization purposes I had to move the data to excel for some decent graphs.
  • It can become very expensive.
Anonymous | 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

Actian Pervasive Data Integrator Editions & Modules

Additional Pricing Details

Alteryx Platform

General

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

Alteryx Platform Editions & Modules

On-premise Edition
Alteryx Designer$3,9951
Alteryx Designer with Spatial$12,9951
Alteryx Designer with Data$29,9951
Alteryx Server$45,0002
  1. per user, per year
  2. per server, per year
SaaS Edition
Alteryx Analytics Gallery$1,5001
  1. per user, per year
Additional Pricing Details
The above prices are in USD for Alteryx products and are per-year subscription prices based on a 3-year contract, with annual payment.

Rating Summary

Likelihood to Recommend

Actian Pervasive Data Integrator
7.0
Alteryx Platform
8.8

Likelihood to Renew

Actian Pervasive Data Integrator
Alteryx Platform
6.5

Usability

Actian Pervasive Data Integrator
Alteryx Platform
10.0

Reliability and Availability

Actian Pervasive Data Integrator
Alteryx Platform
10.0

Support Rating

Actian Pervasive Data Integrator
Alteryx Platform
9.8

Implementation Rating

Actian Pervasive Data Integrator
Alteryx Platform
10.0

Add comparison