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."
"We like that this solution includes a developer edition, free of charge, to allow for training."
"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 solution is stable."
"The most valuables features are the relatively short learning curve, and the automation capabilities provided through the BIML add-in for SSDT."
"SSIS' best feature is SFTP connectivity."
"The initial setup of this solution is very straightforward."
"The scalability of SSIS is good."
"The simplicity of the solution is great. The solution also offers excellent integration."
"Informatica Enterprise Data Lake's setup process was complex since it doesn't support a lot of real-time systems."
"The performance of SSIS could improve when comparing it to Oracle Database."
"Involving a data lake or data engineering aspects would be useful. While it is there, we need more features included."
"SSIS is cumbersome despite its drag-and-drop functionality. For example, let's say I have 50 tables with 30 columns. You need to set a data type for each column and table. That's around 1,500 objects. It gets unwieldy adding validation for every column. Previously, SSIS automatically detected the data type, but I think they removed this feature. It would automatically detect if it's an integer, primary key, or foreign key column. You had fewer problems building the model."
"Microsoft should offer an on-premises support warranty for those using that deployment. They seem to be withdrawing from on-premises options."
"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."
"There is connectivity with other databases, however, this is the most significant issue that has to be addressed."
"It needs more integration tools, so you can connect to different sources."
"Options for scaling could be improved."
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.
