We performed a comparison between JumpMind SymmetricDS, Oracle Data Integrator (ODI), and Talend Open Studio based on real PeerSpot user reviews.
Find out what your peers are saying about NetApp, Fivetran, Dell Technologies and others in Data Replication."It is fully featured. It has allowed me to do everything I wanted to do."
"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."
"The product has an ELT approach."
"The most valuable features of ODI are the ease of development, you can have a template, and you can onboard transfer very quickly. There's a lot of knowledge modules available that we can use. If you want to connect, for example, a Sibyl, SQL, Oracle, or different products, we don't have to develop them from scratch. They are available, but if it's not, we can go into the marketplace and see if there's a connector there. Having the connector available reduces the amount of hard work needed. We only have to put the inputs and outputs. In some of the products, we use there is already integration available for ODI, which is helpful."
"One of the standout features of ODI is its ability to prepare everything on a vertical level and create reusable components, which adds to its value."
"I do not have to maintain a separate ETL instance. I can change the SQL when something is not performing correctly."
"ODI's most valuable features are it utilizes the database engine and is very lightweight."
"I like that Oracle Data Integrator (ODI) has a straightforward setup and offers good technical support."
"Talend Open Studio's installation process is easy. One just needs to install Java before installing the product"
"The main differentiator that I have seen between Talend and other data integration tools is the ability to view the data pipeline in the form of a program."
"Talend Studio has the ability to use it to ensure data quality."
"Open Studio's best features are that it's user-friendly, even for beginners, and very easy to implement."
"It has got so many connectors. It is intuitive and easy to use."
"Talend lets you do everything — mapping, workflow, and orchestration — in a single place."
"The most valuable features are the ETL tools."
"Talend can connect to multiple data sources, including relational data sources, ERP, CRM, and others."
"The user interface could improve. We are looking at some cloud-based databases, and I don't think they support that."
"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 performance of the user interface is in need of improvement."
"There are certain things where it can be improved. Initial solution setup seems a bit complex at the start, it should be improved because it becomes bit tough for a novice to get started on this. Sometimes error description is not helpful to understand the problem it gives some generic type of errors which are at times not that helpful to understand the underlying root cause of the issue."
"I would only point out some minor bugs or glitches in the development interface (ODI studio)."
"An area for improvement would be the lack of SQL compatibility - ODI has no ability to interact with SQL unstructured types and data types."
"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 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 needs more integrations."
"It needs better installation configuration for other databases. Although the installation allows you to select another database, this doesn't mean that all connection points in the application point to the database selected. You actually need to do a search through the entire install to locate the configuration settings and change them."
"It is not as visually appealing as some of the other tools."
"The pricing could be lower. They should work to make it more affordable."
"We need more components to be more efficient. We use a lot of components, such as Salesforce, and it's not easy to use. There's are minor bugs and it's not easy to use some of the features."
"Technical support and customer service need to be improved."
"The technical support and documentation need a lot of work to come up to standard."
"It doesn't have the ability to keep the repository of the source code (visual pipeline). It can be integrated with Git."