SSIS and Matillion Data Productivity Cloud compete in the ETL solutions category, with distinct pros and cons. Matillion appears to have an advantage due to its cloud-native operations and comprehensive feature set, which offsets its higher cost.
Features: SSIS offers quick ETL setup, broad Microsoft compatibility, and a powerful scripting component enabling robust data handling. Its drag-and-drop interface simplifies data integration tasks. Matillion enhances integration and transformation speed with AWS support and a plethora of pre-built connectors that streamline complex data pipeline creation.
Room for Improvement: SSIS requires third-party tools for enhanced data connectivity and lacks built-in version control, which can hinder developers. It faces challenges with metadata management and scalability under large data volumes. Matillion users seek more database integrations and faster API adaptations, and could benefit from improved real-time processing and data migration capabilities.
Ease of Deployment and Customer Service: SSIS primarily offers on-premises deployment with limited cloud-native features. Its customer support is often criticized, though Microsoft's established ecosystem supports self-help resources. Matillion's cloud orientation simplifies deployment, with users praising its easily accessible customer service and responsive support systems.
Pricing and ROI: SSIS is bundled with SQL Server licenses, offering a cost-effective solution with a potentially high ROI, particularly for Microsoft-centric infrastructures. Matillion features tiered pricing based on instance size and use, appealing to those seeking scalable cloud solutions despite higher upfront costs than SSIS.
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.
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.
SSIS has a difficult learning curve when dealing with complex transformations.
The logging capabilities could be improved, particularly for error logging.
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.
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.
We end up with people not understanding that you need to build your models correctly, and then they try to model everything inside of Power BI, or another visualization tool, without first building the data model.
| Company Size | Count |
|---|---|
| Small Business | 6 |
| Midsize Enterprise | 10 |
| Large Enterprise | 11 |
| Company Size | Count |
|---|---|
| Small Business | 26 |
| 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.
