What users are saying about
50 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener'>trScore algorithm: Learn more.</a>Score 8.7 out of 100
Based on 50 reviews and ratings
228 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener'>trScore algorithm: Learn more.</a>Score 8.1 out of 100
Based on 228 reviews and ratings
Feature Set Ratings
Data Source Connection
Databricks Lakehouse Platform
Feature Set Not Supported
N/A
6.3
SSIS
63%
SQL Server Integration Services ranks higher in 2/2 features
SQL Server Integration Services ranks higher in 2/2 features
Connect to traditional data sources
N/A
0 Ratings
8.6
86%
40 Ratings
Connecto to Big Data and NoSQL
N/A
0 Ratings
4.0
40%
30 Ratings
Data Transformations
Databricks Lakehouse Platform
Feature Set Not Supported
N/A
8.4
SSIS
84%
SQL Server Integration Services ranks higher in 2/2 features
SQL Server Integration Services ranks higher in 2/2 features
Simple transformations
N/A
0 Ratings
9.2
92%
40 Ratings
Complex transformations
N/A
0 Ratings
7.6
76%
39 Ratings
Data Modeling
Databricks Lakehouse Platform
Feature Set Not Supported
N/A
7.2
SSIS
72%
SQL Server Integration Services ranks higher in 6/6 features
SQL Server Integration Services ranks higher in 6/6 features
Data model creation
N/A
0 Ratings
8.2
82%
17 Ratings
Metadata management
N/A
0 Ratings
8.0
80%
22 Ratings
Business rules and workflow
N/A
0 Ratings
6.5
65%
33 Ratings
Collaboration
N/A
0 Ratings
5.6
56%
28 Ratings
Testing and debugging
N/A
0 Ratings
7.5
75%
38 Ratings
feature 1
N/A
0 Ratings
7.0
70%
1 Rating
Data Governance
Databricks Lakehouse Platform
Feature Set Not Supported
N/A
6.5
SSIS
65%
SQL Server Integration Services ranks higher in 2/2 features
SQL Server Integration Services ranks higher in 2/2 features
Integration with data quality tools
N/A
0 Ratings
8.7
87%
28 Ratings
Integration with MDM tools
N/A
0 Ratings
4.4
44%
26 Ratings
Attribute Ratings
- Databricks Lakehouse Platform (Unified Analytics Platform) is rated higher in 1 area: Likelihood to Recommend
- SQL Server Integration Services is rated higher in 2 areas: Usability, Support Rating
Likelihood to Recommend
8.7
Databricks Lakehouse Platform
87%
15 Ratings
8.2
SSIS
82%
40 Ratings
Likelihood to Renew
Databricks Lakehouse Platform
N/A
0 Ratings
10.0
SSIS
100%
3 Ratings
Usability
9.0
Databricks Lakehouse Platform
90%
3 Ratings
9.3
SSIS
93%
8 Ratings
Performance
Databricks Lakehouse Platform
N/A
0 Ratings
8.8
SSIS
88%
12 Ratings
Support Rating
7.5
Databricks Lakehouse Platform
75%
2 Ratings
8.2
SSIS
82%
14 Ratings
Implementation Rating
Databricks Lakehouse Platform
N/A
0 Ratings
10.0
SSIS
100%
2 Ratings
Contract Terms and Pricing Model
8.0
Databricks Lakehouse Platform
80%
1 Rating
SSIS
N/A
0 Ratings
Professional Services
10.0
Databricks Lakehouse Platform
100%
1 Rating
SSIS
N/A
0 Ratings
Likelihood to Recommend
Databricks Lakehouse Platform
If you need a managed big data megastore, which has native integration with highly optimized Apache Spark Engine and native integration with MLflow, go for Databricks Lakehouse Platform. The Databricks Lakehouse Platform is a breeze to use and analytics capabilities are supported out of the box. You will find it a bit difficult to manage code in notebooks but you will get used to it soon.

