Try our new research platform with insights from 80,000+ expert users

Denodo vs Perforce Delphix vs SSIS comparison

Review summaries and opinions

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Mindshare comparison

Data Virtualization
Test Data Management
Data Integration
 

Featured Reviews

Snehasish Das - PeerSpot reviewer
Enable efficient AI and ML development through a unified virtual data environment
The most valuable feature in Denodo is data virtualization. This feature focuses on creating a virtualized data environment that allows for simpler connections between data sources and systems. It significantly eases the process of developing AI and ML strategies by centralizing access to various data sources and allowing algorithms to efficiently connect to and utilize data.
Amit-Rastogi - PeerSpot reviewer
Handles large volumes of data with ease, but the self-service portal must be more user-friendly
My advice depends on an organization’s needs. If an organization has a large volume of data, Delphix is a good choice. It is robust and very efficient with large volumes of data and different kinds of databases. If someone is looking for a one-stop solution with all features and capabilities, they must consider a different tool. Overall, I rate the product a six or seven out of ten.
Sean Achim - PeerSpot reviewer
Building impactful organizational KPIs with ease and precision
Stability is rated at 10. One other important aspect I appreciate is that SSAS is included in the base installation of SQL Server. Obviously, it requires installation, but it is readily available, which is a major strength. It's all about setting it up, configuring it, and then using it. If there are additional costs associated with it or separating it as a second product, that would be a disadvantage. The area of improvement is really in education. Microsoft is trying to push everything as a Power BI solution or trying to get people to solve the problems which are solved with SSAS in another space in Power BI, or in Power Pivot, is not enough. There's not enough marketing, conversation, and support around that space. As a result, we end up with people not understanding that you need to build your models correctly, and then they try to model everything inside of Power BI, or another visualization tool, without first building the data model. That leads people to consider alternate solutions because SAP and others argue that their whole thing is in memory, and they disseminate misleading information. Additionally, what would be very helpful is local user group developments, so getting people around the table and teaching them how to use it. That is the biggest problem; it's not the technology itself. The challenge lies in Microsoft withdrawing a lot of the qualifications and watering down its emphasis, leading to a perception that this is supposed to be an elite product.

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Pros

"The most valuable feature is the performance. Denodo is very useful, especially in this huge pharma environment. I've found that older SAP solutions were very tightly coupled to each other, which resulted in data restrictions. Getting data from different sources was tough and tedious. Compared to these old solutions, Denodo is very easy to work with for the analytical team. Now that we've implemented this virtualization layer, we are capable of getting the data very smoothly. We implemented a very small unit, but the performance and integration have been very good."
"One thing that we have noticed is that when you have a BI tool, you end up building a lot of the logic in the BI tool, but as a company, every company wants to be tool agnostic because today, you could be in the Qlik Sense, and tomorrow, you may decide to go with Tableau or something else that is there. If you have put a lot of logic within the tool, transitioning or moving away from one BI tool to another tool becomes a very intensive process. By keeping the logic in Denodo, you can move to any tool."
"Denodo provides several server connectivity options with other tools such as ODPC and UDPC. It supports API integrations, allowing integration with a wide range of databases using different technologies, including NoSQL and relational databases."
"It provides useful APIs and integrates with other systems."
"Denodo is the backbone for the BU I'm working for."
"The data abstraction is the most valuable feature."
"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 most valuable feature in Denodo is data virtualization."
"Delphix interfaces are simple to use and very user friendly."
"Delphix's technical support is fairly knowledgeable."
"The most valuable aspect is the product is easy to manage, with a good dashboard. We can easily configure it on the front end and back end."
"It's really easy to install."
"Delphix's data distribution is powerful. It's easy to distribute data with this solution. The main advantage of Delphix is that it generates copies of data."
"The solution's most valuable feature is data cloning."
"The performance offered by the product, its price, and its ability to handle structured and unstructured data were good when compared to the other products in the market."
"It is a stable solution."
"It's a competent product."
"The performance and stability are good."
"It is easy to set up the product."
"We like that this solution includes a developer edition, free of charge, to allow for training."
"The most valuable features of SSIS are that it works with the query language and it can import data from different sources."
"It's already very user-friendly and has a good dashboard."
"The scalability of SSIS is good."
"It's saved time using visualization descriptions."
 

