We performed a comparison between Jitterbit Harmony , SSIS, 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."
"The fluid user interface (probably the most user friendly interface, when compared to its competitors)."
"It is very easy to build integrations and processes to pull and push data."
"It runs like an appliance and has tremendous throughput."
"Integrity, ease of use, user-friendly user interface, and errorless logs are the most valuable features."
"The Cloud Console for monitoring and troubleshooting data operations."
"We only use small parts of the solution, however, the parts that we use are quite adequate."
"It is a scalable solution."
"The solution is stable."
"We like that this solution includes a developer edition, free of charge, to allow for training."
"The most valuables features are the relatively short learning curve, and the automation capabilities provided through the BIML add-in for SSDT."
"Data Flows are the main component we use. These can range from a simple source to sink ETL, to many source to many sink dataflows."
"It is easy to set up the solution."
"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."
"The technical support is very good."
"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."
"The most valuable feature is the metadata generated code."
"Naturally produces a way to easily debug your DW data solutions."
"The tool supports multiple target update methods."
"RED has provided us the ability to integrate, stage, and transform data from diverse sources into an enterprise-grade data warehouse which meets the needs of my organization, but it also enables us to easily and quickly make ETL or DW changes."
"Their support staff are very knowledgeable, courteous, and professional. I feel their support staff go above and beyond to assure their customers are satisfied."
"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."
"Quickly develops a data warehouse for our organization with documentation and can track back/forward features."
"Looping through complex data structures can be difficult."
"I would like the ability to offer a dedicated cloud version for security."
"Sometimes we experience disconnections and I have to close all Jitterbit programs."
"Its API management capabilities need improvement."
"You need to have some development skills or hire a Jitterbit engineer to make changes."
"Sometimes additional connectors are needed."
"I know with Salesforce updating the UI like they did, it slowed it down a lot."
"There were some bugs in the product. For example if you run a delete query and test, it deletes the actual data."
"We'd like them to develop data exploration more."
"I come from a coding background and this tool is graphically based. Sometimes I think it's cumbersome to do mapping graphically. If there was a way to provide a simple script, it would be helpful and make it easier to use."
"Improvement as per customer requirements."
"We'd like more integration capabilities."
"The debugging could be improved because when it came to solving the errors that I've experienced in the past, I've had to look at the documentation for more information."
"Performance could be better."
"I would like to see better integration with Power BI."
"SSIS should be made a little bit more intuitive and user-friendly because it needs an expert-level person to work on it."
"No support for change data capture or delta detection - that must be custom coded ."
"Customization could be better."
"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."
"They need a more robust support center. It has been a bit difficult to find solutions to problems that are out-of-the-box."
"It could use a tool to diagnose what is missing from the environment for WhereScape to install successfully."
"The solution can be a little more user-friendly on enterprise-level where people use it."
"Project-based searching of data objects in the data warehouse browser needs to be improved."
"Technical support isn't the best."
Earn 20 points