Verified User
Engineer in Engineering
Computer Software Company, 1001-5000 employeesSSIS
Well suited: all data extraction from file (spreadsheet-like) and RDBMS data sources, mix up them into one integrated meta-data source for future processing.Less appropriate: big key-value data storages processed slowly, and hard to make data mining through uniting non-RDBMS and RDBMS data sources naive way. The data from non-SQL databases should be prepared accordingly to be represented in a table-like way if possible.
Hardware / Embedded Software (C/C++) Developer
Waldorf Music GmbHInformation Technology & Services, 11-50 employees
Pros
Databricks Lakehouse Platform
- Process raw data in One Lake (S3) env to relational tables and views
- Share notebooks with our business analysts so that they can use the queries and generate value out of the data
- Try out PySpark and Spark SQL queries on raw data before using them in our Spark jobs
- Modern day ETL operations made easy using Databricks. Provide access mechanism for different set of customers

Verified User
Team Lead in Engineering
Financial Services Company, 10,001+ employeesSSIS
- Ease of use - can be used with no prior experience in a relatively short amount of time.
- Flexibility - provides multiple means of accomplishing tasks to be able to support virtually any scenario.
- Performance - performs well with default configurations but allows the user to choose a multitude of options that can enhance performance.
- Resilient - supports the configuration of error handling to prevent and identify breakages.
- Complete suite of configurable tools.

Verified User
Project Manager in Information Technology
Computer Software Company, 201-500 employeesCons
Databricks Lakehouse Platform
- Better Localized Testing
- When they were primarily OSS Spark; it was easier to test/manage releases versus the newer DB Runtime. Wish there was more configuration in Runtime less pick a version.
- Graphing Support went non-existent; when it was one of their compelling general engine.

Verified User
Director in Information Technology
Financial Services Company, 201-500 employeesSSIS
- SSIS has been a bit neglected by Microsoft and new features are slow in coming.
- When importing data from flat files and Excel workbooks, changes in the data structure will cause the extracts to fail. Workarounds do exist but are not easily implemented. If your source data structure does not change or rarely changes, this negative is relatively insignificant.
- While add-on third-party SSIS tools exist, there are only a small number of vendors actively supporting SSIS and license fees for production server use can be significant especially in highly-scaled environments.

Verified User
Team Lead in Information Technology
Information Technology and Services Company, 10,001+ employeesPricing Details
Databricks Lakehouse Platform
General
Free Trial
—Free/Freemium Version
—Premium Consulting/Integration Services
—Entry-level set up fee?
No
Starting Price
$0.07 Per DBU
Databricks Lakehouse Platform Editions & Modules
Edition
Standard | $0.071 |
---|---|
Premium | $0.101 |
Enterprise | $0.131 |
- Per DBU
Additional Pricing Details
—SSIS
General
Free Trial
—Free/Freemium Version
—Premium Consulting/Integration Services
—Entry-level set up fee?
No
Starting Price
—SSIS Editions & Modules
—
Additional Pricing Details
—Likelihood to Renew
Databricks Lakehouse Platform
No score
No answers yet
No answers on this topic
SSIS
SSIS 10.0
Based on 3 answers
Some features should be revised or improved, some tools (using it with Visual Studio) of the toolbox should be less schematic and somewhat more flexible. Using for example, the CSV data import is still very old-fashioned and if the data format changes it requires a bit of manual labor to accept the new data structure
Database Administrator
Intralot Italia S.p.A.Gambling & Casinos, 51-200 employees
Usability
Databricks Lakehouse Platform
Databricks Lakehouse Platform 9.0
Based on 3 answers
Because it is an amazing platform for designing experiments and delivering a deep dive analysis that requires execution of highly complex queries, as well as it allows to share the information and insights across the company with their shared workspaces, while keeping it secured.
in terms of graph generation and interaction it could improve their UI and UX
in terms of graph generation and interaction it could improve their UI and UX

Verified User
Manager in Product Management
Financial Services Company, 201-500 employeesSSIS
SSIS 9.3
Based on 8 answers
SQL Server Integration Services is a relatively nice tool but is simply not the ETL for a global, large-scale organization. With developing requirements such as NoSQL data, cloud-based tools, and extraordinarily large databases, SSIS is no longer our tool of choice.

