We performed a comparison between Jitterbit Harmony , Oracle Data Integrator (ODI), and SSIS based on real PeerSpot user reviews.
Find out what your peers are saying about Microsoft, Informatica, Oracle and others in Data Integration."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."
"Jitterbit provides the ability to quickly map data between files and databases."
"The fluid user interface (probably the most user friendly interface, when compared to its competitors)."
"It is a scalable solution."
"It runs like an appliance and has tremendous throughput."
"The Cloud Console for monitoring and troubleshooting data operations."
"Easy integration with Salesforce"
"The most valuable features of ODI are the knowledge modules, such as the Loading Knowledge module and the Check Knowledge module, they are helpful. We can check for the constraints in ODI. That helps in figuring out what are the constraints that are the primary keys created in the tables. We can check them with the Check Knowledge module."
"It's completely user-friendly."
"The initial setup is easy."
"The scalability is great. It's one of the reasons we chose the solution."
"The product has an ELT approach."
"ODI is a very accessible tool, especially since the mapping functionality has been added."
"ODI's best features are customization, integration with other versioning tools, and the ability to define new knowledge modules."
"In our DW/BI solution, ODI is the main tool to integrate the data in a daily batch way."
"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."
"It is easy to set up. The deployment is also very quick."
"There are many good features in this solution including the data fields, database integration, support for SQL views, and the lookups for matching information."
"The technical support is very good."
"Like most Microsoft products, SSIS is user-friendly and easy to use."
"It has the ability to be deployed into the cloud through Data Factory, and run completely as a software as a service in the cloud."
"The workflow features have been very valuable. You can have automated workflows and all the steps are controlled. The workflow functionality of integration services is excellent."
"The simplicity of the solution is great. The solution also offers excellent integration."
"I know with Salesforce updating the UI like they did, it slowed it down a lot."
"Sometimes additional connectors are needed."
"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."
"The initial setup can be a little bit difficult."
"Looping through complex data structures can be difficult."
"Its API management capabilities need improvement."
"You need to have some development skills or hire a Jitterbit engineer to make changes."
"It needs easier security."
"It has been very good. Just recently, I've faced an issue, but I solved it somehow. While integrating with a file, I faced an issue where I wanted output files, and I had used the text field limited quotations, but at the end of the file, there was a line breakage for the last column. So, we just removed the text field because it was not working correctly for us."
"The tool should improve its pricing. It prevents the application of Oracle ODI on small and medium projects in countries like Croatia, Germany, or the US. While there are no technological obstacles to using it, the high price makes it unfeasible for projects with smaller budgets."
"The price needs to be lowered. It's too expensive."
"Technical Support could be better."
"Reverse engineering is complicated and challenging to manage."
"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."
"We used a third party to do the implementation of ODI."
"The creation of the measure in the DAC's model could be improved."
"We'd like more integration capabilities."
"It hangs a lot of the time."
"SSIS doesn't have a very good user interface, but if you can work with it, it'll provide you with almost all of the functionality."
"There are a lot of things that Microsoft could improve in relation to SSIS. One major problem we faced was when attempting to move some Excel files to our SQL Server. The Excel provider has a limitation that prevents importing more than 255 columns from a particular Excel file to the database. This restriction posed a significant issue for us."
"The performance of SSIS could improve when comparing it to Oracle Database."
"Options for scaling could be improved."
"Performance could be better."