We performed a comparison between Oracle Data Integrator (ODI), SSIS, and Workato based on real PeerSpot user reviews.
Find out what your peers are saying about Microsoft, Informatica, Oracle and others in Data Integration."ODI's most valuable features are it utilizes the database engine and is very lightweight."
"Oracle provides great documentation."
"The most valuable feature that we use is the Knowledge Modules."
"In our DW/BI solution, ODI is the main tool to integrate the data in a daily batch way."
"The product has an ELT approach."
"It allows us to use many languages to develop and to integrate practically all the technologies of the Oracle suite as well as those from non-Oracle vendors."
"The most valuable feature is Data movement."
"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."
"The solution is easy to use and developer friendly."
"Like most Microsoft products, SSIS is user-friendly and easy to use."
"The most valuable aspect of this solution is that it is simple to use and it offers a flexible custom script task."
"Built in reports show package execution and messages. Logging can also be customized so only what is needed is logged. There is also an excellent logging replacement called BiXpress that provides both historical and real-time monitoring which is more efficient and much more robust than the built-in logging capabilities. And none of this requires custom coding to make it useful unlike many other ETL tools."
"The interface is very user-friendly."
"It is easy to set up. The deployment is also very quick."
"The most valuable feature of SSIS is its ease of use. It is easier to use than other applications."
"It's already very user-friendly and has a good dashboard."
"It is easier to use than other technical open-source technologies."
"Their automation and workflows are very strong, and you can build the workflows very easily and quickly."
"The most valuable features are easy integration, quick tab to develop, quick tab to market, and interactive integration platform."
"Stability-wise, I rate the solution a ten out of ten."
"It's easy to understand, makes flows and is efficient."
"It is very easy to use. It takes complex workloads away, and it provides very smooth integration. It has got a lot of out-of-the-box connectors. It has got a lot of out-of-the-box APIs, which makes it really easy to integrate with applications for different use cases, whether it is in finance, HR, or customer operations. It is by far our favorite integration product."
"Workato is low code, intuitive, and easy to use."
"The solution lacks some functions and features."
"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."
"The price needs to be lowered. It's too expensive."
"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."
"The resource management aspect of the solution could be improved."
"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."
"We used a third party to do the implementation of ODI."
"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."
"We would like the solution to be expanded so that it is available for other platforms than just Microsoft."
"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."
"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."
"The creation of the measure in the DAC's model could be improved."
"We've had issues in terms of the amount of data that is transferred when we are scheduling."
"The performance of this solution is not as good as other tools in the market."
"I would like to see more standard components out of the box, such as SFTP, and Data Compression components."
"The security could be improved, as it is more important in our context."
"The management dashboard in the solution is an area with shortcomings that needs improvement."
"It is tedious to make a tailor-fit function."
"I would like to see the dashboarding and reporting processes improved."
"Workato's Extract, transform, and load (ETL) and extract, load, and transform (ELT) are not very strong and could be improved for very complex transformations."
"A limitation is that their cloud presence is only in North America and Europe."
"The only minor drawback would be if there was a UI at the front of it, for apps and for a portal as well, it would make it really easy. It would be really useful if there were more apps capabilities."
"From the deployment point of view, our customers encounter platform downtime where it does not serve the actual request on the systems."