We performed a comparison between Actian Pervasive Data Integrator [EOL], SAS Data Integration Server, 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."
"The most valuable feature of the solution is its amazing capabilities in regard to data handling."
"The solution is very stable."
"The solution offers very good data manipulation and loading."
"It is easy to set up the solution."
"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."
"Its compatibility with Microsoft products has been very valuable to our company. It fits well within the architecture."
"It is easy to set up. The deployment is also very quick."
"The most valuable features of this solution are the fast insert and fuzzy logic matching."
"SSIS' most valuable feature is its reporting services."
"The UI is very user-friendly."
"The performance and stability are good."
"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)."
"So I would like to see improved integration with other software."
"The initial setup of SAS Data Integration Server was complex."
"The transform tool has limited access. They should make it more flexible."
"A change in the metadata source cripples the whole ETL process, requiring each module to be manually reopened."
"The security could be improved, as it is more important in our context."
"I would like to see more features in terms of the integration with Azure Data Factory."
"Performance could be better."
"We would like the solution to be expanded so that it is available for other platforms than just Microsoft."
"It would be nice if you could run SSIS on other environments besides Windows."
"The solution could improve on integrating with other types of data sources."
"I would also like to see full integration with our BI because then our full load of data will be available in our organization. They should incorporate an ATL process."
Earn 20 points