Cons

"It would be beneficial to make sure that the team that will be using Denodo has some kind of training on how to use the product at least a month beforehand, and there could even be some kind of feedback or Q&A sessions to go along with the training. If Denodo were able to provide this kind of training, it would be very helpful to users in insurance and banking companies because the staff are typically older and not always technically-minded."
"Denodo has some difficulty supporting large numbers of records."
"Denodo's training documentation could be improved by providing more material. From an administrative standpoint, I've found that only Denodo websites provide the usual tutorials. It may be because it's a bit of a restricted tool, but it results in trouble with learning. Normally, I can find help and solutions from other sources, but I haven't been able to find any for Denodo. Other that, it's fine and it performs well. I only have six months of experience, so I can't accurately suggest improvements."
"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."
"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."
"The git configuration really should be improved."
"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."
"Monitoring event logs can be improved. In the older version, there was a monitoring schedule to get event reports and properly audit the reports. In the newer version, it is not there, and we have to manually configure data and audit events."
"Delphix needs better partnerships from a customer perspective. It's how they sell it, not what they're selling."
"The solution’s self-service portal must be more interactive and user-friendly."
"Delphix could be improved with better usability and an agentless option."
"This product should be extended and made to be a more comprehensive storage solution."
"Delphix is quite expensive."
"My only complaint about this solution is the price."
"One thing I would like to see improved is the unusual error messages we receive and some slowness we have while we are updating."
"Could be improved with richer reporting capabilities."
"Improving the login procedure would make our reporting easier on monitoring our ETL processes."
"SSIS has a difficult learning curve when dealing with complex transformations."
"We In upgrading SSIS, we encountered challenges fixing SQL Server and performance issues, including problems during a failover in our data warehouse."
"I would like to see better integration with Power BI."
"The performance of SSIS could improve when comparing it to Oracle Database."
"The performance of this solution is not as good as other tools in the market."
"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."
"SSIS has room for improvement, mainly because the overall package can be buggy. It often locks up, requiring a restart, which is annoying. However, since it's free, we tolerate these performance issues. I'd like to see better debugging tools in future releases and improvements in API calls; It would be helpful if SSIS had a built-in API engine so we wouldn't have to rely solely on database connections."
 

Pricing and Cost Advice

"The licensing should be improved, as the cost per connector is quite expensive."
"I am not super familiar with the pricing, but so far, it seems good. We have been happy. We haven't seen any problems. The only time we had to pay extra was during the upgrade. We didn't upgrade at the time they told us to upgrade, and we had to pay extra to keep the service. They had stopped the support for the older version and moved to the newer version. It was not their fault. It was our fault because we didn't get on board quickly."
"Depending on the size of the client you want to work with, it can be prohibitively expensive at times."
"The licensing charges for this solution are payable annually."
"Cost wise, on a scale from one to five, with one being the cheapest and five being the most expensive, Denodo would be at three. We get all the features in a bundle."
"There is an express edition and a licensed enterprise edition."
"Denodo provides a lightweight 30-day free trial, but when we do courses on top of it, it costs $150 for each person."
"I don't know the actual cost, but it's tens of thousands of dollars per month."
"I would say the price is a little high but affordable for our needs."
"The solution's pricing was reasonable and lower than one million."
"Delphix's pricing is affordable."
"It is an expensive solution."
"I rate the product price seven to eight on a scale of one to ten, where one is the low price, and ten is the high price."
"The cost is $370K annually for the Delphix Masking Engine and Delphix Virtualization Engine."
"The product is a little bit expensive."
"SSIS' licensing is a little high, but it gives good value for money."
"Based on my experience and understanding, Talend comes out to be a little bit expensive as compared to SSIS. The average cost of having Talend with Talend Management Console is around 72K per region, which is much higher than SSIS. SSIS works very well with Microsoft technologies, and if you have Microsoft technologies, it is not really expensive to have SSIS. If you have SQL Server, SSIS is free."
"SSIS is fairly well-priced - I would rate it at four out of five."
"My advice is to look at what your configuration will be because most companies have their own deals with Microsoft."
"This solution is included with the MSSQL server package."
"All of my clients have this product included as part of their Microsoft license."
"The solution is available at a lesser price than that of Informatica."
"If you don't want to pay a lot of money, you can go for SSIS, as its open-source version is available. When it comes to licensing, SSIS can be expensive."
report
Use our free recommendation engine to learn which Data Virtualization solutions are best for your needs.
859,438 professionals have used our research since 2012.
 

