We performed a comparison between Jitterbit Harmony , Oracle Data Integrator (ODI), and WhereScape RED based on real PeerSpot user reviews.
Find out what your peers are saying about Microsoft, Informatica, Oracle and others in Data Integration."Jitterbit handles the most lines of data in a .csv and loads the quickest of any data loader I have tried."
"We only use small parts of the solution, however, the parts that we use are quite adequate."
"It is very easy to build integrations and processes to pull and push data."
"Easy integration with Salesforce"
"The Cloud Console for monitoring and troubleshooting data operations."
"The fluid user interface (probably the most user friendly interface, when compared to its competitors)."
"Integrity, ease of use, user-friendly user interface, and errorless logs are the most valuable features."
"It is a scalable solution."
"I like that Oracle Data Integrator (ODI) has a straightforward setup and offers good technical support."
"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."
"ODI significantly improves data integration and management by allowing customization of data types from various sources like SQL Server databases."
"The most valuable feature is Data movement."
"It's completely user-friendly."
"It can integrate with more recent databases like Cassandra, Hadoop, and other more recent Big Data databases."
"It is an ETL tool, which does the extract, transform, and load."
"The CAEM is very useful in its modularity and portability."
"The tool supports multiple target update methods."
"It has a built-in automatic scheduling environment."
"WhereScape is really helpful in terms of architecture data. Everything is one of automation. Two people can do thousands of tables in one day or two. It saves a lot of time."
"This is a fantastically robust DW tool that will make you at least 10 times faster in producing a DW."
"The most valuable feature is the metadata generated code."
"Quickly develops a data warehouse for our organization with documentation and can track back/forward features."
"WhereScape's deployment package is a fantastic feature. The application allows for selecting specific objects that you would like to deploy from one environment to another rather than deploying the entire database."
"Their support staff are very knowledgeable, courteous, and professional. I feel their support staff go above and beyond to assure their customers are satisfied."
"Sometimes we experience disconnections and I have to close all Jitterbit programs."
"I know with Salesforce updating the UI like they did, it slowed it down a lot."
"The initial setup can be a little bit difficult."
"You need to have some development skills or hire a Jitterbit engineer to make changes."
"In the past few months, there have been some server downtimes during work hours that have affected some critical scheduled integrations."
"There were some bugs in the product. For example if you run a delete query and test, it deletes the actual data."
"Its API management capabilities need improvement."
"I would like the ability to offer a dedicated cloud version for security."
"ODI could improve the ease of use. There is a steep learning curve to use the solution."
"Oracle Data Integrator (ODI) is already good as a solution. Still, it needs some editing of its preview package, or if the package is upgraded, that will make Oracle Data Integrator (ODI) even better."
"Reverse engineering is complicated and challenging to manage."
"It needs easier security."
"We used a third party to do the implementation of ODI."
"Technical Support could be better."
"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."
"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."
"Project-based searching of data objects in the data warehouse browser needs to be improved."
"The solution can be a little more user-friendly on enterprise-level where people use it."
"The ability to execute SSIS projects within WhereScape would be nice because we have a lot of packages that are too cumbersome to recreate."
"Jobs cannot be deleted via the deployment package. When deploying from dev to QA or production, a job has to be retired. The job has to be manually removed from the target environment."
"Customization could be better."
"Technical support isn't the best."
"The scheduled jobs which are run by the WhereScape scheduler seem to be a strangely separate animal. Unlike all other WhereScape objects, jobs cannot be added to WhereScape projects. Also, unlike all other objects, jobs also cannot be deleted using a WhereScape deployment application."
"Improve the object renaming ability (it works, but it could be more automated)."
Earn 20 points