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."
"The scalability is great. It's one of the reasons we chose the solution."
"ODI's most valuable features are it utilizes the database engine and is very lightweight."
"Integration with all systems is easy with Oracle Data Integrator, and it is easy to use. I have not used any other product, but with Oracle Data Integrator, we can easily connect to an ERP system, an SAP system, or a cloud application."
"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."
"In our DW/BI solution, ODI is the main tool to integrate the data in a daily batch way."
"The initial setup is easy."
"The installation of the client ODI Studio is easy."
"All ETL code is stored in repositories in underlying database schemas. The number of users can access and work on the same solution using a client tool. So distributed teams can work on this tool in an efficient manner."
"The performance is good."
"The most valuable feature of SSIS is its ease of use. It is easier to use than other applications."
"The UI is very user-friendly."
"The workflow features have been very valuable. You can have automated workflows and all the steps are controlled. The workflow functionality of integration services is excellent."
"We like that this solution includes a developer edition, free of charge, to allow for training."
"With this solution, there is the potential to expand, so that you can immediately write code onto the SQL server."
"I have used most of the standard SQL features, but the ones that stand out are the Data Flows and Bulk Import."
"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."
"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)."
"Technical Support could be better."
"Stability could be improved because some operators have issues."
"It needs easier security."
"An area for improvement in Oracle Data Integrator (ODI) is real-time integration. Currently, my company has a workaround to implement real-time integration, an area on which Oracle must focus more. Real-time integration should be easier in Oracle Data Integrator (ODI). Another area for improvement in Oracle Data Integrator (ODI) is integration with more publishers and subscribers rather than just database integrations."
"We used a third party to do the implementation of ODI."
"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 initial setup is a bit complex compared to other tools."
"Overall the product is fine, but sometimes its reports unknown errors while we compile ETL scripts."
"We have a stability problem because when something works, it works one time. The next time, it doesn't work."
"Future releases should improve the data lineage, as it currently is not good."
"Tuning using this solution requires extensive expertise to improve performance."
"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."
"Options for scaling could be improved."
"There are a lot of things that Microsoft could improve in relation to SSIS. One major problem we faced was when attempting to move some Excel files to our SQL Server. The Excel provider has a limitation that prevents importing more than 255 columns from a particular Excel file to the database. This restriction posed a significant issue for us."
"We'd like more integration capabilities."
Earn 20 points