Matillion Data Productivity Cloud vs SAS Data Integration Server comparison

Matillion Data Productivity Cloud vs. SAS Data Integration Server

Download the complete report

Helped 869,771 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 (41st)

Featured Reviews

Jitendra Jena

Director Axtria - Ingenious Insights! at Axtria - Ingenious Insights

Easy integration and workflow proposals streamline processes

The predefined connectors eliminate the need to write code for connectivity. If you have a predefined connector, it is easy to use with plug and play functionality. The processing time and ease of use are significant benefits. As everyone is moving into AI integration, it will definitely help. When creating workflows, they can propose solutions directly.

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 predefined connectors eliminate the need to write code for connectivity; if you have a predefined connector, it is easy to use with plug and play functionality."

"We allow non-technical people to use Matillion to load data into our data warehouse for reporting. Thus, it is easy enough to use that we don't always have to get a technical person involved in setting up a data movement (ETL)."

"The product's initial setup phase was easy."

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

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

"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."

"Matillion's technical support is excellent."

"It is pretty user-friendly, even for people who aren't super technical."

More Matillion Data Productivity Cloud pros

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

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

"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."

Cons

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

"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's scalability needs improvement. Perhaps adding more connectors would be beneficial."

"To complete the pipeline, they might want to include some connectors which would put the data into different platforms. This would be helpful."

"It can have multi-environment support. We should be able to deploy it in different environments. Its integration with SAP connection is not so nice, which should be improved. It can also support an on-prem database."

"Scalability in Matillion Data Productivity Cloud has some limitations. 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."

"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."

More Matillion Data Productivity Cloud cons

"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."

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

"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."

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

Pricing and Cost Advice

"I have heard from my manager and other higher ups, "This product is cheaper than other things on the market," and they have done the research."

"Matillion ETL is expensive."

"The solution is very cheap. You're paying $2.50 an hour and if you set your service up, which you can do, you're not getting charged. Currently, our ETL process is just an overnight process that runs for about an hour. I can start and stop my server just for an hour if I want to and spent $2.50 a day for an ETL solution. There are no additional costs."

"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."

"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."

"It is not necessarily a cheap solution. However, it's reasonable priced, especially with the smaller machines that we run it on."

"The cost of the solution is high and could be reduced."

"Matillion ETL has a pay-as-you-go pricing model of a few dollars per hour of runtime."

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

869,771 professionals have used our research since 2012.

Top Industries

By visitors reading reviews

Financial Services Firm

16%

Computer Software Company

15%

Manufacturing Company

Retailer

Financial Services Firm

28%

Computer Software Company

Insurance Company

Government

Company Size

By reviewers

Large Enterprise

Midsize Enterprise

Small Business

By reviewers
Company Size	Count
Small Business	6
Midsize Enterprise	10
Large Enterprise	11

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?

The pricing is managed by the tooling team. The pricing is moderate, neither expensive nor cheap.

What needs improvement with Matillion ETL?

The main areas for improvement are AI features and scalability.

What needs improvement with SAS Data Integration Server?

What is your primary use case for SAS Data Integration Server?

I am involved in the ETR job. My role is focused on executing the ETR job.

What advice do you have for others considering SAS Data Integration Server?

I use it without further details. For example, if I use SAS to connect to a NetEazt database or purchase a shared asset to ODBC, I can connect to any database with ODBC connection support. The over...

AWS Glue vs Matillion Data Productivity Cloud

Comparisons

Compared 8% of the time

Oracle Data Integrator (ODI) vs Matillion Data Productivity Cloud

Compared 7% of the time

SnapLogic vs Matillion Data Productivity Cloud

Compared 5% of the time

Azure Data Factory vs Matillion Data Productivity Cloud

Compared 5% of the time

Workato vs Matillion Data Productivity Cloud

Compared 5% of the time

More Matillion Data Productivity Cloud Competitors

SSIS vs SAS Data Integration Server

Compared 35% of the time

Azure Data Factory vs SAS Data Integration Server

Compared 20% of the time

Oracle Data Integrator (ODI) vs SAS Data Integration Server

Compared 16% of the time

Palantir Foundry vs SAS Data Integration Server

Compared 16% of the time

AWS Database Migration Service vs SAS Data Integration Server

Compared 14% 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