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

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:
 

Categories and Ranking

Perforce Delphix
Average Rating
8.0
Reviews Sentiment
7.5
Number of Reviews
16
Ranking in other categories
Test Data Management (1st), Copy Data Management (1st), Data Masking (1st)
SSIS
Average Rating
7.6
Reviews Sentiment
6.8
Number of Reviews
73
Ranking in other categories
Data Integration (4th)
 

Mindshare comparison

Perforce Delphix and SSIS aren’t in the same category and serve different purposes. Perforce Delphix is designed for Test Data Management and holds a mindshare of 28.7%, down 29.6% compared to last year.
SSIS, on the other hand, focuses on Data Integration, holds 7.9% mindshare, down 8.0% since last year.
Test Data Management
Data Integration
 

Featured Reviews

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.
BobAmy - PeerSpot reviewer
Robust and does a good job of handling overload conditions
We purchase an add-on called task factory primarily to allow bulk delete, update, and upsert capability. I'd like to see this be part of the standard package. I believe there are ways to build a model and set variables so that it can be a generic process. In my next system, I would like to have a generic process that would handle all the logging and processing in a model that can be modified and enhanced as the need for a better process, or different statistics to be logged is discovered. I'd want this in a way that the model can be changed and all the processes, with their unique parameters, could all be changed with the model upgraded. I believe they should add some features that help to create the code using a model. This would allow for continuous improvement of the model uses and easy replication of all the different programs that use the model.

Quotes from Members

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

Pros

"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."
"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 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."
"Delphix's technical support is fairly knowledgeable."
"It is a stable solution."
"The most valuable feature is VDB provisioning."
"The solution's most valuable feature is data cloning."
"Delphix interfaces are simple to use and very user friendly."
"This solution is easy to implement, has a wide variety of connectors, has support for Visual Basic, and supports the C language."
"Like most Microsoft products, SSIS is user-friendly and easy to use."
"We can connect with multiple data sources easily using an external connector in SSIS."
"I like that this solution is very scalable, accommodating large datasets and various types of servers. It integrates with most common database servers and allows for customization through coding, including complex scripts. Compared to Alteryx Designer, SSIS offers more customization. Its data cleaning capabilities are highly accurate because we can run tests as data is loaded, ensuring it meets all requirements before reaching the final destination. The ability to write custom SQL and C# code within SSIS packages is its greatest feature."
"The most valuables features are the relatively short learning curve, and the automation capabilities provided through the BIML add-in for SSDT."
"There are many good features in this solution including the data fields, database integration, support for SQL views, and the lookups for matching information."
"With this solution, there is the potential to expand, so that you can immediately write code onto the SQL server."
"The performance and stability are good."
 

Cons

"One thing I would like to see improved is the unusual error messages we receive and some slowness we have while we are updating."
"It would be good if any CI/CD and DevOps-aligned feature could be triggered through the DevOps pipeline."
"The solution’s self-service portal must be more interactive and user-friendly."
"My only complaint about this solution is the price."
"Delphix needs better partnerships from a customer perspective. It's how they sell it, not what they're selling."
"GUI could be improved."
"This product should be extended and made to be a more comprehensive storage solution."
"Delphix is quite expensive."
"The solution could improve by having quicker release updates."
"The interface could use improvement, as well as the administrative tools. Jobs fail from time to time for different reasons. It's not a problem with Microsoft, or SSIS itself. The problems are external, but to find the problems and analyze them it takes too much time."
"The high prices attached to the product can be an area of concern where improvements are required."
"We In upgrading SSIS, we encountered challenges fixing SQL Server and performance issues, including problems during a failover in our data warehouse."
"I have a tool called ZappySys. I need that tool to cut down on the complexity of SSIS. That tool really helps with a quick turnaround. I can do things quickly, and I can do things accurately. I can get better reporting on errors."
"The creation of the measure in the DAC's model could be improved."
"The security could be improved, as it is more important in our context."
"We'd like them to develop data exploration more."
 

Pricing and Cost Advice

"The product is a little bit expensive."
"The cost is $370K annually for the Delphix Masking Engine and Delphix Virtualization Engine."
"The solution's pricing was reasonable and lower than one million."
"Delphix's pricing is affordable."
"It is an expensive solution."
"I would say the price is a little high but affordable for our needs."
"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."
"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."
"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."
"All of my clients have this product included as part of their Microsoft license."
"t's incredibly cost effective, easy to learn the basics quickly (although like all ETL tools requires the traditional learning curve to get good at) and has an immense user base."
"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."
"People have to opt for a perpetual-based licensing model."
"SSIS' licensing is a little high, but it gives good value for money."
"It would be beneficial if the solution had a less costly cloud offering."
report
Use our free recommendation engine to learn which Test Data Management solutions are best for your needs.
849,475 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
29%
Computer Software Company
11%
Insurance Company
10%
Manufacturing Company
7%
Financial Services Firm
19%
Computer Software Company
12%
Government
8%
Healthcare Company
6%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

Questions from the Community

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 good when compared to the other products in the market.
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, we have to trigger the jobs and then integrate them with DevOps, which requires s...
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 SSIS. The collection helps organizations boost productivity with code-free compo...
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
SQL Server Integration Services
 

Overview

 

Sample Customers

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
Find out what your peers are saying about Perforce Delphix vs. SSIS and other solutions. Updated: January 2020.
849,475 professionals have used our research since 2012.