We performed a comparison between Informatica PowerCenter, 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."It is an excellent ETL tool."
"PowerCenter performs well during data transformation and optimization."
"The setup is very simple."
"Can manage a huge quantity of data and provide reliability."
"It has a Data Catalog that uses the Model repository."
"What I like the most is that we have to deal with less while writing the queries."
"The most valuable aspects of Informatica PowerCenter are the many features, ease of use, and user-friendliness."
"Reusable definition of data sources and the out-of-the-box availability of a large number maplets for common transformation functions."
"The most valuable features of SSIS are that it works with the query language and it can import data from different sources."
"The most important features are it works well and provides self-service BI."
"It is easy to set up. The deployment is also very quick."
"SSIS is easy to use."
"The setup was easy. All Microsoft products are easy to set up."
"Its compatibility with Microsoft products has been very valuable to our company. It fits well within the architecture."
"Overall, it's a good product."
"The technical support is very good."
"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."
"I like the data vault implementations."
"The most valuable feature is the metadata generated code."
"It has a built-in automatic scheduling environment."
"This is a fantastically robust DW tool that will make you at least 10 times faster in producing a DW."
"The tool supports multiple target update methods."
"RED generates comprehensive documentation and regenerates it as quickly as things changes, but it also provides impact documentation."
"I found the initial setup very easy."
"While Informatica is great for data-integration, it does not have any analytics features. Thus, organizations have to always look for another product for their BI needs."
"This solution needs the functionality to do batch processing of data. It also lacks connectivity to NoSQL, unstructured data sources."
"Areas for improvement in Informatica PowerCenter include scalability and high availability or the clustering configuration because that's still very basic. The elasticity or scaling of the platform needs a lot of improvement. For example, when it comes to DR handling or building an active-active or active-passive cluster, Informatica PowerCenter is still not that powerful. Automation also needs improvement in the solution. Improving automation leads to some improvement in the stability of Informatica PowerCenter and other aspects related to it. What I'd like to see in the next release of Informatica PowerCenter is real-time capability because the solution is mainly for patches, and to have real-time integration, you need to count on some additional components from Informatica. I would expect more integration and a complete platform in terms of real-time capability or patching with minimal interventions or minimal components to be aligned together."
"While on-premises is a better product, we really need to move to the cloud and need the cloud to be as robust as this product."
"It would be nice to have all tools in one place. CDC needs more effort, as it's only easy to develop if you are familiar with Linux."
"The initial setup is not straightforward. You need expertise to do it."
"The solution's commercial cost is very high. Other open-source tools can do the tool's functions for free. The world is moving to the cloud, but the solution hasn't updated its drivers. I presume that its downfall will start soon. The tool is trying to cross-sell or upsell without helping customers derive benefits from the existing products. They have multiple tools and licenses. It is better to bring the smaller tools in one umbrella."
"Unstructured data handling is an important area with a shortcoming that needs improvement in the solution."
"Improving the login procedure would make our reporting easier on monitoring our ETL processes."
"We've had issues in terms of the amount of data that is transferred when we are scheduling."
"There were some issues when we tried to connect it to data storage. It was a connection issue."
"When I compare Talend and SSIS, Talend provides more features. With Talend, we can handle a large volume of data. Talend is usually used to treat a large volume of data, which makes it better than SSIS on the data side. Talend also has a very good Talend Management Console to schedule the jobs and do other things. It can also be easily connected to version control tools such as GitHub or SVN. The last time I used SSIS, it was connected through TSS for the Windows Console version. I am not sure it has been improved or not. If it is not improved, Microsoft should improve it. They should change the product to provide another console."
"Video training would be a helpful addition."
"Future releases should improve the data lineage, as it currently is not good."
"SSIS sometimes hangs, and there are some problems with servers going down after they've been patched."
"I would like to see better technical documentation because many times information is missing."
"It could use a tool to diagnose what is missing from the environment for WhereScape to install successfully."
"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."
"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."
"No support for change data capture or delta detection - that must be custom coded ."
"The ability to execute SSIS projects within WhereScape would be nice because we have a lot of packages that are too cumbersome to recreate."
"The solution can be a little more user-friendly on enterprise-level where people use it."
"Improve the object renaming ability (it works, but it could be more automated)."
"Customization could be better."
Earn 20 points