CloverDX Designer vs SSIS comparison

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

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

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

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

"It has the ability to be deployed into the cloud through Data Factory, and run completely as a software as a service in the cloud."

"It is also easy to learn and user-friendly. Microsoft is also good in terms of technical support. They have built a large community all over the world."

"The setup was easy. All Microsoft products are easy to set up."

"The most valuable thing is that it is easy to connect with Microsoft tools. In Europe, particularly in France, a lot of companies use Excel, SQL Server, and other Microsoft tools, and it is easier to connect SSIS with Microsoft tools than other products."

"I have used most of the standard SQL features, but the ones that stand out are the Data Flows and Bulk Import."

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

"We purchase an add on called task factory primarily to allow bulk delete, update and upsert capability. I'd like to see this be part of the standard package."

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

"The solution could improve on integrating with other types of data sources."

"There were some issues when we tried to connect it to data storage. It was a connection issue."

"The high prices attached to the product can be an area of concern where improvements are required."

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

"We've had issues in terms of the amount of data that is transferred when we are scheduling."

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

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

"Our license with SSIS is annual."

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

"My advice is to look at what your configuration will be because most companies have their own deals with Microsoft."

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

"We have an enterprise license for this solution."

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

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