Matillion ETL for Redshift | Matillion

Matillion ETL for Redshift

Matillion ETL for Redshift is a fast, modern, easy-to-use and powerful ETL/ELT tool that makes it simple and productive to load and transform data on Amazon Redshift.  100 x faster than traditional ETL technology, up and running in under 5 minutes and prices from $1.37 per hour, with no commitments or up-front costs.

Delivered via the AWS Marketplace, you can launch Matillion ETL for Redshift as an AMI directly inside your EC2 console.

etl-console

Load data

console-list-preview

 

With a few clicks you can load data directly into Redshift, fast, from Amazon S3; Amazon RDS; relational, columnar, cloud and NoSQL databases; FTP/HTTP; REST, SOAP, & JSON APIs; Amazon EMR; Amazon DynamoDb; and directly from enterprise and cloud-based systems including Salesforce.com, Netsuite, SAP, Google Analytics, Google Adwords, Facebook, Twitter and many more.

 

 

Transform data

Matillion ETL for Redshift transforms data at eye-popping speed in a productivity-orientated, streamlined, browser-based graphical job development environment.  Expect 50% reduction in ETL development and maintenance effort and months off your project as a result of the streamlined UI, perfect integration to AWS & Redshift and the sheer speed.

etl-console-2

 

etl-preview

Orchestrate

Matillion ETL for Redshift delivers a rich orchestration environment where you can orchestrate data load and transform; control flow; integrate with other systems and AWS services via Amazon SQS, Amazon SNS and Python; iterate; manage variables; create and drop tables; vacuum and analyse tables; soft code ETL/ELTs from configuration tables; control transactions and commit/roll-back; setup alerting; and develop data quality.

 

Work as a team

Matillion ETL for Redshift delivers support for teams with comprehensive version control; live collaboration; and multi-environment & multi-schema support for controlling development, test and production environments.  You can also import and export Matillion jobs between instances, as JSON.

 

 

Cheap.  Billing via AWS

Matillion ETL for Redshift starts from $1.37 per hour with no up-front costs or long-term commitments.  When you move beyond proof of concept and are running 24 x 7, you can choose to purchase an annual subscription to reduce your hourly costs.

Billing is via your existing AWS account, so no new vendor to setup or payment terms to negotiate.  Matillion ETL for Redshift appears in your AWS monthly statement, like any other AWS service.

etl-amazonmarketplace

Simple to deploy and scale

Matillion ETL for Redshift is delivered as an AMI and requires no other infrastructure.  No extra servers or other services needed.

To make Matillion ETL for Redshift scale, you scale the Amazon Redshift cluster – which makes it near linearly scalable.

Enterprise ready

Security

Matillion ETL for Redshift is delivered as an AMI (Amazon Machine Image).  It’s an Amazon Linux instance and you have full root access to it.  You can implement your own security policies, monitoring agents and best practices.  The AMI does not run on or connect back to Matillion systems, it runs securely in your EC2 environment.  The AMI can be deployed into a VPC.

Matillion ETL for Redshift implements encryption and includes a user authentication/security subsystem which can be used standalone or integrated with your Active Directory or LDAP.

Monitoring, Logging and Alerting

Matillion ETL for Redshift delivers a wide range of options around monitoring, logging and alerting – real time and historical.  You can also setup e-mail and text message alerts and integrate with Amazon CloudWatch and/or other monitoring tools of your choice.

Trusted

aws-partner

 

Matillion are an AWS Advanced Technology partner and one of only a handful of AWS Big Data Competency certified software companies in the world.

 

Supported

Free trial, Hourly and Annual customers get great support through Matillion’s support portal at https://redshiftsupport.matillion.com/, where you can raise public questions (monitored by Matillion), access help documentation, view video tutorials and read articles that cover more involved use-cases.  Annual and Free Trial customers can also get in touch by e-mail and phone.

Matillion ships a new release of Matillion ETL for Redshift approximately every 6 weeks. The upgrade process is simple, via AWS Marketplace or directly from Matillion’s public repository.

etl-support

Info

Want to try Matillion ETL for Redshift? Arrange a free 1-hour training session now, or start a free 14-day trial.

 

etl-mac

Customer Success Stories

Don’t just take our word for it, find out more from some of our fantastic Matillion ETL for Redshift customers in our customer success section.

Info

Visit our Customer Success page to find out more