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."It is very easy to build integrations and processes to pull and push data."
"Jitterbit provides the ability to quickly map data between files and databases."
"It is a scalable solution."
"The Cloud Console for monitoring and troubleshooting data operations."
"The fluid user interface (probably the most user friendly interface, when compared to its competitors)."
"We only use small parts of the solution, however, the parts that we use are quite adequate."
"Integrity, ease of use, user-friendly user interface, and errorless logs are the most valuable features."
"Easy integration with Salesforce"
"SSIS is easy to use."
"It is easy to set up the solution."
"It is easy to set up the product."
"It is easily scheduled and integrates well with SQL Server and SQL Server Agent jobs."
"The most valuable features of this solution are the fast insert and fuzzy logic matching."
"The main value of any Microsoft product is the ease of use. You can achieve more with less time. That's what's beneficial for me. With many competitors, you might need to spend more time coming up with a solution because you have to focus on taking care of the product."
"SSIS integrates well with SQL servers and Microsoft products."
"We like that this solution includes a developer edition, free of charge, to allow for training."
"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."
"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."
"Naturally produces a way to easily debug your DW data solutions."
"RED generates comprehensive documentation and regenerates it as quickly as things changes, but it also provides impact documentation."
"It has a built-in automatic scheduling environment."
"Data transformations and rollups are easy to accomplish."
"The most valuable feature is the metadata generated code."
"WhereScape RED has improved our business's ability to generate needed reporting without requiring a large team of developers to manually code all of the necessary plumbing."
"I know with Salesforce updating the UI like they did, it slowed it down a lot."
"Sometimes we experience disconnections and I have to close all Jitterbit programs."
"In the past few months, there have been some server downtimes during work hours that have affected some critical scheduled integrations."
"You need to have some development skills or hire a Jitterbit engineer to make changes."
"Sometimes additional connectors are needed."
"The initial setup can be a little bit difficult."
"I would like the ability to offer a dedicated cloud version for security."
"There were some bugs in the product. For example if you run a delete query and test, it deletes the actual data."
"I would also like to see full integration with our BI because then our full load of data will be available in our organization. They should incorporate an ATL process."
"Generic processes should be used instead of custom code for each table."
"I would like to see better integration with Power BI."
"We have a stability problem because when something works, it works one time. The next time, it doesn't work."
"The creation of the measure in the DAC's model could be improved."
"Performance could be better."
"I have a tool called ZappySys. I need that tool to cut down on the complexity of SSIS. That tool really helps with a quick turnaround. I can do things quickly, and I can do things accurately. I can get better reporting on errors."
"We're in the process of switching to Informatica, and we need to work out data lineage and data profiling and to improve the quality of our data. SSIS, however, is not that compatible with Informatica. We managed to connect it to Informatica Metadata Manager, but we don't get good lineage, so we have to redo all our ETLs using the Informatica process in order to accept the proper data lineage."
"Improve the object renaming ability (it works, but it could be more automated)."
"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."
"It could use a tool to diagnose what is missing from the environment for WhereScape to install successfully."
"Project-based searching of data objects in the data warehouse browser needs to be improved."
"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."
"Technical support isn't the best."
"They need a more robust support center. It has been a bit difficult to find solutions to problems that are out-of-the-box."
Earn 20 points