We performed a comparison between Actian Pervasive Data Integrator [EOL], Informatica PowerCenter, 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 provides everything I need. Nothing is missing. PowerCenter is a good tool for on-premise databases."
"We can scale the product."
"The technical support for Informatica PowerCenter is good."
"The performance and design of Informatica have been very valuable. I find the performance faster than, say, Oracle Data Integrator or DataStage."
"It reduces a lot of legacy coding."
"It is an excellent ETL tool."
"One of the most valuable features for us is the metadata repository because it can easily understand the lineage of first target mapping. My company and I also find Informatica really easy to use—when a consultant joins our company, in just a few days to a few weeks, they can understand how to use it—so we prefer to use this ETL tool."
"It's a very powerful tool you can use to load data, get data, do the drawing between the tables, and put into the packet in a very fast way."
"SSIS is easy to use."
"The most valuable thing is that it is easy to connect with Microsoft tools. In Europe, particularly in France, a lot of companies use Excel, SQL Server, and other Microsoft tools, and it is easier to connect SSIS with Microsoft tools than other products."
"It's saved time using visualization descriptions."
"The solution is easy to use and developer friendly."
"This solution is easy to implement, has a wide variety of connectors, has support for Visual Basic, and supports the C language."
"The most valuable feature of SSIS is its ease of use. It is easier to use than other applications."
"The reporting on the solution is perfect. I didn't expect to see reporting features, but they are great."
"The most valuable feature of SSIS is that you can take data from other servers which are not MS SQL Server or Oracle."
"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)."
"There is some room for improvement in terms of pricing."
"The only problem with this product is the level of complexity with the number of levels of transformation that you have to go through."
"An issue which should be addressed is that the solution only allows us to do structured, as opposed to unstructured, data processing."
"Integrated Reporting service should be more smoothly transitioned from view to function to be in sync with the main design."
"The pricing could be improved."
"We had stability issues, mostly with JVM size."
"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."
"Integrating new tools can be tricky and challenging."
"We purchase an add on called task factory primarily to allow bulk delete, update and upsert capability. I'd like to see this be part of the standard package."
"SSIS can improve by the minimum code requirements in stored procedures and exporting data is difficult. They could make it easier, it should be as easy as it is to import data."
"The high prices attached to the product can be an area of concern where improvements are required."
"We'd like them to develop data exploration more."
"We In upgrading SSIS, we encountered challenges fixing SQL Server and performance issues, including problems during a failover in our data warehouse."
"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."
"Future releases should improve the data lineage, as it currently is not good."
"There is connectivity with other databases, however, this is the most significant issue that has to be addressed."
Earn 20 points