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."If the systems get migrated or upgraded, the amount of resources required are very minimal. We can change the connections and establish a new connection. It's very helpful."
"It is very comprehensive in terms of connector and transformation capabilities from both a source and target perspective."
"The reliability of the product and the way of orchestration of different services is valuable to us."
"The number of docs has been reduced drastically, which is very good."
"I like the automated scheduling feature."
"Technical support is great. It's one of the reasons we really like them. When you compare support from IBM and support from Informatica, Informatica is much better."
"The greatest feature is that it is very easy to have someone come in and jump right in. It is one of the nicest tools in terms of getting a person acquainted quickly."
"The solution is stable."
"Besides loading data, we do most of our transformations in ODI."
"In our DW/BI solution, ODI is the main tool to integrate the data in a daily batch way."
"It's completely user-friendly."
"One of the standout features of ODI is its ability to prepare everything on a vertical level and create reusable components, which adds to its value."
"It has the ability to easily load slowly changing dimensions."
"What I found most valuable in Oracle Data Integrator (ODI) is that it integrates well with almost all technologies currently being used in my company."
"The product has an ELT approach."
"ODI's most valuable features are it utilizes the database engine and is very lightweight."
"The most important features are it works well and provides self-service BI."
"The UI is very user-friendly."
"You can get data from any data source with SSIS and dump it to any outside source. It is helpful. Getting, extracting, converting, and dumping data doesn't require much effort because we can do everything in the user interface. You drag and drop, then give the required input. It's intuitive."
"With this solution, there is the potential to expand, so that you can immediately write code onto the SQL server."
"The initial setup was easy."
"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."
"We like that this solution includes a developer edition, free of charge, to allow for training."
"The product's deployment phase is easy."
"The UI is outdated and old-fashioned, at least in our current version. Also, we have experienced some stability issues with the Workflow Monitor application."
"The only problem with this product is the level of complexity with the number of levels of transformation that you have to go through."
"I found it is kind of weird that not all of the mapping changes are treated as true changes."
"I would like to see it be able to import data from NoSQL."
"They should release new versions for the solution's on-premises setup."
"I would like to see an improvement in the digital adoption."
"An issue which should be addressed is that the solution only allows us to do structured, as opposed to unstructured, data processing."
"Integrating new tools can be tricky and challenging."
"Technical Support could be better."
"We used a third party to do the implementation of ODI."
"It needs easier security."
"ODI could improve by being more user-friendly. Informatica, which is also an ETL tool, similar to ODI, but Informatica is very user-friendly, easy to use, and simple to integrate, compared to ODI. ODI has many features, put them all together, and sometimes we get confused about which ones to use, which ones not to use."
"The initial setup is complex, especially if you also have to install a console."
"If you have something like Cisco on top of it, you will have endless problems."
"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."
"Stability could be improved because some operators have issues."
"The performance of this solution is not as good as other tools in the market."
"Microsoft should offer an on-premises support warranty for those using that deployment. They seem to be withdrawing from on-premises options."
"SSIS should be made a little bit more intuitive and user-friendly because it needs an expert-level person to work on it."
"I would like to see better integration with Power BI."
"The performance of SSIS could improve when comparing it to Oracle Database."
"It's difficult to refactor SSIS. It gets cumbersome to reuse the solution."
"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."
"The solution should work on the GPU, graphical processing unit. There should also be piping integration available."