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."The fluid user interface (probably the most user friendly interface, when compared to its competitors)."
"It is a scalable solution."
"We only use small parts of the solution, however, the parts that we use are quite adequate."
"The Cloud Console for monitoring and troubleshooting data operations."
"Easy integration with Salesforce"
"Jitterbit provides the ability to quickly map data between files and databases."
"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."
"In our DW/BI solution, ODI is the main tool to integrate the data in a daily batch way."
"The initial setup is easy."
"All our systems can be widely integrated by ODI, such as transactional systems, our data warehouses, and B2B integration."
"ODI's most valuable features are it utilizes the database engine and is very lightweight."
"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."
"It's completely user-friendly."
"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."
"The scalability is great. It's one of the reasons we chose the solution."
"There are many good features in this solution including the data fields, database integration, support for SQL views, and the lookups for matching information."
"It is also easy to learn and user-friendly. Microsoft is also good in terms of technical support. They have built a large community all over the world."
"The scalability of SSIS is good."
"SSIS is easy to use."
"SSIS provides you with lookup and transformation functions, and you have the flexibility to write your own custom code."
"I have used most of the standard SQL features, but the ones that stand out are the Data Flows and Bulk Import."
"The data reader is the most valuable feature."
"It's something I needed for bulk imports. I'm not a big fan of it, but I haven't seen anything better."
"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."
"I know with Salesforce updating the UI like they did, it slowed it down a lot."
"Its API management capabilities need improvement."
"The initial setup can be a little bit difficult."
"You need to have some development skills or hire a Jitterbit engineer to make changes."
"Sometimes additional connectors are needed."
"I would like the ability to offer a dedicated cloud version for security."
"Reverse engineering is complicated and challenging to manage."
"ODI could improve the ease of use. There is a steep learning curve to use the solution."
"The initial setup is complex, especially if you also have to install a console."
"At present, when multiple steps are executed in parallel in the load plan and errors occur, the error handling mechanism does not function correctly."
"Technical Support could be better."
"It would be really good if Oracle considered enabling the tool to integrate with some other platforms that are deprecated simply for commercial reasons"
"Stability could be improved because some operators have issues."
"Overall the product is fine, but sometimes its reports unknown errors while we compile ETL scripts."
"When I compare Talend and SSIS, Talend provides more features. With Talend, we can handle a large volume of data. Talend is usually used to treat a large volume of data, which makes it better than SSIS on the data side. Talend also has a very good Talend Management Console to schedule the jobs and do other things. It can also be easily connected to version control tools such as GitHub or SVN. The last time I used SSIS, it was connected through TSS for the Windows Console version. I am not sure it has been improved or not. If it is not improved, Microsoft should improve it. They should change the product to provide another console."
"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."
"The creation of the measure in the DAC's model could be improved."
"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."
"Future releases should improve the data lineage, as it currently is not good."
"It would be nice if you could run SSIS on other environments besides Windows."
"The performance of this solution is not as good as other tools in the market."
"The solution should work on the GPU, graphical processing unit. There should also be piping integration available."