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

Denodo vs Perforce Delphix vs SSIS comparison

 

Comparison Buyer's Guide

Executive Summary

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

"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."
"Overall, I would rate Denodo a nine out of ten."
"It can support a number of data sources, and it can pull flat files, from cloud-based databases or from those on-premises. Denodo can pull from any data source and interface with the view. Then, we can publish the view."
"Denodo's best features are its performance, easy data transformation, and the job scheduler."
"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 performance and the speed to market are the most valuable features of this solution."
"In general, it's good for us to make tests so we can scout the data."
"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."
"The most valuable feature is VDB provisioning."
"Delphix interfaces are simple to use and very user friendly."
"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 can do data masking in any format. Not many solutions can do that."
"The solution's most valuable feature is data cloning."
"The most valuable feature is creating virtual databases."
"It is a stable solution."
"The most valuable feature of SSIS is that it can handle real complex transformations."
"The UI is very user-friendly."
"The most valuable aspect of this solution is that it is simple to use and it offers a flexible custom script task."
"The setup is straightforward. It's very easy to install."
"Its compatibility with Microsoft products has been very valuable to our company. It fits well within the architecture."
"Data Flows are the main component we use. These can range from a simple source to sink ETL, to many source to many sink dataflows."
"The data reader is the most valuable feature."
"Like most Microsoft products, SSIS is user-friendly and easy to use."
 

Cons

"The cache configuration is more complicated."
"The cache configuration is more complicated."
"Denodo needs better communication on how the product can be deployed for specific solutions, and there are price issues, as it's considered expensive."
"The dropdown menus feel antiquated to me, and the administrative portals need improvement."
"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."
"Data transformation must be improved."
"The support is not the best and should be improved."
"It would be good if the solution provided a much-needed cellular platform."
"This product should be extended and made to be a more comprehensive storage solution."
"The solution’s self-service portal must be more interactive and user-friendly."
"My only complaint about this solution is the price."
"Delphix could be improved with better usability and an agentless option."
"It would be good if any CI/CD and DevOps-aligned feature could be triggered through the DevOps pipeline."
"When it comes to unstructured and structured data, if Delphix can comply with the requirements for most of the structured data, it would be good, especially if it can include the data scanning part."
"Delphix is quite expensive."
"One thing I would like to see improved is the unusual error messages we receive and some slowness we have while we are updating."
"SSIS is not stable."
"The debugging could be improved because when it came to solving the errors that I've experienced in the past, I've had to look at the documentation for more information."
"I would like to see better integration with Power BI."
"I would like to see better technical documentation because many times information is missing."
"We've had issues in terms of the amount of data that is transferred when we are scheduling."
"A change in the metadata source cripples the whole ETL process, requiring each module to be manually reopened."
"We have issues with SSIS connectors while extracting data from Excel sources."
"The solution could improve on integrating with other types of data sources."
 

Pricing and Cost Advice

"Depending on the size of the client you want to work with, it can be prohibitively expensive at times."
"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."
"Denodo provides a lightweight 30-day free trial, but when we do courses on top of it, it costs $150 for each person."
"The licensing charges for this solution are payable annually."
"The cost for Denodo is in line with other similar products."
"For us, the cost has been okay. Also, there are no additional costs; it's just the standard licensing fee."
"The pricing is pretty good, and I would rate it at four out of five."
"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."
"The cost is $370K annually for the Delphix Masking Engine and Delphix Virtualization Engine."
"I would say the price is a little high but affordable for our needs."
"The product is a little bit expensive."
"The solution's pricing was reasonable and lower than one million."
"Delphix's pricing is affordable."
"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."
"It is an expensive solution."
"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."
"It would be beneficial if the solution had a less costly cloud offering."
"We have an enterprise license for this solution."
"SSIS is fairly well-priced - I would rate it at four out of five."
"The solution is economical. You don't have to worry about the pricing as long as you're installing both services on the same server."
"Our license with SSIS is annual."
"Depending on the arrangement that a certain company has with Microsoft, it may supply the permanent license that is included in the SQL server license, or it may be a time-bound license if it is a partner license or other enterprise license."
"It comes bundled with other solutions, which makes it difficult to get the price on the specific product."
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