We performed a comparison between Palantir Foundry and SSIS based on real PeerSpot user reviews.
Find out in this report how the two Data Integration solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."Palantir Foundry is a robust platform that has really strong plugin connectors and provides features for real-time integration."
"Encapsulates all the components without the requirement to integrate or check compatibility."
"Great features available in one tool."
"Live video sessions enhance the available documentation and allow you to ask questions directly."
"The virtualization tool is useful."
"The ease of use is my favorite feature. We're able to build different models and projects or combine different projects to build one use case."
"It's scalable."
"The data lineage is great."
"SSIS is easy to use."
"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 technical support is very good."
"Built in reports show package execution and messages. Logging can also be customized so only what is needed is logged. There is also an excellent logging replacement called BiXpress that provides both historical and real-time monitoring which is more efficient and much more robust than the built-in logging capabilities. And none of this requires custom coding to make it useful unlike many other ETL tools."
"The solution is stable."
"The most valuable features of SSIS are that it works with the query language and it can import data from different sources."
"The most important features are it works well and provides self-service BI."
"The initial setup was easy."
"Some error messages can be very cryptic."
"The data lineage was challenging. It's hard to track data from the sources as it moves through stages. Informatica EDC can easily capture and report it because it talks to the metadata. This is generated across those various staging points."
"Cost of this solution is quite high."
"There is not a wide user base for the solution's online documentation so it is sometimes difficult to find answers."
"It would be helpful to build applications based on Azure functions or web apps in Palantir Foundry."
"Compared to other hyperscalers, Palantir Foundry is complex and not so user-intuitive."
"If you want to create new models on specific data sets, computing that is quite costly."
"It requires a lot of manual work and is very time-consuming to get to a functional point."
"Generic processes should be used instead of custom code for each table."
"Tuning using this solution requires extensive expertise to improve performance."
"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."
"I would like to see more features in terms of the integration with Azure Data Factory."
"SSIS can improve in handling different data sources like Salesforce connectivity, Oracle Cloud's connectivity, etc."
"It would be nice if you could run SSIS on other environments besides Windows."
"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."
"We would like the solution to be expanded so that it is available for other platforms than just Microsoft."
Palantir Foundry is ranked 11th in Data Integration with 14 reviews while SSIS is ranked 2nd in Data Integration with 69 reviews. Palantir Foundry is rated 7.6, while SSIS is rated 7.6. The top reviewer of Palantir Foundry writes "The data visualization is fantastic and the security is excellent". On the other hand, the top reviewer of SSIS writes "Maintaining the solution and contacting its support team is easy". Palantir Foundry is most compared with Azure Data Factory, Palantir Gotham, SAP Data Services, AWS Glue and Mule Anypoint Platform, whereas SSIS is most compared with Informatica PowerCenter, Talend Open Studio, IBM InfoSphere DataStage, Oracle Data Integrator (ODI) and AWS Glue. See our Palantir Foundry vs. SSIS report.
See our list of best Data Integration vendors and best Cloud Data Integration vendors.
We monitor all Data Integration reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.