SSIS and Matillion Data Productivity Cloud are both competitors in the ETL solutions market. While Matillion has an edge with its cloud integration and user-friendly GUI, SSIS offers strong compatibility with Microsoft ecosystems.
Features: SSIS enables users to build ETL solutions with minimal expertise and offers features like high data transfer capabilities, email sending, and custom code writing. Its compatibility with Microsoft products is a significant advantage. Matillion Data Productivity Cloud provides strong cloud service integration and an intuitive graphical interface, utilizing AWS's scalability. The GUI-based system simplifies user handover and eliminates coding for connectivity.
Room for Improvement: SSIS could improve scalability, intuitive error logging, and support for non-Microsoft databases. It also lacks built-in version control and advanced logging. Matillion requires better concurrent workload handling and backend integration, with data privacy and job scalability remaining a concern.
Ease of Deployment and Customer Service: SSIS is ideal for on-premise deployments within the Microsoft ecosystem, and users often resolve issues independently due to inconsistent support experiences. Matillion excels in cloud flexibility, offering public and private deployments, with responsive support and seamless interaction with cloud platforms.
Pricing and ROI: SSIS offers cost-effectiveness as it is bundled with SQL Server licenses, enhancing its value proposition. Matillion, with its consumption-based pricing, may become expensive without careful management. Despite higher costs compared to some competitors, its cloud-native advantages can justify the investment for cloud-focused organizations.
Consequently, we adjusted our processes to use Matillion Data Productivity Cloud only for extraction and ingestion, while Snowflake handled all transformations and jobs.
The tool has made us tremendously more efficient and saved us a significant amount of money.
Using SSIS has proven cost-effective as there are no additional fees outside the SQL Server license, and it significantly enhances data management efficiency.
They communicate effectively and respond quickly to all inquiries.
The first line of support needs to be more knowledgeable.
Depending on the nature of data sets, volume, and mixture of different data, the scalability could be improved as manual code writing is still required.
The autoscale process works well, allowing the system to start another node automatically if the first machine reaches 80% capacity.
I would rate the scalability of SSIS at a 7 because we are able to use various third-party items with it, allowing for functionality with a number of different things.
It processes large volumes of data quickly.
The main areas for improvement are AI features and scalability.
Connections to BigQuery for extracting information are complex.
Within the South African context, if you are getting your enterprise agreement from First Technology, they don't provide support.
The logging capabilities could be improved, particularly for error logging.
SSIS could be integrated with more services, such as Power BI, to make the reporting structures more user-friendly.
Matillion Data Productivity Cloud offers discounts and special deals, especially when dealing with high-volume clients or fewer existing clients in specific regions, like Spain.
The pricing is moderate, neither expensive nor cheap.
However, it could be a bit cheaper.
Utilizing SSIS involves no extra charges beyond the SQL Server license.
It was included in our licensing for SQL server, and our licensing for SQL server was extremely cheap, making it a very good price point for us.
The predefined connectors eliminate the need to write code for connectivity.
Matillion Data Productivity Cloud is effective for ingest functions, particularly when moving information to Snowflake and performing many transformations.
I would rate it at a 10 as it is highly reliable; we have never had any problems with it.
One of the best aspects of SSIS is that it is built into Microsoft SQL Server, so there are no additional costs involved.
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.
| Company Size | Count |
|---|---|
| Small Business | 6 |
| Midsize Enterprise | 10 |
| Large Enterprise | 11 |
| Company Size | Count |
|---|---|
| Small Business | 27 |
| Midsize Enterprise | 19 |
| Large Enterprise | 57 |
Matillion Data Productivity Cloud offers a user-friendly platform for seamless integration and dynamic data handling, favored for simplifying ETL processes with minimal coding and ensuring robust performance in complex data tasks.
Matillion Data Productivity Cloud integrates effortlessly with platforms like AWS, Snowflake, and SQL databases, providing tools for efficient data migration, transformation, and cloud warehousing. It supports large datasets with swift management, making it valued for its graphical interface that eases ETL processes for non-technical users. Automation features ensure scalability and dynamic data handling across diverse sources, while security and cost-effectiveness enhance its appeal. Enhancements in database connectivity, interface design, and multi-environment support would refine user experience, with growing demands for real-time data capture, SAP connectivity, and frequent API updates.
What are the most important features?In industries like finance, healthcare, and retail, Matillion Data Productivity Cloud is implemented for transforming data operations. Companies leverage it for its speed in data processing and integration capability, facilitating rapid adaptation to data-driven insights crucial in these sectors.
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 Cloud 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.
