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 solution is very stable."
"The most valuable feature of the solution is its amazing capabilities in regard to data handling."
"The solution offers very good data manipulation and loading."
"It's already very user-friendly and has a good dashboard."
"You can get data from any data source with SSIS and dump it to any outside source. It is helpful. Getting, extracting, converting, and dumping data doesn't require much effort because we can do everything in the user interface. You drag and drop, then give the required input. It's intuitive."
"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 interface is very user-friendly."
"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."
"The debugging capabilities are great, particularly during data flow execution. You can look into the data and see what's going on in the pipeline."
"The performance and stability are good."
"SSIS integrates well with SQL servers and Microsoft products."
"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)."
"The transform tool has limited access. They should make it more flexible."
"The initial setup of SAS Data Integration Server was complex."
"So I would like to see improved integration with other software."
"It hangs a lot of the time."
"Performance could be better."
"SSIS sometimes hangs, and there are some problems with servers going down after they've been patched."
"The creation of the measure in the DAC's model could be improved."
"SSIS is stable, but extensive ETL data processing can have some performance issues."
"The solution could improve by having quicker release updates."
"Generic processes should be used instead of custom code for each table."
"We'd like them to develop data exploration more."
Earn 20 points