Matillion ETL Valuable Features

it_user628059
Senior Engineer, Big Data/Data-Warehousing at a manufacturing company with 501-1,000 employees
* It works well with AWS Redshift: I have used Informatica, SnapLogic, and Talend and they do not work well with Redshift. * Mid-pipeline data sampling: Without changes to pipelines, one can quickly and easily track down errors. * Automatic database-object verification: A fundamental part of how Matillion works is ensuring objects, tables, columns, views, and other metadata are ready and available for use if, and when, a pipeline is started. * Run-time parameters: These enable pipelines to be organized and modularized with minimum effort. * An array of source-data components: Pulling data from wide tables, such as SFDC, can be setup in seconds. Using Sqoop to pull data to S3, for example, can take hours or even weeks to get right. It is worth noting that Matillion does not cost more if you need more source-data components (SFDC, Marketo, Google AdWords, RDS, MongoDB, etc.). * A wide array of in-database DDLs and UDFs accessible from ETL are able to process unstructured data easily, without having to resort to EMR/Hadoop solutions. * Integration with other AWS services: It can use Amazon SQS or SNS very easily to extend capabilities, such as doing micro-batch imports (near real-time updates) from source-systems. * Python components using Boto and other libraries running on Matillion’s EC2: Matillion can push data from a data warehouse, via REST APIs, to target systems like DynamoDB and Marketo. View full review »
Harpreet Singh
Director of Data Architecture at a healthcare company with 51-200 employees
* It is pretty easy to learn. * No scripting is required. * Being cloud native. View full review »
SeniorIn7f6d
Senior Infrastructure Engineer at a tech services company with 51-200 employees
* It is pretty user-friendly, even for people who aren't super technical. * It has good integrations with Amazon Redshift and other AWS services. View full review »
Neel Vora
Application Developer at John Deere & Company
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. View full review »
Luis Henriquez
Hewlett Packard Enterprise Solution Architect at a tech services company with 11-50 employees
* Analytics * Integration with SAP and AWS. View full review »
Engineer2076
Lead Software Engineer at a tech vendor with 10,001+ employees
Its ease of use. View full review »

Sign Up with Email