Comparison Review

it_user90069 - PeerSpot reviewer
Feb 20, 2014
Informatica PowerCenter vs. Microsoft SSIS - each technology has its advantages but also have similarities
Technology has made it easier for businesses to organize and manipulate data to get a clearer picture of what’s going on with their business. Notably, ETL tools have made managing huge amounts of data significantly easier and faster, boosting many organizations’ business intelligence operations…
 

Top Industries

By visitors reading reviews
Financial Services Firm
23%
Computer Software Company
9%
Manufacturing Company
9%
Government
7%
Financial Services Firm
30%
Computer Software Company
10%
Insurance Company
9%
Manufacturing Company
7%
Financial Services Firm
19%
Computer Software Company
11%
Government
8%
Manufacturing Company
6%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

Questions from the Community

Does Denodo provide useful data virtualization education? Is it useful to attend their training?
If you are a Denodo user, it makes sense to undergo their training. Different types of professionals can benefit fro...
In experience, what might Denodo be lacking or need improvement on?
I like Denodo a lot. It offers quick and easy web service deployment within minutes. There are not any flaws that I ...
Which industries can benefit from Denodo the most?
Denodo is suitable for pretty much all sectors that deal with: Big data Cloud solutions Data governance Logical data...
What do you like most about Delphix?
The performance offered by the product, its price, and its ability to handle structured and unstructured data were go...
What is your experience regarding pricing and costs for Delphix?
The solution's pricing was reasonable and lower than one million.
What needs improvement with Delphix?
It would be good if any CI/CD and DevOps-aligned feature could be triggered through the DevOps pipeline. Right now, w...
Which is better - SSIS or Informatica PowerCenter?
SSIS PowerPack is a group of drag and drop connectors for Microsoft SQL Server Integration Services, commonly called ...
What do you like most about SSIS?
The product's deployment phase is easy.
What is your experience regarding pricing and costs for SSIS?
Utilizing SSIS involves no extra charges beyond the SQL Server license. It's an economical choice for my clients.
 

Also Known As

No data available
No data available
SQL Server Integration Services
 

Overview

 

Sample Customers

Autodesk, VHA, AAA, Sumitomo Mitsui Trust Bank, Caterpillar, European Chemical Agency, Seagate, Nationwide, Time Warner Cable, Pantex, Inditex, BNSF Railways, Vodafone, CIT Group, Jazztel, Wolters Kluwer, Telefonica, TransAlta
Alberta Blue Cross, Fastweb, SABMiller, California Insurance Guarantee Association (CIGA), Molina Healthcare, AT&T, Nike, Facebook, eBay, Comcast, IBM, HP, Intel, Avaya, BNP Paribas, P&B, Toyota, Walmart, Best Western, Directv, JPMorganChase, Verizon, Bank of the West, Fannie Mae
1. Amazon.com 2. Bank of America 3. Capital One 4. Coca-Cola 5. Dell 6. E*TRADE 7. FedEx 8. Ford Motor Company 9. Google 10. Home Depot 11. IBM 12. Intel 13. JPMorgan Chase 14. Kraft Foods 15. Lockheed Martin 16. McDonald's 17. Microsoft 18. Morgan Stanley 19. Nike 20. Oracle 21. PepsiCo 22. Procter & Gamble 23. Prudential Financial 24. RBC Capital Markets 25. SAP 26. Siemens 27. Sony 28. Toyota 29. UnitedHealth Group 30. Visa 31. Walmart 32. Wells Fargo