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."
"The solution is easy to use and developer friendly."
"The solution is stable."
"The interface is very user-friendly."
"The performance and stability are good."
"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."
"Data Flows are the main component we use. These can range from a simple source to sink ETL, to many source to many sink dataflows."
"It is easily scheduled and integrates well with SQL Server and SQL Server Agent jobs."
"I have found its most valuable features to be its package management capabilities and the flexibility it offers in designing workflows."
"Informatica Enterprise Data Lake's setup process was complex since it doesn't support a lot of real-time systems."
"We would like the solution to be expanded so that it is available for other platforms than just Microsoft."
"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."
"The creation of the measure in the DAC's model could be improved."
"We In upgrading SSIS, we encountered challenges fixing SQL Server and performance issues, including problems during a failover in our data warehouse."
"I would like to see more features in terms of the integration with Azure Data Factory."
"We have a stability problem because when something works, it works one time. The next time, it doesn't work."
"There are a lot of things that Microsoft could improve in relation to SSIS. One major problem we faced was when attempting to move some Excel files to our SQL Server. The Excel provider has a limitation that prevents importing more than 255 columns from a particular Excel file to the database. This restriction posed a significant issue for us."
"There was also not enough instructions from Microsoft in regards to this application or this technology, which can easily be improved upon."
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.