Actian Pervasive Data Integrator [EOL] vs SSIS comparison

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

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

"Web based interface."

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

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

"The main benefits SSIS provides for my company is to streamline processes, and the reporting process is the most useful for me, as most of our data is captured into SQL, making it easier to pull the differences in reports for the year."

"The most valuable features for our company are the flexibility and the quick turn around time in producing simple ETL solutions."

"It's a competent product."

"The technical support is very good."

"The data flow, which controls the data, including where to store it, is an excellent feature and is one of the most interesting points about SQL Integration Services."

"The main value of any Microsoft product is the ease of use. You can achieve more with less time. That's what's beneficial for me. With many competitors, you might need to spend more time coming up with a solution because you have to focus on taking care of the product."

"The most important features are it works well and provides self-service BI."

"The areas which I think need to be improved are the transform and load steps."

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

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

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

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

"We would like the solution to be expanded so that it is available for other platforms than just Microsoft."

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

"It needs more integration tools, so you can connect to different sources."

"At one point, we did have to purchase an add-on."

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

"The UI could use refinement."

"If you run SSIS from the local system, it will lag, but it will work properly if you host on the cloud somewhere."

"Our license with SSIS is annual."

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

"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 is a cheaper option compared to the cost of other ETL tools."

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

"Based on my experience and understanding, Talend comes out to be a little bit expensive as compared to SSIS. The average cost of having Talend with Talend Management Console is around 72K per region, which is much higher than SSIS. SSIS works very well with Microsoft technologies, and if you have Microsoft technologies, it is not really expensive to have SSIS. If you have SQL Server, SSIS is free."

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

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