Matillion Data Productivity Cloud vs SAS Data Integration Server comparison

Matillion Data Productivity Cloud vs. SAS Data Integration Server

Download the complete report

Helped 859,438 peers since 2012

Review summaries and opinions

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:

Categories and Ranking

Matillion Data Productivity...

Average Rating

8.4

Reviews Sentiment

7.4

Number of Reviews

Ranking in other categories

Cloud Data Integration (8th)

SAS Data Integration Server

Average Rating

7.2

Reviews Sentiment

6.5

Number of Reviews

Ranking in other categories

Data Integration (38th)

Featured Reviews

Tomáš Hronek

Data Engineer at Merck

Used for wrangling or transforming data from sources like S3 and Databricks

I use Matillion ETL for wrangling or transforming data from sources like S3 and Databricks The most valuable feature of Matillion ETL is the UI experience in which you can drag and drop most of the transformation. Sometimes, we have issues with the solution's stability and need to restart it for…

Read full review

reviewer2937544

Works at a financial services firm with 5,001-10,000 employees

Offloads processes on the server side but needs better installation syntax

One area for improvement is the installation process. Another point could be the syntax, as it sometimes involves using syntax names that are not intuitive. For example, to calculate the difference between two dates, the general syntax in SAS is called the data difference or data net function. However, another name is used, such as NF and INK. Without knowledge of SAS programming, it becomes unclear what these functions mean. It is not good to define function names this way.

Read full review

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:

Pros

"The new version with the Productivity Cloud is very simple. It's easy to use, navigate, and understand."

"The product has a good user interface."

"The most valuable feature of Matillion ETL is the ETL. The solution is open-source which provides advantages, such as good performance and high efficiency. Additionally, it supports three data types which eliminates predefining the data, and we can write script models in Python."

"The product is quite stable and can handle complex data integration tasks well."

"It takes less than five minutes to set up and delivers results. It is much quicker than traditional ETL technologies."

"The loading of data is the most valuable feature of Matillion ETL."

"Matillion's technical support is excellent."

"It is an incredibly user-friendly and intuitive tool, making the learning curve quite smooth"

More Matillion Data Productivity Cloud pros

"The solution offers very good data manipulation and loading."

"The solution is very stable."

"A key feature allows us to enhance job performance by offloading processing to the server side, rather than processing on the server itself."

"The most valuable feature of the solution is its amazing capabilities in regard to data handling."

"A key feature allows us to enhance job performance by offloading processing to the server side, rather than processing on the server itself."

Cons

"There are problems with GCP connectivity. Specifically, connections to BigQuery for extracting information are complex, and the optimization of the extraction process requires improvements."

"The product must enhance its near-real-time data capture feature."

"Performance can be improved for efficiency, and it can be made faster."

"One of the features that's in development is data privacy in the cloud, along with further SAP integration. For connectivity to SAP systems."

"The improvement area could be possible if the tool provides better integration capabilities with other ecosystems, including governance tools or data cataloging tools, as it is currently an area where the solution is lacking."

"Matillion’s on-premises capabilities don’t allow you to build something customized."

"Unlike Snowflake which automatically takes care of upgrading to the latest version and includes additional features, with Matillion ETL we need to do this ourselves."

"Sometimes, we have issues with the solution's stability and need to restart it for three weeks or more."

More Matillion Data Productivity Cloud cons

"So I would like to see improved integration with other software."

"The initial setup had issues, and even after using it for about one year, it was still not fixed."

"One area for improvement is the installation process."

"The transform tool has limited access. They should make it more flexible."

"The initial setup of SAS Data Integration Server was complex."

"The initial setup had issues, and even after using it for about one year, it was still not fixed."

Pricing and Cost Advice

"The AWS pricing and licensing are a cost-effective solution for data integration needs."

"The pricing depends on what edition the customer opts for. For example, the standard edition is priced at $2.00 per credit. And you are only charged when you use it. You're not charged when it's idle."

"A rough estimation of the cost is around 20,000 dollars a month, however, this is dependent on the machine used and how Matillion ETL is used."

"It is cost-effective. Based on our use case, it's efficient and cheap. It saves a lot of money and our upfront costs are less."

"I think it is cost conscious. It used to be very cheap and they have more recently bumped up the pricing, so it is competitive now."

"Purchasing it through the AWS Marketplace is pretty convenient. There is a little bit of back and forth in terms of the licensing based on the machine size, but it seems to have worked out well. it is convenient to have it all as part of our AWS billing."

"The prices needs to be lower."

"It was procured through the AWS Marketplace because it keeps things simple. They offer retail-like checkout and bill through your existing Amazon Web Services account."

More Matillion Data Productivity Cloud pricing and cost advice

"It is an expensive program."