Verified User
Engineer in Information Technology
Automotive Company, 10,001+ employeesPerformance
Databricks Lakehouse Platform
No score
No answers yet
No answers on this topic
SSIS
SSIS 8.8
Based on 12 answers
Raw performance is great. At times, depending on the machine you are using for development, the IDE can have issues. Deploying projects is very easy and the tool set they give you to monitor jobs out of the box is decent. If you do very much with it you will have to write into your projects performance tracking though.
DBA / Sr. Data Analyst
BoostabilityMarketing and Advertising, 201-500 employees
Support Rating
Databricks Lakehouse Platform
Databricks Lakehouse Platform 7.5
Based on 2 answers
One of the best customer and technology support that I have ever experienced in my career. You pay for what you get and you get the Rolls Royce. It reminds me of the customer support of SAS in the 2000s when the tools were reaching some limits and their engineer wanted to know more about what we were doing, long before "data science" was even a name. Databricks truly embraces the partnership with their customer and help them on any given challenge.
Director Data Science
CNTransportation/Trucking/Railroad, 10,001+ employees
SSIS
SSIS 8.2
Based on 14 answers
The support, when necessary, is excellent. But beyond that, it is very rarely necessary because the user community is so large, vibrant and knowledgable, a simple Google query or forum question can answer almost everything you want to know. You can also get prewritten script tasks with a variety of functionality that saves a lot of time.
Chemist, LIMS Specialist
USDA-FSISGovernment Administration, 5001-10,000 employees
Implementation Rating
Databricks Lakehouse Platform
No score
No answers yet
No answers on this topic
SSIS
SSIS 10.0
Based on 2 answers
The implementation may be different in each case, it is important to properly analyze all the existing infrastructure to understand the kind of work needed, the type of software used and the compatibility between these, the features that you want to exploit, to understand what is possible and which ones require integration with third-party tools
Database Administrator
Intralot Italia S.p.A.Gambling & Casinos, 51-200 employees
Alternatives Considered
Databricks Lakehouse Platform
Databricks has a much better edge than Synapse in hundred different ways. Databricks has Photon engine, faster available release in cloud and databricks does not run on Open source spark version so better optimization, better performance and better agility and all kind of performance boost can be achieved in Databricks rather Open source synapse spark

Verified User
Director in Information Technology
Hospitality Company, 10,001+ employeesSSIS
Look for where you are going to load the data and from where are you extracting it. A lot of those who sell you the DB already have tools for ETL. I have heard good things at an enterprise level from great colleagues about Informatica, but honestly, I prefer SSIS.Although I did like TIBCO Jaspersoft and it can be mixed with TIBCO Spotfire for data analysis. If your ERP is SAP, then you must keep in mind using SAP BusinessObjects. As for free tools, and if you have a great and constant team of scripting (Perl, Python) engineers, then you can think about going open source.
Systems/Software Engineer V
Hewlett Packard EnterpriseComputer Hardware, 10,001+ employees
Contract Terms and Pricing Model
Databricks Lakehouse Platform
Databricks Lakehouse Platform 8.0
Based on 1 answer
The problem with this tool and all other ones that are at the top of the industry, it's so expensive that soon as another one will be on the market and deliver the same or different value, it will be catastrophic for them. So you get the fact that they are cashing every dime right now like SAS or Hadoop once did. Now, look at them
Director Data Science
CNTransportation/Trucking/Railroad, 10,001+ employees
SSIS
No score
No answers yet
No answers on this topic
Professional Services
Databricks Lakehouse Platform
Databricks Lakehouse Platform 10.0
Based on 1 answer
Again, another level of professional services, this is not their biggest strength but this is the cherry on top. I couldn't think about any other professional services like this one. Now I'm talking about meaningful services that really help out our project and delivery.
Director Data Science
CNTransportation/Trucking/Railroad, 10,001+ employees
SSIS
No score
No answers yet
No answers on this topic
Return on Investment
Databricks Lakehouse Platform
- Machine learning is a very new concept and not many universities offer to teach it. My school and a few others have been utilizing Databricks as one of the tools to teach and learn machine learning. By doing this, my university is creating a strong future workforce for the job market.
Freelance Translator
ZOO Digital Group plcEntertainment, 501-1000 employees
SSIS
- I use SSIS to automate tasks that I'm repeatedly asked to do. "Hey, can you go into the system and close any open orders that we've fully filled?" Sure....then I schedule a package to do that for me every hour so I'm never asked again. It saves me time, which gives value to the company.
- It removes the risk of human error. When people build files and send them, there's the risk that it doesn't happen the same way every time or gets forgotten. With SSIS, you spend some up front time building a process, but then you deploy it and forget it (unless it emails you that there was an error. You are putting error handling in your ETL, right?). Very repeatable and consistent business solution.
SQL Database and Business Intelligence Manager
Ten CateTextiles, 1001-5000 employees