We performed a comparison between Oracle Data Integrator (ODI), SSIS, and TIBCO Scribe based on real PeerSpot user reviews.
Find out what your peers are saying about Microsoft, Informatica, Oracle and others in Data Integration."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."
"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 initial setup is easy."
"The most valuable features of ODI are the knowledge modules, such as the Loading Knowledge module and the Check Knowledge module, they are helpful. We can check for the constraints in ODI. That helps in figuring out what are the constraints that are the primary keys created in the tables. We can check them with the Check Knowledge module."
"It is an ETL tool, which does the extract, transform, and load."
"The most valuable feature is Data movement."
"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."
"It's scalable."
"The solution is easy to use and developer friendly."
"The most valuable features for our company are the flexibility and the quick turn around time in producing simple ETL solutions."
"We can connect with multiple data sources easily using an external connector in SSIS."
"The initial setup was easy."
"SSIS provides you with lookup and transformation functions, and you have the flexibility to write your own custom code."
"The performance is good."
"The initial setup of this solution is very straightforward."
"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 most valuable feature of TIBCO Scribe is the connectors available to various products."
"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."
"It would be really good if Oracle considered enabling the tool to integrate with some other platforms that are deprecated simply for commercial reasons"
"Overall the product is fine, but sometimes its reports unknown errors while we compile ETL scripts."
"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."
"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."
"The initial setup is a bit complex compared to other tools."
"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."
"I would only point out some minor bugs or glitches in the development interface (ODI studio)."
"A change in the metadata source cripples the whole ETL process, requiring each module to be manually reopened."
"The security could be improved, as it is more important in our context."
"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."
"SSIS can improve in handling different data sources like Salesforce connectivity, Oracle Cloud's connectivity, etc."
"SSIS can improve by the minimum code requirements in stored procedures and exporting data is difficult. They could make it easier, it should be as easy as it is to import data."
"The performance of this solution is not as good as other tools in the market."
"I would like to see more features in terms of the integration with Azure Data Factory."
"The performance of SSIS could improve when comparing it to Oracle Database."
"The solution should provide better documentation and scenario-based samples."