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."
"We like that this solution includes a developer edition, free of charge, to allow for training."
"I have found its most valuable features to be its package management capabilities and the flexibility it offers in designing workflows."
"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."
"SSIS provides you with lookup and transformation functions, and you have the flexibility to write your own custom code."
"The debugging capabilities are great, particularly during data flow execution. You can look into the data and see what's going on in the pipeline."
"It has a drag and drop feature that makes it easy to use. It has a good user experience because it takes into account your most-used tools and they're lined up nicely so you can just drag and drop without looking too far. It also integrates nicely with Microsoft."
"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."
"It is easy to set up the product."
"I found the initial setup very easy."
"RED generates comprehensive documentation and regenerates it as quickly as things changes, but it also provides impact documentation."
"Naturally produces a way to easily debug your DW data solutions."
"Quickly develops a data warehouse for our organization with documentation and can track back/forward features."
"WhereScape's deployment package is a fantastic feature. The application allows for selecting specific objects that you would like to deploy from one environment to another rather than deploying the entire database."
"WhereScape is really helpful in terms of architecture data. Everything is one of automation. Two people can do thousands of tables in one day or two. It saves a lot of time."
"Their support staff are very knowledgeable, courteous, and professional. I feel their support staff go above and beyond to assure their customers are satisfied."
"Support is absolutely excellent, efficient, and timely."
"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)."
"I would like to see more standard components out of the box, such as SFTP, and Data Compression components."
"I would like to see more features in terms of the integration with Azure Data Factory."
"In terms of its performance, it could be better. That could be something that would be easy and welcomed as an upgrade."
"Improving the login procedure would make our reporting easier on monitoring our ETL processes."
"There is connectivity with other databases, however, this is the most significant issue that has to be addressed."
"There are a lot of things that Microsoft could improve in relation to SSIS. One major problem we faced was when attempting to move some Excel files to our SQL Server. The Excel provider has a limitation that prevents importing more than 255 columns from a particular Excel file to the database. This restriction posed a significant issue for us."
"Generic processes should be used instead of custom code for each table."
"Options for scaling could be improved."
"The scheduled jobs which are run by the WhereScape scheduler seem to be a strangely separate animal. Unlike all other WhereScape objects, jobs cannot be added to WhereScape projects. Also, unlike all other objects, jobs also cannot be deleted using a WhereScape deployment application."
"The solution can be a little more user-friendly on enterprise-level where people use it."
"Technical support isn't the best."
"The ability to execute SSIS projects within WhereScape would be nice because we have a lot of packages that are too cumbersome to recreate."
"Customization could be better."
"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."
"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."
Earn 20 points
Earn 20 points