SSIS vs Upsolver comparison

"The most valuable feature of SSIS is that it can handle real complex transformations."

"The simplicity of the solution is great. The solution also offers excellent integration."

"The technical support is very good."

"The UI is very user-friendly."

"It is easy to set up the product."

"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 most valuable feature of the solution is performance."

"I have found its most valuable features to be its package management capabilities and the flexibility it offers in designing workflows."

"It was easy to use and set up, with a nearly no-code interface that relied mostly on drag-and-drop functionality."

"A specific outcome that highlights these benefits is that the time to onboard new sources is reduced from weeks to days, custom Spark code reduction reached 50 to 40 percent, pipeline failures are reduced by 70 to 80 percent, and data latency is improved from hours to minutes."

"Customer service is excellent, and I would rate it between eight point five to nine out of ten."

"The most prominent feature of Upsolver is its function as an ETL tool, allowing data to be moved across platforms and different data technologies."

"This solution needs full support for real-time processing."

"We have a stability problem because when something works, it works one time. The next time, it doesn't work."

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

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

"Sometimes when we want to publish to other types of databases it's not easy to publish to those databases. For example, the Jet Database Engine. Before the SSIS supported Jet Database Engine but nowadays it doesn't support the Jet Database Engine. We connect to many databases such as Access database, SparkPros databases and the other types of databases using Jet Database Engines now and SSIS now doesn't seem to support it in our databases."

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

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

"We'd like them to develop data exploration more."

"On the stability side, I would rate it seven out of ten. Using multiple cloud providers and data engineering technologies creates complexity, and managing different plugins is not always easy, but they are working on it."

"There is room for improvement in query tuning."

"Upsolver excels in ETL and data aggregation, while ThoughtSpot is strong in natural language processing for querying datasets. Combining these tools can be very effective: Upsolver handles aggregation and ETL, and ThoughtSpot allows for natural language queries. There’s potential for highlighting these integrations in the future."

"I think that Upsolver can be improved in orchestration because it is not a full orchestration tool."

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

"If you don't want to pay a lot of money, you can go for SSIS, as its open-source version is available. When it comes to licensing, SSIS can be expensive."

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

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

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

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

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

"SSIS is a cheaper option compared to the cost of other ETL tools."

"Upsolver is affordable at approximately $225 per terabyte per year."