Palantir Gotham vs SSIS comparison

"This solution is seamless. From one platform, we can do just about anything."

"The workflow features have been very valuable. You can have automated workflows and all the steps are controlled. The workflow functionality of integration services is excellent."

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

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

"It has a drag and drop feature that makes it easy to use. It has a good user experience because it takes into account your most-used tools and they're lined up nicely so you can just drag and drop without looking too far. It also integrates nicely with Microsoft."

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

"Overall, it's a good product."

"The performance is better than doing it in some alternative ways. We don't have to worry about so much manual work."

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

"I think there should be less coding involved. Currently, using it involves a tremendous amount of coding."

"We'd like them to develop data exploration more."

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

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

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

"I would like to see more features in terms of the integration with Azure Data Factory."

"The debugging could be improved because when it came to solving the errors that I've experienced in the past, I've had to look at the documentation for more information."

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

"You have to write push down join & lookup SQL to the database yourself via stored procedures or use of the SQL Task to get very high performance. That said, this is a common complaint for nearly all ETL tools on the market and those that offer an alternative such as Informatica offer them at a very expensive add-on price."

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

"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 comes bundled with other solutions, which makes it difficult to get the price on the specific product."

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

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

"The solution is available at a lesser price than that of Informatica."

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