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
8 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

SAS Data Management Platform

SAS Data Management Platform is very well suited if you have common data sources like Oracle, SAP, MS SQL, etc.. Still, if there are a bit more obscure, then you need to purchase additional connectors to connect to those data sources. It is well suited when you don't have a business team with strong technical/coding background as the drag and drop interface makes creating jobs and scheduling them quite easy.
Ravi Lagu | TrustRadius Reviewer

Feature Rating Comparison

Data Source Connection

Actian Pervasive Data Integrator
7.0
SAS Data Management Platform
8.0
Connect to traditional data sources
Actian Pervasive Data Integrator
7.0
SAS Data Management Platform
10.0
Connecto to Big Data and NoSQL
Actian Pervasive Data Integrator
SAS Data Management Platform
6.0

Data Transformations

Actian Pervasive Data Integrator
7.0
SAS Data Management Platform
9.0
Simple transformations
Actian Pervasive Data Integrator
9.0
SAS Data Management Platform
9.0
Complex transformations
Actian Pervasive Data Integrator
5.0
SAS Data Management Platform
9.0

Data Modeling

Actian Pervasive Data Integrator
4.3
SAS Data Management Platform
6.4
Business rules and workflow
Actian Pervasive Data Integrator
5.0
SAS Data Management Platform
9.0
Collaboration
Actian Pervasive Data Integrator
3.0
SAS Data Management Platform
5.0
Testing and debugging
Actian Pervasive Data Integrator
5.0
SAS Data Management Platform
2.0
Metadata management
Actian Pervasive Data Integrator
SAS Data Management Platform
9.0
feature 1
Actian Pervasive Data Integrator
SAS Data Management Platform
7.0

Data Governance

Actian Pervasive Data Integrator
SAS Data Management Platform
8.5
Integration with data quality tools
Actian Pervasive Data Integrator
SAS Data Management Platform
9.0
Integration with MDM tools
Actian Pervasive Data Integrator
SAS Data Management Platform
8.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

SAS Data Management Platform

  • Easy to use even for non-technical people
  • Connects to a variety of data sources
  • Statistical transformations available as part of the module
  • Graphical drag & drop interface
Ravi Lagu | 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

SAS Data Management Platform

  • Requires third-party drivers to connect to common data sources like SFDC, MS SQL, Postgres.
  • Debugging errors from the logs is a complicated process.
  • E-mail alert system is very primitive and needs customization to make it more modern,
  • Cannot send SMS alerts for jobs.
Ravi Lagu | TrustRadius Reviewer

Support Rating

Actian Pervasive Data Integrator

No score
No answers yet
No answers on this topic

SAS Data Management Platform

SAS Data Management Platform 9.0
Based on 1 answer
SAS Tech Support is one of the best tech supports available. Not only do they respond faster, but they also have a global 24x7 support team that helps in case of production server issues. The staff is quite knowledgable and accommodating. They help you via e-mail, phone, or even WebEx if the issue demands. The solutions they provide are quite detailed and easy to implement even for someone who hasn't worked on SAS.
Ravi Lagu | 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

SAS Data Management Platform

SAS Data Management Platform requires third-party drivers to connect to common data sources like SFDC, MS SQL, Postgres. Has almost all features present as compared to the alternatives we evaluated. On top of it, SAS offered statistical transformations and strong metadata management. SAS Data Management Platform was also the most cost-effective solution despite having to purchase a couple of connectors for SAP and Salesforce. The easy of applying security templates was also a feature that can be easily used as compared to others mentioned.
Ravi Lagu | 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

SAS Data Management Platform

  • The platform enabled us to have a single repository of customers to run campaigns on.
  • Feedback from various campaigns is stored in a single database, which makes running A/B analysis easier.
  • Helped improve data quality due to SAS Dataflux being a part of the SAS Data Management Platform.
Ravi Lagu | TrustRadius Reviewer

Pricing Details

Actian Pervasive Data Integrator

General

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

SAS Data Management Platform

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
SAS Data Management Platform
7.0

Support Rating

Actian Pervasive Data Integrator
SAS Data Management Platform
9.0

Add comparison