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."Encapsulates all the components without the requirement to integrate or check compatibility."
"It is easy to map out a workflow and run trigger-based scripts without having to deploy to another server."
"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."
"The solution provides an end-to-end integrated tech stack that takes care of all utility/infrastructure topics for you."
"Palantir Foundry is a robust platform that has really strong plugin connectors and provides features for real-time integration."
"The data lineage is great."
"The virtualization tool is useful."
"The security is also excellent. It's highly granular, so the admins have a high degree of control, and there are many levels of security. That worked well. You won't have an EDC unless you put everything onto the platform because it is its own isolated thing."
"SSIS is easy to use."
"Overall, it's a good product."
"It is easily scheduled and integrates well with SQL Server and SQL Server Agent jobs."
"The performance and stability are good."
"I have used most of the standard SQL features, but the ones that stand out are the Data Flows and Bulk Import."
"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 most valuable feature of SSIS is that it can handle real complex transformations."
"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."
"It requires a lot of manual work and is very time-consuming to get to a functional point."
"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."
"If you want to create new models on specific data sets, computing that is quite costly."
"Difficult to receive data from external sources."
"The solution could use more online documentation for new users."
"Compared to other hyperscalers, Palantir Foundry is complex and not so user-intuitive."
"It would be helpful to build applications based on Azure functions or web apps in Palantir Foundry."
"Cost of this solution is quite high."
"The security could be improved, as it is more important in our context."
"At one point, we did have to purchase an add-on."
"Sometimes, there are compatibility issues with some features. From time to time, I also face issues when trying to migrate. If I misconfigure things when I use Snapshot, the migration will fail.It can take a long time to migrate huge amounts of data, so it would be nice if that could be faster."
"Generic processes should be used instead of custom code for each table."
"There is connectivity with other databases, however, this is the most significant issue that has to be addressed."
"I would also like to see full integration with our BI because then our full load of data will be available in our organization. They should incorporate an ATL process."
"We'd like them to develop data exploration more."
"Tuning using this solution requires extensive expertise to improve performance."
Palantir Foundry is ranked 11th in Data Integration with 13 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 Splunk Enterprise Security, 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.