We performed a comparison between Actian Pervasive Data Integrator [EOL], SSIS, and WhereScape RED 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."
"I have found its most valuable features to be its package management capabilities and the flexibility it offers in designing workflows."
"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 stable."
"The initial setup of this solution is very straightforward."
"SSIS is an easy way to do data integration from various data sources. It doesn't matter whether it's a database, flat files, XML, or Web API. It can talk to the and join them all together."
"In SSIS, the scope is not only to handle ETL challenges, but it will allow us to do so many other tasks, such as DBA activities, scripting, calling any .exe or scripts, etc."
"The product's deployment phase is easy."
"I have used most of the standard SQL features, but the ones that stand out are the Data Flows and Bulk Import."
"Support is absolutely excellent, efficient, and timely."
"I found the initial setup very easy."
"Their support staff are very knowledgeable, courteous, and professional. I feel their support staff go above and beyond to assure their customers are satisfied."
"The tool supports multiple target update methods."
"Quickly develops a data warehouse for our organization with documentation and can track back/forward features."
"RED has provided us the ability to integrate, stage, and transform data from diverse sources into an enterprise-grade data warehouse which meets the needs of my organization, but it also enables us to easily and quickly make ETL or DW changes."
"The most valuable feature is the metadata generated code."
"It has a built-in automatic scheduling environment."
"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)."
"Sometimes when we want to publish to other types of databases it's not easy to publish to those databases. For example, the Jet Database Engine. Before the SSIS supported Jet Database Engine but nowadays it doesn't support the Jet Database Engine. We connect to many databases such as Access database, SparkPros databases and the other types of databases using Jet Database Engines now and SSIS now doesn't seem to support it in our databases."
"The solution should work on the GPU, graphical processing unit. There should also be piping integration available."
"It should have other programming languages supported as well from a scripting perspective. Currently, only C# and VB.NET are supported, which limits it to .NET. It should have Java support as well."
"SSIS is stable, but extensive ETL data processing can have some performance issues."
"I would like to see more features in terms of the integration with Azure Data Factory."
"Generic processes should be used instead of custom code for each table."
"It's difficult to refactor SSIS. It gets cumbersome to reuse the solution."
"SSIS should be made a little bit more intuitive and user-friendly because it needs an expert-level person to work on it."
"It could use a tool to diagnose what is missing from the environment for WhereScape to install successfully."
"Project-based searching of data objects in the data warehouse browser needs to be improved."
"They need a more robust support center. It has been a bit difficult to find solutions to problems that are out-of-the-box."
"The ability to execute SSIS projects within WhereScape would be nice because we have a lot of packages that are too cumbersome to recreate."
"Jobs cannot be deleted via the deployment package. When deploying from dev to QA or production, a job has to be retired. The job has to be manually removed from the target environment."
"Technical support isn't the best."
"Improve the object renaming ability (it works, but it could be more automated)."
"No support for change data capture or delta detection - that must be custom coded ."
Earn 20 points
Earn 20 points