Actian Pervasive Data Integrator [EOL] vs SSIS comparison

"We have been using it for ETL, it is very robust and easy to use."

"There were no concerns with the stability. This product is very good from a stability perspective."

"Web based interface."

"For data transfers and ETLs on Windows, this is a great product."

"This product is extremely useful and better than building an in-house solution."

"Like most Microsoft products, SSIS is user-friendly and easy to use."

"Stability is rated at 10."

"Despite the complexity when dealing with advanced transformations, it is straightforward for simple data movements, and the performance is excellent."

"It is easy to set up. The deployment is also very quick."

"The scalability of SSIS is good."

"It is easy to set up the solution."

"The solution is easy to use and developer friendly."

"Microsoft SQL Server Integration Services is one of the most effective ETL tools available in the market."

"Technical support is an area which can definitely improve."

"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 areas which I think need to be improved are the transform and load steps."

"At the moment, we can't even use it for 1, since it keeps failing in our QA testing."

"Sometimes when we want to publish to other types of databases it's not easy to publish to those databases."

"We have issues with SSIS connectors while extracting data from Excel sources."

"The logging capabilities could be improved, particularly for error logging."

"SSIS is cumbersome despite its drag-and-drop functionality. For example, let's say I have 50 tables with 30 columns. You need to set a data type for each column and table. That's around 1,500 objects. It gets unwieldy adding validation for every column. Previously, SSIS automatically detected the data type, but I think they removed this feature. It would automatically detect if it's an integer, primary key, or foreign key column. You had fewer problems building the model."

"This solution is stable, but the performance is not good."

"The performance of SSIS could improve when comparing it to Oracle Database."

"Scalability not on the same level as with IBM Datastage."

"Another consideration is real-time processing needs. If this is a requirement then I would recommend against using this solution, unless the next version has a new set of features specifically for real-time processing."

"This solution is included with the MSSQL server package."

"SSIS is fairly well-priced - I would rate it at four out of five."

"All of my clients have this product included as part of their Microsoft license."

"The solution comes free of cost."

"Our license with SSIS is annual."

"SSIS' licensing is a little high, but it gives good value for money."

"We purchased the standard edition of SQL Server and SSIS came with it free of charge."

"t's incredibly cost effective, easy to learn the basics quickly (although like all ETL tools requires the traditional learning curve to get good at) and has an immense user base."