We performed a comparison between Informatica PowerCenter, Oracle Data Integrator (ODI), and SSIS based on real PeerSpot user reviews.
Find out what your peers are saying about Microsoft, Informatica, Oracle and others in Data Integration."It has good standard features for ETL development."
"The ability to scale through partitions helped us to improve the performance."
"It has a Data Catalog that uses the Model repository."
"We use Informatica PowerCenter to transfer the transitional database to and from the data warehouse. This is very efficient as it enables us to quickly find our data reports and the data, so we can build AI models."
"The technical support for Informatica PowerCenter is good."
"Has a good visual tool for data mapping."
"It is an excellent ETL tool."
"Once you figure it out, it is a powerful and simple ETL tool. Its stability has been very satisfactory."
"ODI is a very accessible tool, especially since the mapping functionality has been added."
"It can integrate with more recent databases like Cassandra, Hadoop, and other more recent Big Data databases."
"The tool improved our data integration workflow primarily due to its compatibility with Oracle. Its integration makes it very convenient for analytics. Its most valuable feature is robust extended capability. The solution's debugging capabilities are good."
"It has the ability to easily load slowly changing dimensions."
"Besides loading data, we do most of our transformations in ODI."
"Most of the functions are very straightforward, like the data model, mapping, package, and load plan. Thus, a new user could get started very fast."
"The most valuable feature that we use is the Knowledge Modules."
"The CAEM is very useful in its modularity and portability."
"Overall, it's a good product."
"The performance is good."
"The initial setup was easy."
"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 product's deployment phase is easy."
"In SSIS, the scope is not only to handle ETL challenges, but it will allow us to do so many other tasks, such as DBA activities, scripting, calling any .exe or scripts, etc."
"This solution is easy to implement, has a wide variety of connectors, has support for Visual Basic, and supports the C language."
"SSIS integrates well with SQL servers and Microsoft products."
"Support could be better."
"While Informatica is great for data-integration, it does not have any analytics features. Thus, organizations have to always look for another product for their BI needs."
"While on-premises is a better product, we really need to move to the cloud and need the cloud to be as robust as this product."
"We had to take on a large volume of data from the legacy Sybase system. This was taking a very long time, i.e., more than a day. We were trying to improve it with partitions to gpload, but we were told that we can't go more than four partitions."
"The multiple interfaces in Informatica PowerCenter are not great for the user experience. Because of this, I think it can cause confusion for any beginner developer."
"This product is going to decommission in the next couple of years."
"Unstructured data handling is an important area with a shortcoming that needs improvement in the solution."
"I would like to see improvements made to the custom transformations. It should be more open for users that want to write their own code and use cases."
"There are certain things where it can be improved. Initial solution setup seems a bit complex at the start, it should be improved because it becomes bit tough for a novice to get started on this. Sometimes error description is not helpful to understand the problem it gives some generic type of errors which are at times not that helpful to understand the underlying root cause of the issue."
"In our company, we haven't tried consuming services from IoT in our company yet, and I would like to know if the solution will support IoT services in the next release."
"It lacks a suite of tools suitable for fully processing data and moving it into decision support warehouses."
"The performance of the user interface is in need of improvement."
"The stability of the software could be improved. Sometimes, the software just crashes. "
"At present, when multiple steps are executed in parallel in the load plan and errors occur, the error handling mechanism does not function correctly."
"It has been very good. Just recently, I've faced an issue, but I solved it somehow. While integrating with a file, I faced an issue where I wanted output files, and I had used the text field limited quotations, but at the end of the file, there was a line breakage for the last column. So, we just removed the text field because it was not working correctly for us."
"Overall the product is fine, but sometimes its reports unknown errors while we compile ETL scripts."
"The solution could improve by having quicker release updates."
"We'd like more integration capabilities."
"Performance could be better."
"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."
"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."
"Generic processes should be used instead of custom code for each table."
"This solution needs full support for real-time processing."
"There was also not enough instructions from Microsoft in regards to this application or this technology, which can easily be improved upon."