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
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

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

    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

    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

    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

    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.
    Anonymous | TrustRadius Reviewer

    SSIS

    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.
    Vladimir Salnikov | TrustRadius Reviewer

    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
    Anonymous | TrustRadius Reviewer

    SSIS

    • 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.
    Anonymous | TrustRadius Reviewer

    Cons

    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.
    Anonymous | TrustRadius Reviewer

    SSIS

    • 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.
    Anonymous | TrustRadius Reviewer

    Pricing 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
    1. 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
    Luca Campanelli | TrustRadius Reviewer

    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
    Anonymous | TrustRadius Reviewer

    SSIS

    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.
    Anonymous | TrustRadius Reviewer

    Performance

    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.
    Steven Gockley, MBA, MCSA | TrustRadius Reviewer

    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.
    Jonatan Bouchard | TrustRadius Reviewer

    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.
    Chris Morgan | TrustRadius Reviewer

    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
    Luca Campanelli | TrustRadius Reviewer

    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
    Anonymous | TrustRadius Reviewer

    SSIS

    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.
    Jose Pla | TrustRadius Reviewer

    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
    Jonatan Bouchard | TrustRadius Reviewer

    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.
    Jonatan Bouchard | TrustRadius Reviewer

    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.
    Ann Le | TrustRadius Reviewer

    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.
    Greg Goss | TrustRadius Reviewer

    Add comparison