Palantir Gotham vs SSIS comparison

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

"The most valuable feature of the solution is performance."

"Microsoft SQL Server Integration Services is one of the most effective ETL tools available in the market."

"It is easy to set up the product."

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

"I like that this solution is very scalable, accommodating large datasets and various types of servers. It integrates with most common database servers and allows for customization through coding, including complex scripts. Compared to Alteryx Designer, SSIS offers more customization. Its data cleaning capabilities are highly accurate because we can run tests as data is loaded, ensuring it meets all requirements before reaching the final destination. The ability to write custom SQL and C# code within SSIS packages is its greatest feature."

"The return on investment has been very high; the tool has made us tremendously more efficient and saved us a significant amount of money, though I cannot put an exact figure on it."

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

"The data reader is the most valuable feature."

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

"Microsoft should offer an on-premises support warranty for those using that deployment. They seem to be withdrawing from on-premises options."

"There are a lot of things that Microsoft could improve in relation to SSIS. One major problem we faced was when attempting to move some Excel files to our SQL Server. The Excel provider has a limitation that prevents importing more than 255 columns from a particular Excel file to the database. This restriction posed a significant issue for us."

"Integration and the user interface are areas with certain shortcomings that require some improvements."

"Scalability not on the same level as with IBM Datastage."

"SSIS can improve in handling different data sources like Salesforce connectivity, Oracle Cloud's connectivity, etc. Also, handling of the different data types will be a big challenge here; so expecting improvement in these areas."

"Again it failed a lot and by a lot I mean every day. The failures were false alarms and caused many sleepless night for our company that I used to work for."

"Upgrading is usually painful and time consuming despite what MS says"

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

"People have to opt for a perpetual-based licensing model."

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

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

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

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

"Our license with SSIS is annual."

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

"SSIS' licensing is a little high, but it gives good value for money."