See which vendors are best for you

Use our free recommendation engine to learn which Cloud Data Integration solutions are best for your needs.

See recommendations

859,438 professionals have used our research since 2012.

Top Industries

By visitors reading reviews

Financial Services Firm

19%

Computer Software Company

15%

Manufacturing Company

Energy/Utilities Company

Financial Services Firm

27%

Computer Software Company

12%

Government

Insurance Company

Company Size

By reviewers

Large Enterprise

Midsize Enterprise

Small Business

No data available

Questions from the Community

What do you like most about Matillion ETL?

The new version with the Productivity Cloud is very simple. It's easy to use, navigate, and understand.

What is your experience regarding pricing and costs for Matillion ETL?

While pricing can be an issue compared to other solutions, Matillion Data Productivity Cloud offers discounts and special deals, especially when dealing with high-volume clients or fewer existing c...

What needs improvement with Matillion ETL?

There are problems with GCP connectivity. Specifically, connections to BigQuery for extracting information are complex, and the optimization of the extraction process requires improvements. I raise...

What do you like most about SAS Data Integration Server?

The most valuable feature of the solution is its amazing capabilities in regard to data handling.

What is your experience regarding pricing and costs for SAS Data Integration Server?

I don't handle the cost and budget part. From the tool's perspective, I can say that it is an amazing product.

What needs improvement with SAS Data Integration Server?

Azure Data Factory vs Matillion Data Productivity Cloud

Comparisons

Compared 13% of the time

AWS Glue vs Matillion Data Productivity Cloud

Compared 10% of the time

SSIS vs Matillion Data Productivity Cloud

Compared 8% of the time

Oracle Data Integrator (ODI) vs Matillion Data Productivity Cloud

Compared 6% of the time

SnapLogic vs Matillion Data Productivity Cloud

Compared 5% of the time

More Matillion Data Productivity Cloud Competitors

SSIS vs SAS Data Integration Server

Compared 30% of the time

Azure Data Factory vs SAS Data Integration Server

Compared 24% of the time

Oracle Data Integrator (ODI) vs SAS Data Integration Server

Compared 17% of the time

Palantir Foundry vs SAS Data Integration Server

Compared 17% of the time

AWS Glue vs SAS Data Integration Server

Compared 12% of the time

More SAS Data Integration Server Competitors

Product Reports

Matillion Data Productivity Cloud

Download Matillion Data Productivity Cloud product report

Matillion Data Productivity Cloud report

Data Integration

Download SAS Data Integration Server product report

Also Known As

Matillion ETL for Redshift, Matillion ETL for Snowflake, Matillion ETL for BigQuery

SAS Enterprise Data Integration Server, Enterprise Data Integration Server

Overview

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?

User-Friendly Interface: Simplifies interaction for non-technical users with a graphical interface.
Seamless Integration: Works smoothly with AWS, SFDC, RDS, Marketo, Facebook, and Google AdWords.
Automatic Scalability: Efficiently manages varying workloads with scale-up and down capabilities.
Efficient Data Handling: Streamlines transformations, scheduling, and sample data verifications.
Diverse Data Source Support: Easily integrates multiple data sources for streamlined processes.

What benefits and ROI should users seek in reviews?

Ease of Use: Reduces complexity for non-technical teams with intuitive operation.
Performance Efficiency: Fast data processing and transformations enhance productivity.
Cloud Compatibility: Supports integration with cloud platforms for versatile data solutions.
Time-Saving Scheduling: Automates data tasks, allowing users to focus on other priorities.
Scalability: Automatically adjusts to workload needs, optimizing resource use and cost.

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.

Matillion

SAS Data Integration Server is a powerful, configurable and comprehensive solution that can meet a wide variety of data integration requirements, from small tactical projects to strategic business initiatives. It can access virtually all data sources, support data warehousing, migration, synchronization, federation and provisioning initiatives. It can support both batch-oriented and real-time master data management solutions. It can create reusable data integration services in support of service-oriented architectures and data governance and extract, cleanse, transform, conform, aggregate, load and manage data.

SAS

Sample Customers

Thrive Market, MarketBot, PWC, Axtria, Field Nation, GE, Superdry, Quantcast, Lightbox, EDF Energy, Finn Air, IPRO, Twist, Penn National Gaming Inc

Credit Guarantee Corporation, Cr_dito y Cauci‹n, Delaware State Police, Deutsche Lufthansa, Directorate of Economics and Statistics, DSM, Livzon Pharmaceutical Group, Los Angeles County, Miami Herald Media Company, Netherlands Enterprise Agency, New Zealand Ministry of Health, Nippon Paper, West Midlands Police, XS Inc., Zenith Insurance

Matillion Data Productivity Cloud vs. SAS Data Integration Server