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 interface is very user-friendly."
"The data reader is the most valuable feature."
"The initial setup was easy."
"The most valuable feature of SSIS is that you can take data from other servers which are not MS SQL Server or Oracle."
"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."
"The most valuable thing is that it is easy to connect with Microsoft tools. In Europe, particularly in France, a lot of companies use Excel, SQL Server, and other Microsoft tools, and it is easier to connect SSIS with Microsoft tools than other products."
"The debugging capabilities are great, particularly during data flow execution. You can look into the data and see what's going on in the pipeline."
"SSIS is an easy way to do data integration from various data sources. It doesn't matter whether it's a database, flat files, XML, or Web API. It can talk to the and join them all together."
"Informatica Enterprise Data Lake's setup process was complex since it doesn't support a lot of real-time systems."
"Future releases should improve the data lineage, as it currently is not good."
"SSIS can improve in handling different data sources like Salesforce connectivity, Oracle Cloud's connectivity, etc."
"The performance of SSIS could improve when comparing it to Oracle Database."
"We have issues with SSIS connectors while extracting data from Excel sources."
"Sometimes we need to connect to AWS to get additional data sources, so we have to install some external LAN and not a regular RDBMS. We need external tools to connect. It would be great if SSIS included these tools. I'd also like some additional features for row indexing and data conversion."
"We have a stability problem because when something works, it works one time. The next time, it doesn't work."
"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."
"I have a tool called ZappySys. I need that tool to cut down on the complexity of SSIS. That tool really helps with a quick turnaround. I can do things quickly, and I can do things accurately. I can get better reporting on errors."
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.