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."Great features available in one tool."
"The solution offers very good end-to-end capabilities."
"Encapsulates all the components without the requirement to integrate or check compatibility."
"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."
"Live video sessions enhance the available documentation and allow you to ask questions directly."
"It is easy to map out a workflow and run trigger-based scripts without having to deploy to another server."
"The virtualization tool is useful."
"Palantir Foundry is a robust platform that has really strong plugin connectors and provides features for real-time integration."
"The main value of any Microsoft product is the ease of use. You can achieve more with less time. That's what's beneficial for me. With many competitors, you might need to spend more time coming up with a solution because you have to focus on taking care of the product."
"The simplicity of the solution is great. The solution also offers excellent integration."
"The most valuable features of this solution are the fast insert and fuzzy logic matching."
"It has good data integration and good processes."
"The initial setup of this solution is very straightforward."
"SSIS integrates well with SQL servers and Microsoft products."
"The data reader is the most valuable feature."
"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."
"It would be helpful to build applications based on Azure functions or web apps in Palantir Foundry."
"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."
"There is not a wide user base for the solution's online documentation so it is sometimes difficult to find answers."
"The solution could use more online documentation for new users."
"Difficult to receive data from external sources."
"The workflow could be improved."
"Performance could be better."
"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."
"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."
"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."
"We'd like more integration capabilities."
"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."
"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."
"When I compare Talend and SSIS, Talend provides more features. With Talend, we can handle a large volume of data. Talend is usually used to treat a large volume of data, which makes it better than SSIS on the data side. Talend also has a very good Talend Management Console to schedule the jobs and do other things. It can also be easily connected to version control tools such as GitHub or SVN. The last time I used SSIS, it was connected through TSS for the Windows Console version. I am not sure it has been improved or not. If it is not improved, Microsoft should improve it. They should change the product to provide another console."
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.