What users are saying about

Actian Pervasive Data Integrator

3 Ratings
Score 3.7 out of 101

Analyza

1 Ratings
Score 8.2 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

Analyza

It is well suited when you have several sources of data.
Christophe Wins profile photo

Feature Rating Comparison

Data Source Connection

Actian Pervasive Data Integrator
7.0
Analyza
Connect to traditional data sources
Actian Pervasive Data Integrator
7.0
Analyza

Data Transformations

Actian Pervasive Data Integrator
7.0
Analyza
Simple transformations
Actian Pervasive Data Integrator
9.0
Analyza
Complex transformations
Actian Pervasive Data Integrator
5.0
Analyza

Data Modeling

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

BI Standard Reporting

Actian Pervasive Data Integrator
Analyza
7.6
Pixel Perfect reports
Actian Pervasive Data Integrator
Analyza
7.3
Customizable dashboards
Actian Pervasive Data Integrator
Analyza
8.2
Report Formatting Templates
Actian Pervasive Data Integrator
Analyza
7.3

Ad-hoc Reporting

Actian Pervasive Data Integrator
Analyza
8.4
Drill-down analysis
Actian Pervasive Data Integrator
Analyza
9.1
Formatting capabilities
Actian Pervasive Data Integrator
Analyza
8.2
Integration with R or other statistical packages
Actian Pervasive Data Integrator
Analyza
8.2
Report sharing and collaboration
Actian Pervasive Data Integrator
Analyza
8.2

Report Output and Scheduling

Actian Pervasive Data Integrator
Analyza
8.9
Publish to Web
Actian Pervasive Data Integrator
Analyza
8.2
Publish to PDF
Actian Pervasive Data Integrator
Analyza
9.1
Report Versioning
Actian Pervasive Data Integrator
Analyza
9.1
Report Delivery Scheduling
Actian Pervasive Data Integrator
Analyza
9.1

Data Discovery and Visualization

Actian Pervasive Data Integrator
Analyza
7.3
Pre-built visualization formats (heatmaps, scatter plots etc.)
Actian Pervasive Data Integrator
Analyza
7.3
Predictive Analytics
Actian Pervasive Data Integrator
Analyza
7.3

Access Control and Security

Actian Pervasive Data Integrator
Analyza
7.7
Multi-User Support (named login)
Actian Pervasive Data Integrator
Analyza
7.3
Multiple Access Permission Levels (Create, Read, Delete)
Actian Pervasive Data Integrator
Analyza
8.2

Mobile Capabilities

Actian Pervasive Data Integrator
Analyza
8.2
Responsive Design for Web Access
Actian Pervasive Data Integrator
Analyza
9.1
Dashboard / Report / Visualization Interactivity on Mobile
Actian Pervasive Data Integrator
Analyza
7.3

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
  • Easy to use
  • Focus on analyzing and not on finding and loading data
  • "One version of the truth"
Christophe Wins 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 would like to have more modules. Eg. : supply chain tool.
Christophe Wins 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
Cognos is very expensive and needs heavy IT-team to implement it.
Christophe Wins profile photo

Collaboration and Sharing

No score
No answers yet
No answers on this topic
Analyza8.2
Based on 1 answer
Everybody sees one single version of the truth. You can easily share dashboards.
Christophe Wins profile photo

Data Integration

No score
No answers yet
No answers on this topic
Analyza9.1
Based on 1 answer
Analyza is able to connect to all kind of data sources and to do joins.
Christophe Wins profile photo

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
No answers on this topic

Screenshots

Actian Pervasive Data Integrator

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
Actian Pervasive Data Integrator
Additional Pricing Details

Analyza

General
Free Trial
Yes
Free/Freemium Version
Premium Consulting/Integration Services
Yes
Entry-level set up fee?
Required
$15,000*
1.  per installation (including licences and maintenance for 3 years)
Analyza Editions & Modules
Analyza
On-premise Edition
Analyza Standalone
$15,0001
1. per installation (including licences and maintenance for 3 years)
SaaS Edition
Analyza Cloud
$15,0001
1. per installation (including licences and maintenance for 3 years)
Additional Pricing Details
The On-Premise or SaaS solutions are the same price; we provide a dedicated machine or virtual machine for both. For 10 users, the budget is from $15,000 to $90,000 for a full Business Intelligence solution (including licenses and maintenance for 3 years). The installation and configuration cost depends on customer's data architecture, volume and number of sources. It also depends on customizations required (i.e.: exporting pixel to pixel PDF files to a SharePoint platform).