We performed a comparison between Jitterbit Harmony and SSIS 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."
"Integrity, ease of use, user-friendly user interface, and errorless logs are the most valuable features."
"Easy integration with Salesforce"
"We only use small parts of the solution, however, the parts that we use are quite adequate."
"The fluid user interface (probably the most user friendly interface, when compared to its competitors)."
"Jitterbit handles the most lines of data in a .csv and loads the quickest of any data loader I have tried."
"Jitterbit provides the ability to quickly map data between files and databases."
"It runs like an appliance and has tremendous throughput."
"It has good data integration and good processes."
"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."
"The most valuable features for our company are the flexibility and the quick turn around time in producing simple ETL solutions."
"The most valuable feature of SSIS is its ease of use. It is easier to use than other applications."
"The simplicity of the solution is great. The solution also offers excellent integration."
"The debugging capabilities are great, particularly during data flow execution. You can look into the data and see what's going on in the pipeline."
"You can get data from any data source with SSIS and dump it to any outside source. It is helpful. Getting, extracting, converting, and dumping data doesn't require much effort because we can do everything in the user interface. You drag and drop, then give the required input. It's intuitive."
"The performance is better than doing it in some alternative ways. We don't have to worry about so much manual work."
"In the past few months, there have been some server downtimes during work hours that have affected some critical scheduled integrations."
"I would like the ability to offer a dedicated cloud version for security."
"I know with Salesforce updating the UI like they did, it slowed it down a lot."
"You need to have some development skills or hire a Jitterbit engineer to make changes."
"Sometimes we experience disconnections and I have to close all Jitterbit programs."
"Looping through complex data structures can be difficult."
"Its API management capabilities need improvement."
"The initial setup can be a little bit difficult."
"A change in the metadata source cripples the whole ETL process, requiring each module to be manually reopened."
"SSIS is cumbersome despite its drag-and-drop functionality. For example, let's say I have 50 tables with 30 columns. You need to set a data type for each column and table. That's around 1,500 objects. It gets unwieldy adding validation for every column. Previously, SSIS automatically detected the data type, but I think they removed this feature. It would automatically detect if it's an integer, primary key, or foreign key column. You had fewer problems building the model."
"Sometimes, there are compatibility issues with some features. From time to time, I also face issues when trying to migrate. If I misconfigure things when I use Snapshot, the migration will fail.It can take a long time to migrate huge amounts of data, so it would be nice if that could be faster."
"SSIS should be made a little bit more intuitive and user-friendly because it needs an expert-level person to work on it."
"Performance could be better."
"Video training would be a helpful addition."
"It should have other programming languages supported as well from a scripting perspective. Currently, only C# and VB.NET are supported, which limits it to .NET. It should have Java support as well."
"We'd like more integration capabilities."
Jitterbit Harmony is ranked 35th in Data Integration with 13 reviews while SSIS is ranked 2nd in Data Integration with 69 reviews. Jitterbit Harmony is rated 8.6, while SSIS is rated 7.6. The top reviewer of Jitterbit Harmony writes "An easy-to-setup solution with good stability ". On the other hand, the top reviewer of SSIS writes "Maintaining the solution and contacting its support team is easy". Jitterbit Harmony is most compared with MuleSoft Composer, Azure Data Factory, Microsoft Azure Logic Apps, Mule Anypoint Platform and SnapLogic, whereas SSIS is most compared with Informatica PowerCenter, Talend Open Studio, IBM InfoSphere DataStage, Oracle Data Integrator (ODI) and AWS Glue.
See our list of best Data Integration vendors and best Cloud Data Integration vendors.
We monitor all Data Integration reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.