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."
"The solution provides an end-to-end integrated tech stack that takes care of all utility/infrastructure topics for you."
"Live video sessions enhance the available documentation and allow you to ask questions directly."
"The interface is really user-friendly."
"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."
"The data lineage is great."
"The solution offers very good end-to-end capabilities."
"It is easy to map out a workflow and run trigger-based scripts without having to deploy to another server."
"The most valuable features of this solution are the fast insert and fuzzy logic matching."
"The most valuable feature of SSIS is that it can handle real complex transformations."
"The data reader is the most valuable feature."
"The solution is easy to use and developer friendly."
"The most valuable features of SSIS are that it works with the query language and it can import data from different sources."
"There are many good features in this solution including the data fields, database integration, support for SQL views, and the lookups for matching information."
"SSIS provides you with lookup and transformation functions, and you have the flexibility to write your own custom code."
"The reporting on the solution is perfect. I didn't expect to see reporting features, but they are great."
"The frontend capabilities of Palantir Foundry could be improved."
"Cost of this solution is quite high."
"The workflow could be improved."
"Difficult to receive data from external sources."
"If you want to create new models on specific data sets, computing that is quite costly."
"The solution could use more online documentation for new users."
"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."
"They do not have a data center in Europe, and we have lots of personally identifiable information in our dataset that needs to be hosted by a third-party data center like Amazon or Microsoft Azure."
"Future releases should improve the data lineage, as it currently is not good."
"Performance could be better."
"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."
"SSIS is stable, but extensive ETL data processing can have some performance issues."
"We would like the solution to be expanded so that it is available for other platforms than just Microsoft."
"The high prices attached to the product can be an area of concern where improvements are required."
"Generic processes should be used instead of custom code for each table."
"There were some issues when we tried to connect it to data storage. It was a connection issue."
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 Alteryx Designer, 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.