We performed a comparison between Oracle Data Integrator (ODI), StreamSets, and WhereScape RED based on real PeerSpot user reviews.
Find out what your peers are saying about Microsoft, Informatica, Oracle and others in Data Integration."Besides loading data, we do most of our transformations in ODI."
"The CAEM is very useful in its modularity and portability."
"The product has an ELT approach."
"The initial setup is easy."
"ODI's best features are customization, integration with other versioning tools, and the ability to define new knowledge modules."
"ODI is a very accessible tool, especially since the mapping functionality has been added."
"All our systems can be widely integrated by ODI, such as transactional systems, our data warehouses, and B2B integration."
"The most valuable feature of ODI is the to use of the whole ETL to create a data lake."
"The best thing about StreamSets is its plugins, which are very useful and work well with almost every data source. It's also easy to use, especially if you're comfortable with SQL. You can customize it to do what you need. Many other tools have started to use features similar to those introduced by StreamSets, like automated workflows that are easy to set up."
"The ETL capabilities are very useful for us. We extract and transform data from multiple data sources, into a single, consistent data store, and then we put it in our systems. We typically use it to connect our Apache Kafka with data lakes. That process is smooth and saves us a lot of time in our production systems."
"One of the things I like is the data pipelines. They have a very good design. Implementing pipelines is very straightforward. It doesn't require any technical skill."
"The most valuable would be the GUI platform that I saw. I first saw it at a special session that StreamSets provided towards the end of the summer. I saw the way you set it up and how you have different processes going on with your data. The design experience seemed to be pretty straightforward to me in terms of how you drag and drop these nodes and connect them with arrows."
"The entire user interface is very simple and the simplicity of creating pipelines is something that I like very much about it. The design experience is very smooth."
"Also, the intuitive canvas for designing all the streams in the pipeline, along with the simplicity of the entire product are very big pluses for me. The software is very simple and straightforward. That is something that is needed right now."
"StreamSets’ data drift resilience has reduced the time it takes us to fix data drift breakages. For example, in our previous Hadoop scenario, when we were creating the Sqoop-based processes to move data from source to destinations, we were getting the job done. That took approximately an hour to an hour and a half when we did it with Hadoop. However, with the StreamSets, since it works on a data collector-based mechanism, it completes the same process in 15 minutes of time. Therefore, it has saved us around 45 minutes per data pipeline or table that we migrate. Thus, it reduced the data transfer, including the drift part, by 45 minutes."
"In StreamSets, everything is in one place."
"The tool supports multiple target update methods."
"The most valuable feature is the metadata generated code."
"WhereScape's deployment package is a fantastic feature. The application allows for selecting specific objects that you would like to deploy from one environment to another rather than deploying the entire database."
"Naturally produces a way to easily debug your DW data solutions."
"WhereScape RED has improved our business's ability to generate needed reporting without requiring a large team of developers to manually code all of the necessary plumbing."
"Support is absolutely excellent, efficient, and timely."
"Their support staff are very knowledgeable, courteous, and professional. I feel their support staff go above and beyond to assure their customers are satisfied."
"This is a fantastically robust DW tool that will make you at least 10 times faster in producing a DW."
"The initial setup is a bit complex compared to other tools."
"It needs easier security."
"Reverse engineering is complicated and challenging to manage."
"ODI could improve by being more user-friendly. Informatica, which is also an ETL tool, similar to ODI, but Informatica is very user-friendly, easy to use, and simple to integrate, compared to ODI. ODI has many features, put them all together, and sometimes we get confused about which ones to use, which ones not to use."
"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."
"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."
"Stability could be improved because some operators have issues."
"If you have something like Cisco on top of it, you will have endless problems."
"The software is very good overall. Areas for improvement are the error logging and the version history. I would like to see better, more detailed error logging information."
"The data collector in StreamSets has to be designed properly. For example, a simple database configuration with MySQL DB requires the MySQL Connector to be installed."
"StreamSet works great for batch processing but we are looking for something that is more real-time. We need latency in numbers below milliseconds."
"One thing that I would like to add is the ability to manually enter data. The way the solution currently works is we don't have the option to manually change the data at any point in time. Being able to do that will allow us to do everything that we want to do with our data. Sometimes, we need to manually manipulate the data to make it more accurate in case our prior bifurcation filters are not good. If we have the option to manually enter the data or make the exact iterations on the data set, that would be a good thing."
"We create pipelines or jobs in StreamSets Control Hub. It is a great feature, but if there is a way to have a folder structure or organize the pipelines and jobs in Control Hub, it would be great. I submitted a ticket for this some time back."
"Visualization and monitoring need to be improved and refined."
"StreamSets should provide a mechanism to be able to perform data quality assessment when the data is being moved from one source to the target."
"I would like to see further improvement in the UI. In addition, upgrades are not automatic and they should be automated. Currently, we have to manually upgrade versions."
"Project-based searching of data objects in the data warehouse browser needs to be improved."
"They need a more robust support center. It has been a bit difficult to find solutions to problems that are out-of-the-box."
"Technical support isn't the best."
"It could use a tool to diagnose what is missing from the environment for WhereScape to install successfully."
"The ability to execute SSIS projects within WhereScape would be nice because we have a lot of packages that are too cumbersome to recreate."
"Jobs cannot be deleted via the deployment package. When deploying from dev to QA or production, a job has to be retired. The job has to be manually removed from the target environment."
"No support for change data capture or delta detection - that must be custom coded ."
"The solution can be a little more user-friendly on enterprise-level where people use it."
Earn 20 points