We performed a comparison between Informatica PowerCenter, SSIS, and TIBCO BusinessWorks based on real PeerSpot user reviews.
Find out what your peers are saying about Microsoft, Informatica, Oracle and others in Data Integration."Informatica PowerCenter is very good for integrating a huge amount of data in a very short duration, such as a minute. It is also very easy to use. After you provide the source and the target, mappings are automatically done, which makes it easy to use for the development team."
"The ability to scale through partitions helped us to improve the performance."
"Informatica PowerCenter is a very good ETL tool."
"It's very easy to use it to develop mappings and workflows."
"The performance and design of Informatica have been very valuable. I find the performance faster than, say, Oracle Data Integrator or DataStage."
"The greatest feature is that it is very easy to have someone come in and jump right in. It is one of the nicest tools in terms of getting a person acquainted quickly."
"The most valuable feature is the new Data Lake feature, which provides the basic capabilities needed."
"It has a Data Catalog that uses the Model repository."
"With this solution, there is the potential to expand, so that you can immediately write code onto the SQL server."
"The reporting on the solution is perfect. I didn't expect to see reporting features, but they are great."
"SSIS' best feature is SFTP connectivity."
"It's something I needed for bulk imports. I'm not a big fan of it, but I haven't seen anything better."
"We like that this solution includes a developer edition, free of charge, to allow for training."
"The initial setup of this solution is very straightforward."
"It is easily scheduled and integrates well with SQL Server and SQL Server Agent jobs."
"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 most important thing is that it is easy for developers to work with."
"I work in operations, so I value BusinessWorks' performance the most."
"One of the most valuable features is that it's a simple development. It takes a short time to get services to work."
"Good performance and reliability."
"We use the solution to develop applications."
"The OSGI console is available to debug different issues and get low level informations on the applications development, like bundle, dependencies, etc."
"XML to JSON transformations, out-of-the-box, helps to build REST services."
"The solution is stable. We haven't had any serious technical issues."
"This product is going to decommission in the next couple of years."
"The UI is outdated and old-fashioned, at least in our current version. Also, we have experienced some stability issues with the Workflow Monitor application."
"The real-time database connectivity when getting the real-time data using the VPN is an area that needs improvement."
"The solution must improve the integration with new services."
"The licensing cost for Informatica is very high. Other all-in-one solutions have much lower prices than Informatica."
"Informatica PowerCenter could improve on the documentation for the implementation. The documents provided are not very good for a new user."
"The price of the product is an area of concern where improvements are required, considering the fact that the present licensing charges of the tool are expensive."
"The multiple interfaces in Informatica PowerCenter are not great for the user experience. Because of this, I think it can cause confusion for any beginner developer."
"Performance could be better."
"It's difficult to refactor SSIS. It gets cumbersome to reuse the solution."
"I have a tool called ZappySys. I need that tool to cut down on the complexity of SSIS. That tool really helps with a quick turnaround. I can do things quickly, and I can do things accurately. I can get better reporting on errors."
"SSIS doesn't have a very good user interface, but if you can work with it, it'll provide you with almost all of the functionality."
"At one point, we did have to purchase an add-on."
"In terms of its performance, it could be better. That could be something that would be easy and welcomed as an upgrade."
"Generic processes should be used instead of custom code for each table."
"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."
"Cloud fitness is lacking"
"A possible improvement could be to give the capability to use different profiles for each AppNode when an application is deployed on an AppSpace."
"Though it is a stable product, if we have an issue with the product, it gets difficult, and it gets really difficult to explain the issue to the support team. Also, it takes a long time to get resolved."
"Technical support is average. It's not the best."
"Its price can be improved. For medium enterprises, it is a very expensive tool. In the market, you won't get many resources for this solution. You won't find many developers in the market very easily. The latest version of TIBCO (6.4 or 6.x) is not very stable. It has got many issues. We have raised this with TIBCO, and they are taking a lot of time to come up with a fix, which is making us move away from this product. Some of the performance-tuning aspects are also missing in version 6. They should provide performance-related fixes, which will be helpful for the customers. If you are migrating from the current version to the container-supported version, it is quite expensive. The product has evolved, but it is very pricey. That's one of the challenges. They have provided all the features that are there in other products, but this is a platform upgrade. The platform has completely been changed from 5.x to 6.x, and we can't use the same environment. We can't run both versions on the same server as VM. The development environment is entirely different. In version 5.x, there was a proprietary designer. Now, it has common plug-ins developed on top of Eclipse."
"There is room for improvement on the learning side."
"I would like the solution to be integrated into the cloud."
"The cost of the solution has room for improvement."