Alteryx Designer vs SSIS comparison

"I believe in the ability to connect to multiple data sources, as well as the ease of use to transform data and output data in a variety of formats."

"Alteryx is quite easy to use, learn, and understand as a product."

"The features I found most valuable are the preparation features – the Join and the Transform."

"Alteryx Designer's user interface is great, as it is very user-friendly."

"It helps them to create customized workflows, transform data, perform calculations, and consolidate multiple data sources into a target database."

"The most valuable features are the integrated properties and integrated connectivity."

"For my daily analytics needs, the entire Alteryx Designer platform is beneficial."

"Alteryx Designer is easier to use for machine learning models. However, I am not very good at Python scripts which you will need to make the machine learning scripts."

"In SSIS, the scope is not only to handle ETL challenges, but it will allow us to do so many other tasks, such as DBA activities, scripting, calling any .exe or scripts, etc."

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

"The performance and stability are good."

"The interface is very user-friendly."

"It's a competent product."

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

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

"The reporting on the solution is perfect. I didn't expect to see reporting features, but they are great."

"Improving the key-based sign-on process and making it more user-friendly would be a benefit."

"Alteryx Designer overall should be easier to use."

"Sometimes, while getting data from a third-party product, the solution works slowly."

"It would be simpler if they provided a component where you could simply enter some parameters and see the results."

"Optimizing processing times is one area I would like to see improved in Alteryx Designer. Sometimes, the workflows take an extremely long time to run. There are days when I have had to wait two to three hours for a single process to complete. There needs to be a functionality to split the processes."

"It is challenging to view the data using Alteryx Designer."

"The only thing is sometimes it can be a bit slow."

"Alteryx could move faster to create a cloud equivalent of the desktop version of Designer."

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

"SSIS sometimes hangs, and there are some problems with servers going down after they've been patched."

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

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

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

"It would be nice if you could run SSIS on other environments besides Windows."

"We're in the process of switching to Informatica, and we need to work out data lineage and data profiling and to improve the quality of our data. SSIS, however, is not that compatible with Informatica. We managed to connect it to Informatica Metadata Manager, but we don't get good lineage, so we have to redo all our ETLs using the Informatica process in order to accept the proper data lineage."

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

"Alteryx Designer is an expensive solution."

"The licenses are expensive, making it difficult to consider acquiring additional licenses to the existing ones."

"I rate the price of Alteryx Designer a ten on a scale of one to ten, where one is low price and ten is high price."

"I rate Alteryx Designer a six out of ten for pricing."

"Alteryx is a little bit expensive compared to competing solutions."

"The product is a bit expensive, it should be looked into."

"I rate the product's pricing a two to three out of ten."

"Alteryx Designer is an expensive solution."

"Our license with SSIS is annual."

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

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

"We have an enterprise license for this solution."

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

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

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

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