We performed a comparison between Oracle Data Integrator (ODI) and SnapLogic based on real PeerSpot user reviews.
Find out in this report how the two Data Integration solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."The installation of the client ODI Studio is easy."
"Oracle provides great documentation."
"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 is an ETL tool, which does the extract, transform, and load."
"ODI significantly improves data integration and management by allowing customization of data types from various sources like SQL Server databases."
"It can integrate with more recent databases like Cassandra, Hadoop, and other more recent Big Data databases."
"ODI's best features are customization, integration with other versioning tools, and the ability to define new knowledge modules."
"The initial setup is easy."
"The API architecture makes it easy for orchestration."
"SnapLogic is more user-friendly than Boomi in terms of debugging. You can move the mouse to a place, and it will record and show the data easily."
"I found SnapLogic valuable and what I found most valuable about it was its ETL feature. I also found its automation feature valuable. It can be used for automating manual activities. It can be used as a middleware for certain transactional data processing and minimal datasets and ETL activities."
"The connection with SOAP is the best feature."
"You can use other languages, such as Python, and easily connect to other systems."
"The solutions ability to connect "snaps" or components to the graphic user interface is very intuitive, prevents errors, and makes implementations easy."
"SnapLogic is an IPA tool that leverages a low code environment to connect to multiple sources, extract data, and store it in Azure data lake."
"The feature I found most valuable in SnapLogic is low-code development. Low-code development has been very useful for simple processes, which is required for business users such as extracting details from a file or getting things reported by calling your web service. Calling your web service also becomes easier with SnapLogic because of the snaps available, so if you have the documentation, you can call an API. You don't have to write all those clients to call an API, so that is another feature I found very easy in SnapLogic. Configuring and managing all the file systems also become very handy with the solution."
"The resource management aspect of the solution could be improved."
"The interface of ODI could be improved. For example, navigating and finding functions can be difficult. For example, you have to know which step you need to go to look at where your job status is. The logical step is a bit complex compared to other tools. It's much easier to get a graphical view, but with ODI, it's graphical, plus you have to know all the other pieces that fit around it. You have to think about the logical and physical aspects."
"The solution lacks some functions and features."
"The stability of the software could be improved. Sometimes, the software just crashes. "
"It lacks a suite of tools suitable for fully processing data and moving it into decision support warehouses."
"We used a third party to do the implementation of ODI."
"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."
"It would be really good if Oracle considered enabling the tool to integrate with some other platforms that are deprecated simply for commercial reasons"
"The solution isn't ideal for complex processing or logic. We use another solution for that."
"One area for improvement in SnapLogic is the transparency in the flow of data. It needs to have more transparency. Right now, users only have a preview option at the end of any job flow, so at the end of any Snap Pack, there is a data preview option that lets you review the data and see how it's moving. What would make the solution better is more debugging and more access to change data from the preview panel or more functionality in terms of the preview option."
"One of the areas for improvement in SnapLogic is that the connectors for some of the applications should be more available in terms of testing in the dev environment. Another area for improvement is that the logging should be standardized, for example, the integration with an ELK stack should be required out-of-the-box, so you can ship the log and have it in the ELK stack. There should be integration with ELK stack for the log shipping."
"There is room for improvement with APM management and how task execution looks."
"I am looking for more scheduling options. When it comes to scheduling, there are different tools in the market."
"It needs some more snaps. I would like to see some of the features be changed in some of the snaps."
"SnapLogic doesn't provide any on-premises software, so users have only cloud-based software to use."
"SnapLogic sits somewhere in the middle. It doesn’t offer enough easy canned integrations for its users like some of the easier to use integration apps."
Oracle Data Integrator (ODI) is ranked 4th in Data Integration with 67 reviews while SnapLogic is ranked 14th in Data Integration with 20 reviews. Oracle Data Integrator (ODI) is rated 8.2, while SnapLogic is rated 8.0. The top reviewer of Oracle Data Integrator (ODI) writes "Straightforward to implement, scalable, and has good stability and documentation, but technical support could still be improved". On the other hand, the top reviewer of SnapLogic writes "Easy to set up, easy to use, and is low-code". Oracle Data Integrator (ODI) is most compared with Oracle Integration Cloud Service, SSIS, Informatica PowerCenter, Azure Data Factory and Oracle GoldenGate, whereas SnapLogic is most compared with AWS Glue, Azure Data Factory, IBM InfoSphere DataStage, Informatica Cloud Data Integration and SSIS. See our Oracle Data Integrator (ODI) vs. SnapLogic report.
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.