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."It is very easy to build integrations and processes to pull and push data."
"It is a scalable solution."
"It runs like an appliance and has tremendous throughput."
"Easy integration with Salesforce"
"The Cloud Console for monitoring and troubleshooting data operations."
"Jitterbit provides the ability to quickly map data between files and databases."
"Integrity, ease of use, user-friendly user interface, and errorless logs are the most valuable features."
"Jitterbit handles the most lines of data in a .csv and loads the quickest of any data loader I have tried."
"It can integrate with more recent databases like Cassandra, Hadoop, and other more recent Big Data databases."
"Oracle provides great documentation."
"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."
"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's most valuable features are it utilizes the database engine and is very lightweight."
"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 tool improved our data integration workflow primarily due to its compatibility with Oracle. Its integration makes it very convenient for analytics. Its most valuable feature is robust extended capability. The solution's debugging capabilities are good."
"All our systems can be widely integrated by ODI, such as transactional systems, our data warehouses, and B2B integration."
"RED generates comprehensive documentation and regenerates it as quickly as things changes, but it also provides impact documentation."
"Support is absolutely excellent, efficient, and timely."
"The tool supports multiple target update methods."
"Naturally produces a way to easily debug your DW data solutions."
"I like the data vault implementations."
"Data transformations and rollups are easy to accomplish."
"It has a built-in automatic scheduling environment."
"Their support staff are very knowledgeable, courteous, and professional. I feel their support staff go above and beyond to assure their customers are satisfied."
"The initial setup can be a little bit difficult."
"I would like the ability to offer a dedicated cloud version for security."
"Looping through complex data structures can be difficult."
"I know with Salesforce updating the UI like they did, it slowed it down a lot."
"In the past few months, there have been some server downtimes during work hours that have affected some critical scheduled integrations."
"Sometimes we experience disconnections and I have to close all Jitterbit programs."
"You need to have some development skills or hire a Jitterbit engineer to make changes."
"Sometimes additional connectors are needed."
"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."
"Reverse engineering is complicated and challenging to manage."
"The initial setup is a bit complex compared to other tools."
"If you have something like Cisco on top of it, you will have endless problems."
"An area for improvement would be the lack of SQL compatibility - ODI has no ability to interact with SQL unstructured types and data types."
"We used a third party to do the implementation of ODI."
"In our company, we haven't tried consuming services from IoT in our company yet, and I would like to know if the solution will support IoT services in the next release."
"The solution can be a little more user-friendly on enterprise-level where people use it."
"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."
"They need a more robust support center. It has been a bit difficult to find solutions to problems that are out-of-the-box."
"No support for change data capture or delta detection - that must be custom coded ."
"It could use a tool to diagnose what is missing from the environment for WhereScape to install successfully."
"The ability to execute SSIS projects within WhereScape would be nice because we have a lot of packages that are too cumbersome to recreate."
"Project-based searching of data objects in the data warehouse browser needs to be improved."
"Customization could be better."
Earn 20 points