Actian Pervasive Data Integrator [EOL] vs SSIS comparison

"Web based interface."

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

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

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

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

"Data Flows are the main component we use. These can range from a simple source to sink ETL, to many source to many sink dataflows."

"The return on investment has been very high; the tool has made us tremendously more efficient and saved us a significant amount of money, though I cannot put an exact figure on it."

"The most valuable features of SSIS are that it works with the query language and it can import data from different sources."

"The reporting on the solution is perfect. I didn't expect to see reporting features, but they are great."

"I like that this solution is very scalable, accommodating large datasets and various types of servers. It integrates with most common database servers and allows for customization through coding, including complex scripts. Compared to Alteryx Designer, SSIS offers more customization. Its data cleaning capabilities are highly accurate because we can run tests as data is loaded, ensuring it meets all requirements before reaching the final destination. The ability to write custom SQL and C# code within SSIS packages is its greatest feature."

"The data reader is the most valuable feature."

"The transformation of data is very good in SSIS."

"We like that this solution includes a developer edition, free of charge, to allow for training."

"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)."

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

"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."

"Improvement as per customer requirements."

"Video training would be a helpful addition, however."

"Microsoft support isn't helpful most of the time. We get most of our answers from forums."

"Involving a data lake or data engineering aspects would be useful. While it is there, we need more features included."

"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."

"This may be done, but upgrades to new versions required re-implementing each package."

"It's difficult to refactor SSIS. It gets cumbersome to reuse the solution."

"We have faced some problems, mostly from a different provider with different language handling."

"It comes bundled with other solutions, which makes it difficult to get the price on the specific product."

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

"People have to opt for a perpetual-based licensing model."

"The solution is economical. You don't have to worry about the pricing as long as you're installing both services on the same server."

"I'm not involved in licensing details, but SSIS provides value to our organization by simplifying data management tasks."

"This solution is a free of charge addition to our SQL licence. However, the only way this tool can be utilized is as a feature of the SQL licence, which may make it unattractive to organizations who don't wish to purchase the wider-ranging licence."

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

"It would be beneficial if the solution had a less costly cloud offering."