CloverDX Designer vs SSIS comparison

"Its simplicity and the way it handles graphs are the most valuable features."

"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 product's deployment phase is easy."

"The scalability of SSIS is good."

"SSIS is easy to use."

"The setup is straightforward. It's very easy to install."

"SSIS provides you with lookup and transformation functions, and you have the flexibility to write your own custom code."

"The most valuable aspect of this solution is that it is simple to use and it offers a flexible custom script task."

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

"If I could give any advice to the guys who are developing it, I would suggest them to really look at the enterprise features, such as being able to log what's going on, being able to capture the current state of processing, and being able to recover from error situations. So, there should be a focus on logging, recoverability, and monitoring. We should be able to monitor what's going on, and in case of any issues, we should be able to recover and restart processing and other things. For scalability and performance, I would probably suggest the Pushdown feature so that you can do the transformation directly on the data source. You do not need to do that calculation within the ETL server. For this, you should be aware of the type of data because each database or kind of storage, such as Hadoop, has its own ANSI standard or language, such as SQL. Microsoft, Oracle, and IBM have their own language. Based on the feedback that I have got, its initial setup takes some time. It could perhaps be simpler."

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

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

"SSIS can improve in handling different data sources like Salesforce connectivity, Oracle Cloud's connectivity, etc."

"Sometimes we need to connect to AWS to get additional data sources, so we have to install some external LAN and not a regular RDBMS. We need external tools to connect. It would be great if SSIS included these tools. I'd also like some additional features for row indexing and data conversion."

"There are a lot of things that Microsoft could improve in relation to SSIS. One major problem we faced was when attempting to move some Excel files to our SQL Server. The Excel provider has a limitation that prevents importing more than 255 columns from a particular Excel file to the database. This restriction posed a significant issue for us."

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

"The interface could use improvement, as well as the administrative tools. Jobs fail from time to time for different reasons. It's not a problem with Microsoft, or SSIS itself. The problems are external, but to find the problems and analyze them it takes too much time."

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

"Its price and value for money would be okay for our purpose if there were some additional features."

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

"This solution has provided an inexpensive tool, and it is easy to find experienced developers."

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

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

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

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

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

"Depending on the arrangement that a certain company has with Microsoft, it may supply the permanent license that is included in the SQL server license, or it may be a time-bound license if it is a partner license or other enterprise license."