We performed a comparison between Actian Pervasive Data Integrator [EOL], 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."There were no concerns with the stability. This product is very good from a stability perspective."
"It can integrate with more recent databases like Cassandra, Hadoop, and other more recent Big Data databases."
"The CAEM is very useful in its modularity and portability."
"The Knowledge Module approach provides an easy and reusable way to create our own integration strategies. It's easy to create these Knowledge Modules to connect to new technologies, for instance."
"The solution's initial setup is straightforward, especially compared to Mule, which our team has worked with before and found to be a bit more complex in terms of setup."
"The most valuable features of ODI are the ease of development, you can have a template, and you can onboard transfer very quickly. There's a lot of knowledge modules available that we can use. If you want to connect, for example, a Sibyl, SQL, Oracle, or different products, we don't have to develop them from scratch. They are available, but if it's not, we can go into the marketplace and see if there's a connector there. Having the connector available reduces the amount of hard work needed. We only have to put the inputs and outputs. In some of the products, we use there is already integration available for ODI, which is helpful."
"I like that Oracle Data Integrator (ODI) has a straightforward setup and offers good technical support."
"Besides loading data, we do most of our transformations in ODI."
"The product has an ELT approach."
"The interface is very user-friendly."
"It has the ability to be deployed into the cloud through Data Factory, and run completely as a software as a service in the cloud."
"It's something I needed for bulk imports. I'm not a big fan of it, but I haven't seen anything better."
"SSIS is easy to use."
"The most important features are it works well and provides self-service BI."
"It is easy to set up the solution."
"It is easy to set up the product."
"The performance is good."
"I am not sure if there are various connectors available in the recent version of Pervasive DI to support the wide range of sources available (e.g., big data, cloud, EME)."
"Reverse engineering is complicated and challenging to manage."
"It would be really good if Oracle considered enabling the tool to integrate with some other platforms that are deprecated simply for commercial reasons"
"The solution lacks some functions and features."
"Overall the product is fine, but sometimes its reports unknown errors while we compile ETL scripts."
"If there was an add-on tool to hide the performance issues and solve them for me, then I might be interested in that as it would provide me value."
"I rate it a seven out of 10 because there is room for growth because ODI is still new, in comparison to Informatica, which is a mature product."
"The interface of ODI could be improved. For example, navigating and finding functions can be difficult. For example, you have to know which step you need to go to look at where your job status is. The logical step is a bit complex compared to other tools. It's much easier to get a graphical view, but with ODI, it's graphical, plus you have to know all the other pieces that fit around it. You have to think about the logical and physical aspects."
"It needs easier security."
"The interface could use improvement, as well as the administrative tools. Jobs fail from time to time for different reasons. It's not a problem with Microsoft, or SSIS itself. The problems are external, but to find the problems and analyze them it takes too much time."
"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."
"It's difficult to refactor SSIS. It gets cumbersome to reuse the solution."
"The solution should work on the GPU, graphical processing unit. There should also be piping integration available."
"Generic processes should be used instead of custom code for each table."
"I would like to see more features in terms of the integration with Azure Data Factory."
"There were some issues when we tried to connect it to data storage. It was a connection issue."
"I would like to see better integration with Power BI."
Earn 20 points