We performed a comparison between Informatica Enterprise Data Lake and SSIS based on real PeerSpot user reviews.
Find out what your peers are saying about Microsoft, Informatica, Oracle and others in Data Integration."The process of using the tool's scalability option is well documented."
"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."
"It's a competent product."
"The reporting on the solution is perfect. I didn't expect to see reporting features, but they are great."
"The simplicity of the solution is great. The solution also offers excellent integration."
"SSIS' most valuable feature is its reporting services."
"It has the ability to be deployed into the cloud through Data Factory, and run completely as a software as a service in the cloud."
"The initial setup was easy."
"The technical support is very good."
"Informatica Enterprise Data Lake's setup process was complex since it doesn't support a lot of real-time systems."
"It needs more integration tools, so you can connect to different sources."
"It should have other programming languages supported as well from a scripting perspective. Currently, only C# and VB.NET are supported, which limits it to .NET. It should have Java support as well."
"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."
"We purchase an add on called task factory primarily to allow bulk delete, update and upsert capability. I'd like to see this be part of the standard package."
"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."
"SSIS is stable, but extensive ETL data processing can have some performance issues."
"I would like to see better integration with Power BI."
"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."
More Informatica Enterprise Data Lake Pricing and Cost Advice →
Informatica Enterprise Data Lake is ranked 41st in Data Integration with 1 review while SSIS is ranked 2nd in Data Integration with 69 reviews. Informatica Enterprise Data Lake is rated 7.0, while SSIS is rated 7.6. The top reviewer of Informatica Enterprise Data Lake writes "A scalable tool that needs a lot of maintenance due to its unstable nature". On the other hand, the top reviewer of SSIS writes "Maintaining the solution and contacting its support team is easy". Informatica Enterprise Data Lake is most compared with Palantir Foundry, whereas SSIS is most compared with Informatica PowerCenter, Talend Open Studio, IBM InfoSphere DataStage, Oracle Data Integrator (ODI) and AWS Glue.
See our list of best 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.