What users are saying about

Actian Pervasive Data Integrator

3 Ratings
Score 3.7 out of 101

SSIS

152 Ratings
Score 7.9 out of 101

Add comparison

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 profile photo

SSIS

If you need to move data around or direct the workflow of a process, SSIS can do it. It is a very capable piece of software that I use heavily every day. You do need to be careful because you can over-utilize it for simple things. If you just need to run a piece of SQL every hour to update some values, just use the Agent Scheduler, it's easier. But if you need to automate things in a repeatable and consistent manner, SSIS is a very good product.
Greg Goss profile photo

Feature Rating Comparison

Data Source Connection

Actian Pervasive Data Integrator
7.0
SSIS
8.1
Connect to traditional data sources
Actian Pervasive Data Integrator
7.0
SSIS
9.1
Connecto to Big Data and NoSQL
Actian Pervasive Data Integrator
SSIS
7.1

Data Transformations

Actian Pervasive Data Integrator
7.0
SSIS
8.7
Simple transformations
Actian Pervasive Data Integrator
9.0
SSIS
9.3
Complex transformations
Actian Pervasive Data Integrator
5.0
SSIS
8.0

Data Modeling

Actian Pervasive Data Integrator
4.3
SSIS
7.5
Business rules and workflow
Actian Pervasive Data Integrator
5.0
SSIS
8.6
Collaboration
Actian Pervasive Data Integrator
3.0
SSIS
6.9
Testing and debugging
Actian Pervasive Data Integrator
5.0
SSIS
8.2
Data model creation
Actian Pervasive Data Integrator
SSIS
7.1
Metadata management
Actian Pervasive Data Integrator
SSIS
6.6

Data Governance

Actian Pervasive Data Integrator
SSIS
7.7
Integration with data quality tools
Actian Pervasive Data Integrator
SSIS
7.7
Integration with MDM tools
Actian Pervasive Data Integrator
SSIS
7.7

Pros

  • 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 profile photo
  • Native data connections to SQL Server and Azure SQL DB and DW
  • Flat file processing
  • .NET C#/VB scripting
  • Ease of use in designing and implementing control flows within conditional processing and looping
David Milillo profile photo

Cons

  • 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 profile photo
  • I think it handles undefined/dynamic data sources poorly. Considering that we use it primarily to ETL data from other systems across the whole organization to bring into our BU's data warehouse, we sometimes have issues when the source has changed. If someone adds a column without letting us know, we'll need to modify the SSIS packages.
  • Sometimes the error codes are vague or cryptic. When debugging a SSIS package I have to google the code or error message and hope someone has a similar issue on stack overflow.
  • SSIS really only works if you're already using a lot of Microsoft Products like Microsoft SQL Server or SQL Server Reporting Services. As mentioned in the name of the application, "integration services", it's designed to integrate your products together so that you can get the most out of it.
Hung Nguyen profile photo

Likelihood to Renew

No score
No answers yet
No answers on this topic
SSIS6.0
Based on 2 answers
A bit outdated compared to competitors, esp in the open source community
No photo available

Usability

No score
No answers yet
No answers on this topic
SSIS8.0
Based on 2 answers
Easy to use, however there are functionality limits
No photo available

Support

No score
No answers yet
No answers on this topic
SSIS9.0
Based on 3 answers
The support, when necessary, is excellent. But beyond that, it is very rarely necessary because the user community is so large, vibrant and knowledgable, a simple Google query or forum question can answer almost everything you want to know. You can also get prewritten script tasks with a variety of functionality that saves a lot of time.
Chris Morgan profile photo

Implementation

No score
No answers yet
No answers on this topic
SSIS10.0
Based on 1 answer
The implementation may be different in each case, it is important to properly analyze all the existing infrastructure to understand the kind of work needed, the type of software used and the compatibility between these, the features that you want to exploit, to understand what is possible and which ones require integration with third-party tools
Luca Campanelli profile photo

Alternatives Considered

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 profile photo
While Clover provides a number of the same data transformation techniques, it is not nearly as robust as SSIS. It also requires knowledge of the specific scripting language while SSIS allows the user to choose from a number of commonly-used scripting languages (i.e. VB, C#, etc.). If you are using SQL Server, integrating with SSIS is a no-brainer.
No photo available

Return on Investment

  • 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 profile photo
  • Saves us a considerable amount of time required to import our data.
  • Streamlines the order import/processing process for our business and makes it easier for us to meet our target ship dates as we have no bottlenecks during the import flow.
No photo available

Pricing Details

Actian Pervasive Data Integrator

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

SSIS

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