We performed a comparison between Actian Pervasive Data Integrator [EOL], SSIS, and TIBCO Cloud Integration 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."
"Its compatibility with Microsoft products has been very valuable to our company. It fits well within the architecture."
"The scalability of SSIS is good."
"SSIS' best feature is SFTP connectivity."
"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 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."
"I have used most of the standard SQL features, but the ones that stand out are the Data Flows and Bulk Import."
"The UI is very user-friendly."
"This solution is easy to implement, has a wide variety of connectors, has support for Visual Basic, and supports the C language."
"The product's initial setup phase was easy."
"I am really impressed by TIBCO's integration of any level of complexity."
"I like that it is a very good integration tool with many other things. TIBCO is very good for cloud integration"
"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)."
"Future releases should improve the data lineage, as it currently is not good."
"Options for scaling could be improved."
"The security could be improved, as it is more important in our context."
"It needs more integration tools, so you can connect to different sources."
"In terms of its performance, it could be better. That could be something that would be easy and welcomed as an upgrade."
"Microsoft should offer an on-premises support warranty for those using that deployment. They seem to be withdrawing from on-premises options."
"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."
"You have to write push down join & lookup SQL to the database yourself via stored procedures or use of the SQL Task to get very high performance. That said, this is a common complaint for nearly all ETL tools on the market and those that offer an alternative such as Informatica offer them at a very expensive add-on price."
"Integrations could be better. Although integration is good, we have faced some block issues."
"TIBCO Cloud Integration is not a user-friendly tool when it comes to the installation phase or for maintaining the systems since its architecture is really complex."
"The deployment was rather complicated."
Earn 20 points