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 features an intuitive graphical interface, seamless AWS integration, and efficient data management. Its tools streamline complex tasks for SFDC, RDS, Marketo, Facebook, and Google AdWords.
Matillion Data Productivity Cloud provides fast transformations with built-in verification, easy scheduling, and sampling. With automatic scalability and diverse data source support, it simplifies complex data tasks. Users benefit from cloud data warehousing and integrating data into Snowflake while appreciating its ease of use by non-technical teams. Enhancements can focus on frequent API adjustments, improved documentation, faster performance with less latency, and better error handling.
What are the key features of Matillion Data Productivity Cloud?
What benefits and ROI should users seek in reviews?
In industries such as technology, finance, and healthcare, Matillion Data Productivity Cloud is implemented to streamline ETL processes, optimize data pipeline construction, and enhance data migration efforts. It supports efficient data loading and integration between cloud and on-premises databases, aiding industries in managing data-driven projects.
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.
