We performed a comparison between Actian Pervasive Data Integrator [EOL] and SSIS based on real PeerSpot user reviews.
Find out what your peers are saying about Microsoft, Informatica, Oracle and others in Data Integration."There were no concerns with the stability. This product is very good from a stability perspective."
"It is easy to set up the solution."
"It has the ability to be deployed into the cloud through Data Factory, and run completely as a software as a service in the cloud."
"Data Flows are the main component we use. These can range from a simple source to sink ETL, to many source to many sink dataflows."
"The data reader is the most valuable feature."
"There are many good features in this solution including the data fields, database integration, support for SQL views, and the lookups for matching information."
"The solution is easy to use and developer friendly."
"It's a competent product."
"The reporting on the solution is perfect. I didn't expect to see reporting features, but they are great."
"I am not sure if there are various connectors available in the recent version of Pervasive DI to support the wide range of sources available (e.g., big data, cloud, EME)."
"It's a legacy tool, that is nearing the end of its useful life."
"The solution could improve by having quicker release updates."
"We would like the solution to be expanded so that it is available for other platforms than just Microsoft."
"SSIS sometimes hangs, and there are some problems with servers going down after they've been patched."
"It needs more integration tools, so you can connect to different sources."
"I come from a coding background and this tool is graphically based. Sometimes I think it's cumbersome to do mapping graphically. If there was a way to provide a simple script, it would be helpful and make it easier to use."
"The security could be improved, as it is more important in our context."
"We're in the process of switching to Informatica, and we need to work out data lineage and data profiling and to improve the quality of our data. SSIS, however, is not that compatible with Informatica. We managed to connect it to Informatica Metadata Manager, but we don't get good lineage, so we have to redo all our ETLs using the Informatica process in order to accept the proper data lineage."
Earn 20 points
Actian Pervasive Data Integrator [EOL] doesn't meet the minimum requirements to be ranked in Data Integration while SSIS is ranked 2nd in Data Integration with 69 reviews. Actian Pervasive Data Integrator [EOL] is rated 5.8, while SSIS is rated 7.6. The top reviewer of Actian Pervasive Data Integrator [EOL] writes "You can use it to send data back and forth between Salesforce.com and JD Edwards". On the other hand, the top reviewer of SSIS writes "Maintaining the solution and contacting its support team is easy". Actian Pervasive Data Integrator [EOL] is most compared with , whereas SSIS is most compared with Informatica PowerCenter, Talend Open Studio, IBM InfoSphere DataStage, Oracle Data Integrator (ODI) and AWS Glue.
See our list of best Data Integration vendors.
We monitor all Data Integration reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.