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 performance is good."

"SSIS is an easy way to do data integration from various data sources. It doesn't matter whether it's a database, flat files, XML, or Web API. It can talk to the and join them all together."

"The most valuable features of this solution are the fast insert and fuzzy logic matching."

"We can connect with multiple data sources easily using an external connector in SSIS."

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

"It has good data integration and good processes."

"You can get data from any data source with SSIS and dump it to any outside source. It is helpful. Getting, extracting, converting, and dumping data doesn't require much effort because we can do everything in the user interface. You drag and drop, then give the required input. It's intuitive."

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

"Future releases should improve the data lineage, as it currently is not good."

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

"The creation of the measure in the DAC's model could be improved."

"I come from a coding background and this tool is graphically based. Sometimes I think it's cumbersome to do mapping graphically. If there was a way to provide a simple script, it would be helpful and make it easier to use."

"SSIS doesn't have a very good user interface, but if you can work with it, it'll provide you with almost all of the functionality."

"It's a legacy tool, that is nearing the end of its useful life."

"Generic processes should be used instead of custom code for each table."

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

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

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

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

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

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

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

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

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