We performed a comparison between Denodo, SSIS, and TIBCO Spotfire based on real PeerSpot user reviews.
Find out what your peers are saying about Amazon Web Services (AWS), MuleSoft, Matillion and others in Cloud Data Integration."Denodo's best features are its performance, easy data transformation, and the job scheduler."
"It allows a lot of traceability and you can decide what data you want to collect"
"The ability to transfer data is very valuable."
"The performance and the speed to market are the most valuable features of this solution."
"In PL/SQL, first you need to gather all the data and then start writing the file, but in Denodo you fetch the data and write the data simultaneously. So, for example, if you have 1 million or 2 million records, you don't have to wait to fetch all of the 2 million; you can keep on fetching and writing in the file simultaneously."
"The most valuable feature is Data Catalogs."
"The most valuable features of Denodo are the extraction option for adapters, and there are many things for the views, that are cached. Denodo is not storing the data, it looks first to tune the query, and these things are for the agents."
"The data abstraction is the most valuable feature."
"The performance is good."
"SSIS is an easy way to do data integration from various data sources. It doesn't matter whether it's a database, flat files, XML, or Web API. It can talk to the and join them all together."
"It's a competent product."
"The script component is very powerful, things that you cannot normally do, is feasible through C#."
"The UI is very user-friendly."
"The solution is stable."
"The reporting on the solution is perfect. I didn't expect to see reporting features, but they are great."
"It has good data integration and good processes."
"R and automation services."
"I appreciate Spotfire's range of visualization options, advanced analytics features, and seamless integration with other TIBCO products."
"From a scalability standpoint, I would say it's pretty fantastic."
"The two features that I have found most valuable are its ability to customize the dashboards when it comes to the evaluation. The second feature is its ability to handle a large amount of data, which is also something very unique about it."
"This solution allows us to integrate data from across all client departments, for effective reporting via a single dashboard."
"It allows users to quickly analyze data from a variety of sources and visualize it with powerful, interactive graphs, and charts."
"The solution is an affordable one."
"Data discovery is very simple."
"I would like to see a connectivity option with third-party apps, for example, JDBC, and ODBC drivers. Currently, we need to install it separately from the Denodo side and then connect it."
"Denodo can improve usage management-related aspects. If you deal with the mini views, it gets stuck. The performance is very slow when we go with a large number of views and high volume."
"Denodo has some difficulty supporting large numbers of records."
"There are a couple of areas that can be improved in Denodo. From a stability point of view, sometimes we see issues in the data management functionality. This only happens now and then, however, and usually takes place when we add in our own customization."
"The integration could use improvement, it's a lot of non-speed line processes that we have discovered, in the country. The configurations could use a lot more improvement."
"I would like it if we could pull the data model or export the data model because Denodo has, based on how you build, something called associations. The data model gets very confusing when you go look at it. It depends on how you define it, but it's really huge. I wish there was a way to export it into Visio. It could be that they already have a way to do it, and I don't know, but it would be much easier for the architects and even for the developers to look at it than scrunching it into the screen and expanding every small portion of it. If there was an easy way to export the Denodo model into another modeling tool and view it, it would be great."
"There have been some issues when you are at a table. Currently, Denodo exports data sets for a tabular model. When you are finished modeling your database or data warehouse they export a link to be used in Tableau. They should support other tools like Power BI."
"Sometimes, Windows-related functions do not work properly in Denodo. The analytic functions in SQL do not work properly."
"The solution could improve by having quicker release updates."
"Sometimes, there are compatibility issues with some features. From time to time, I also face issues when trying to migrate. If I misconfigure things when I use Snapshot, the migration will fail.It can take a long time to migrate huge amounts of data, so it would be nice if that could be faster."
"The security could be improved, as it is more important in our context."
"SSIS should be made a little bit more intuitive and user-friendly because it needs an expert-level person to work on it."
"The solution should work on the GPU, graphical processing unit. There should also be piping integration available."
"I would like to see more standard components out of the box, such as SFTP, and Data Compression components."
"At one point, we did have to purchase an add-on."
"There were some issues when we tried to connect it to data storage. It was a connection issue."
"I would like more easy-to-implement analytical algorithms. At the moment they include things like forecasts and regressions. They need to add a lot more of these types of things to the product because not everyone is a data scientist."
"We would like an easier way to get the product to the cloud. Right now, we have the on-premise version, and we would like to find a way to make it easier to migrate it over to the cloud."
"When you do the data loading, it is slow."
"We encountered difficulties connecting the special data sets, as the post data set did not contain any shared columns, making it difficult to establish a connection between the data sets."
"We would like to see some development in the visualization aspect of this solution, as they can currently only be configured in the cloud, which limits us to one endpoint. It would be helpful if this could be integrated with other tools."
"The way TIBCO Spotfire is designed, in my opinion, is the reason why it lags a bit, especially compared to other BI tools like Qlik."
"The design of the UI could be improved."
"The initial setup can be difficult."