SSIS and Matillion Data Productivity Cloud compete in the ETL market. Matillion seems to have the advantage in cloud-native environments, providing simpler setup and agile features.
Features: SSIS provides robust ETL capabilities, integrating seamlessly with Microsoft ecosystems. It offers custom scripting through .Net and automation via BIML, supporting varied data tasks like emailing and script execution. Matillion emphasizes ease of use for cloud setups, particularly on AWS, with built-in verification, sampling, and cross-platform integrations such as SAP and AWS services, appealing to enterprises focused on cloud solutions.
Room for Improvement: SSIS struggles with real-time processing and handling high data volumes, lacking built-in version control and having issues with data source connections. Matillion can improve on concurrency and backend integration, along with expanding on-premises customization options. It also requires enhancements in data streaming functionalities and integration with more data sources and ecosystems.
Ease of Deployment and Customer Service: SSIS primarily operates in on-premises and hybrid environments, challenging for cloud-centric transitions, with support often dependent on community forums. Matillion facilitates cloud-based deployment through AWS Marketplace, though it faces challenges in stability which sometimes require customer intervention.
Pricing and ROI: SSIS is cost-effective for enterprises with investments in Microsoft, bundled with SQL Server. Matillion offers a flexible pay-as-you-go model on AWS, appealing for its scalability and operational flexibility, despite higher AWS-related costs.
Consequently, we adjusted our processes to use Matillion Data Productivity Cloud only for extraction and ingestion, while Snowflake handled all transformations and jobs.
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 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.
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.
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.
Utilizing SSIS involves no extra charges beyond the SQL Server license.
Matillion Data Productivity Cloud is effective for ingest functions, particularly when moving information to Snowflake and performing many transformations.
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.
One of the best aspects of SSIS is that it is built into Microsoft SQL Server, so there are no additional costs involved.
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.