3 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>
Score 3.1 out of 101
193 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>
Score 7.8 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

Power BI For Office 365

If you want to create a visual dashboard or report that utilises various data sources then PowerBI can do this. It is great in that it takes your on-premises data and stores it on Microsoft servers where it can interact with it faster, reducing load on your own servers, while being efficient in what it transfers out.We have found it not well suited if you wanted to publish a simple report to many staff as they may all need a Pro license which can get expensive. Even if embedding the report onto a shared platform like SharePoint, it will not display if the users doesn't have a PowerBI Pro license.
No photo available

Feature Rating Comparison

Data Source Connection

Actian Pervasive Data Integrator
7.0
Power BI For Office 365
Connect to traditional data sources
Actian Pervasive Data Integrator
7.0
Power BI For Office 365

Data Transformations

Actian Pervasive Data Integrator
7.0
Power BI For Office 365
Simple transformations
Actian Pervasive Data Integrator
9.0
Power BI For Office 365
Complex transformations
Actian Pervasive Data Integrator
5.0
Power BI For Office 365

Data Modeling

Actian Pervasive Data Integrator
4.3
Power BI For Office 365
Business rules and workflow
Actian Pervasive Data Integrator
5.0
Power BI For Office 365
Collaboration
Actian Pervasive Data Integrator
3.0
Power BI For Office 365
Testing and debugging
Actian Pervasive Data Integrator
5.0
Power BI For Office 365

BI Standard Reporting

Actian Pervasive Data Integrator
Power BI For Office 365
8.1
Pixel Perfect reports
Actian Pervasive Data Integrator
Power BI For Office 365
8.0
Customizable dashboards
Actian Pervasive Data Integrator
Power BI For Office 365
8.3
Report Formatting Templates
Actian Pervasive Data Integrator
Power BI For Office 365
7.9

Ad-hoc Reporting

Actian Pervasive Data Integrator
Power BI For Office 365
7.6
Drill-down analysis
Actian Pervasive Data Integrator
Power BI For Office 365
7.3
Formatting capabilities
Actian Pervasive Data Integrator
Power BI For Office 365
7.3
Integration with R or other statistical packages
Actian Pervasive Data Integrator
Power BI For Office 365
7.9
Report sharing and collaboration
Actian Pervasive Data Integrator
Power BI For Office 365
7.7

Report Output and Scheduling

Actian Pervasive Data Integrator
Power BI For Office 365
7.0
Publish to Web
Actian Pervasive Data Integrator
Power BI For Office 365
8.4
Publish to PDF
Actian Pervasive Data Integrator
Power BI For Office 365
8.0
Report Versioning
Actian Pervasive Data Integrator
Power BI For Office 365
6.5
Report Delivery Scheduling
Actian Pervasive Data Integrator
Power BI For Office 365
6.0
Delivery to Remote Servers
Actian Pervasive Data Integrator
Power BI For Office 365
6.0

Data Discovery and Visualization

Actian Pervasive Data Integrator
Power BI For Office 365
8.4
Pre-built visualization formats (heatmaps, scatter plots etc.)
Actian Pervasive Data Integrator
Power BI For Office 365
8.5
Location Analytics / Geographic Visualization
Actian Pervasive Data Integrator
Power BI For Office 365
8.7
Predictive Analytics
Actian Pervasive Data Integrator
Power BI For Office 365
7.9

Access Control and Security

Actian Pervasive Data Integrator
Power BI For Office 365
8.5
Multi-User Support (named login)
Actian Pervasive Data Integrator
Power BI For Office 365
8.7
Role-Based Security Model
Actian Pervasive Data Integrator
Power BI For Office 365
8.7
Multiple Access Permission Levels (Create, Read, Delete)
Actian Pervasive Data Integrator
Power BI For Office 365
7.7
Single Sign-On (SSO)
Actian Pervasive Data Integrator
Power BI For Office 365
8.8

Mobile Capabilities

Actian Pervasive Data Integrator
Power BI For Office 365
7.9
Responsive Design for Web Access
Actian Pervasive Data Integrator
Power BI For Office 365
8.0
Dedicated iOS Application
Actian Pervasive Data Integrator
Power BI For Office 365
8.0
Dedicated Android Application
Actian Pervasive Data Integrator
Power BI For Office 365
8.0
Dashboard / Report / Visualization Interactivity on Mobile
Actian Pervasive Data Integrator
Power BI For Office 365
7.4

Application Program Interfaces (APIs) / Embedding

Actian Pervasive Data Integrator
Power BI For Office 365
6.0
REST API
Actian Pervasive Data Integrator
Power BI For Office 365
6.0

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
  • Provides flexible and powerful analytics on large datasets. PowerPivot, the in-memory database engine, can handle 100's of millions of rows of data, giving 1-2 second response time for aggregate data analysis.
  • Provides an adaptable environment to perform analytics. When combining data together in PowerPivot, you have the ability to create Excel tables, combine them with database queries, and then join that with data coming from a web-service provider.
  • Powerful web-based deployment capabilities. SharePoint technologies have been a part of the Microsoft BI solution stack for some time. Office 365 provides a powerful way to deploy the Power BI analytics to a wider audience in a secure way, allowing for flexible access from most any device, whether phone, tablet, or computer.
  • Power Query, one of the components of Power BI, is one of my favorite parts of the solution. Basically, you have at your disposal an end-user "ETL" (Extract, Transform, Load) tool, all within Excel. We've reduced multi-step, manual processes to single-click, automatic application of business rules to collect and transform data into a usable format. No need for VLOOKUP any longer with this capability.
Ken Raetz 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'd like to be able to use visuals based on different data sets in the same page.
  • The visuals are limited - I'd like to see a ribbon plot for example.
  • Would like to be able to use different data representations on the same visual. There's currently an ability to put lines on histograms but no ability to, for example, add points to a histogram or line plot. I understand some of these may be in development but you will never be able to create visuals for each possible combination. You need a way of combining two visuals into one - e.g. line and points.
  • DAX is very powerful but a bit complicated for some users. I think you need to make some of the functionality that's available in DAX exposed at the UI level.
  • The R visual gives the flexibility to plot a lot of stuff but it is limited by only being able to plot what's passed in the dataset.
  • You need a text entry box that you can filter datasets by.
Richard Lorenz profile photo

Likelihood to Renew

No score
No answers yet
No answers on this topic
Power BI For Office 3659.2
Based on 4 answers
It is a cheap way of exploring data and comes with the whole Office 2013 experience, including Sharepoint. For a new company, it is hard to find a better deal.
Eltjo Verweij 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
Oracle was nice, super expensive to implement if it's not in use already. JobDiva is choppy and heavy on the system while does not give great reports. Salesforce is good; remote access is good however their support is terrible
Daniel J. Lewis 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
  • It's allowed us to better visualize large amounts of data.
  • It's an easy way to tie into an existing SQL database for users that don't know SQL.
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

Power BI For Office 365

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