CloverDX Designer vs SSIS comparison

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

"Overall, it's a good product."

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

"There are many good features in this solution including the data fields, database integration, support for SQL views, and the lookups for matching information."

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

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

"We like that this solution includes a developer edition, free of charge, to allow for training."

"The initial setup of this solution is very straightforward."

"Like most Microsoft products, SSIS is user-friendly and easy to use."

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

"It hangs a lot of the time."

"There's no support for it at all. If you haven't undergone the qualifications, you wouldn't even know you should phone someone."

"There was also not enough instructions from Microsoft in regards to this application or this technology, which can easily be improved upon."

"Microsoft's technical support has decreased in quality over the last few years, becoming less responsive and tending to pass problems on instead of solving them."

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

"When I compare Talend and SSIS, Talend provides more features. With Talend, we can handle a large volume of data. Talend is usually used to treat a large volume of data, which makes it better than SSIS on the data side. Talend also has a very good Talend Management Console to schedule the jobs and do other things. It can also be easily connected to version control tools such as GitHub or SVN. The last time I used SSIS, it was connected through TSS for the Windows Console version. I am not sure it has been improved or not. If it is not improved, Microsoft should improve it. They should change the product to provide another console."

"SSIS can improve by the minimum code requirements in stored procedures and exporting data is difficult. They could make it easier, it should be as easy as it is to import data."

"SSIS should be made a little bit more intuitive and user-friendly because it needs an expert-level person to work on it."

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

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

"The solution comes free of cost."

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

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

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

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

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

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