SSIS and Denodo are products in the data integration category. While SSIS shines with its pricing and support favorability, Denodo is recognized for its advanced features, offering significant value despite higher costs.
Features: SSIS offers extensive ETL capabilities, seamless integration with Microsoft tools, and robust workflow automation. Denodo is strong in data virtualization, providing real-time data access and connectivity across varied sources.
Room for Improvement: SSIS could enhance its data virtualization options and expand connectivity support beyond Microsoft-centric integrations. Additionally, simplifying complex ETL scenarios may improve user experience. Denodo may benefit from reducing its initial setup cost, increasing user-friendly features for novice users, and offering more direct integration tutorials for diverse systems.
Ease of Deployment and Customer Service: SSIS is known for its easy deployment in Microsoft ecosystems, with excellent documentation and support. Denodo provides flexible deployment including on-premise, cloud, and hybrid solutions, with strong support tailored for complex deployments.
Pricing and ROI: SSIS is more affordable with lower initial setup costs, offering quick ROI especially for businesses with Microsoft platforms. Denodo, though costlier, promises substantial ROI through its advanced analytics and data virtualization capabilities, drawing interest from enterprises focusing on long-term data strategy.
Using SSIS has proven cost-effective as there are no additional fees outside the SQL Server license, and it significantly enhances data management efficiency.
Denodo's customer support team is very competent and responsive.
The documentation is very thorough.
They are proactive in conducting webinars and connecting with customers.
While the solution scales well on a single machine, I have doubts about its scalability when deployed as part of a Java component cluster.
Its complexity in configuring and the requirement to install different connectors for different sources affects its scalability.
I would rate it nine out of ten because it is very reliable, always performing as expected.
If JVM does not function properly, it may cause Denodo to fail to connect to different sources.
It processes large volumes of data quickly.
The system has dependencies on other environments, like JVM, which can affect its performance.
Ensuring data caching is up to date is critical.
Denodo needs better communication on how the product can be deployed for specific solutions.
Within the South African context, if you are getting your enterprise agreement from First Technology, they don't provide support.
SSIS has a difficult learning curve when dealing with complex transformations.
Denodo is considered pricey, limiting its use to large enterprises or government organizations that can afford its comprehensive setup.
Denodo's pricing is not affordable for small companies and is more suitable for medium to large enterprises.
Utilizing SSIS involves no extra charges beyond the SQL Server license.
The most valuable feature of Denodo is its uniformity of self-site data access types, which allows it to connect to almost any storage technology and feed it transparently.
Denodo's ability to connect to multiple data sources and perform extract-transform-load (ETL) operations on the fly is noteworthy.
Its catalog is useful for data governance and helps document information for databases and fields.
One of the best aspects of SSIS is that it is built into Microsoft SQL Server, so there are no additional costs involved.
SSAS is included in the base installation of SQL Server.
Denodo is a leading data integration, management, and delivery platform that uses a logical approach to enable data science, hybrid and multi-cloud data integration, self-service BI, and enterprise data services. Organizations of different sizes across various industries utilize the product to get above the data silos. The solution offers organizations the freedom to migrate data to the cloud, or logically unify data warehouses and data lakes, without affecting business. This can ultimately result in the evolution of data strategies.
The platform accelerates data provisioning through reduced data replication, provides business users the freedom to select their preferred applications, and enables consistent security and governance across multiple systems. The solution offers one of the leading logical data fabric solutions by initiating data virtualization and eliminating the complexity and exposing the data in business-friendly formats.
Denodo also offers modern data integration and management for hybrid and multi-cloud environments for Denodo Platform for Cloud. This service can be purchased through the bring-your-own-license (BYOL) option. Users seeking faster deployment can license the product to popular cloud providers, including Amazon AWS, Google Cloud Platform, and Microsoft Azure. The solution integrates, manages, and delivers data in complex environments with high performance, governance, and security. It also offers additional solutions, such as the Denodo Platform for Cloud Modernization, the Denodo Platform for Cloud Data Integration, and the Denodo Platform for Cloud Analytics, which overcome common cloud data challenges.
Denodo Features
At the beginning of 2022, version 8.0 of Denodo introduced several new key features of the platform. These include:
Denodo Benefits
Denodo offers various benefits for its users through its services. Some of the greatest advantages of using this platform include:
Reviews from Real Users
Naresh M., a senior application developer at a financial services firm, appreciates Denodo because it offers quick and simple web services creation.
Alisson M., a senior BigData DevOps engineer at Schaeffler, says that Denodo is great for queries and scouting data.
SSIS is a versatile tool for data integration tasks like ETL processes, data migration, and real-time data processing. Users appreciate its ease of use, data transformation tools, scheduling capabilities, and extensive connectivity options. It enhances productivity and efficiency within organizations by streamlining data-related processes and improving data quality and consistency.
We monitor all Data Integration reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.
