Redshift Archives - Cloud Data Integration Software | Matillion
s3-put-object-matillion-redshift

Using the S3 Put Object component in Matillion ETL for Amazon Redshift

The S3 Put Object presents an easy-to-use graphical interface, enabling you to connect to a remote host and copy files to an S3 bucket. This can be used to...

couchbase-data-matillion-etl-for-redshift

How to load data from Couchbase into Amazon Redshift using Matillion ETL

Couchbase Server, originally known as Membase, is an open-source, distributed multi-model NoSQL document-oriented database software package that is optimized for interactive applications. These applications may serve many concurrent users...

google analytics connector matillion etl amazon redshift

Tracking your customer journey using the Google Analytics connector

Matillion uses the Extract-Load-Transform (ELT) approach to delivering quick results for a wide range of data processing purposes: everything from customer behaviour analytics, financial analysis, and even reducing the...

matillion data quality framework

Matillion Data Quality Framework

When you’re using Matillion to build data processing jobs, you are acting as a data consumer. There are upstream systems (probably many) in which primary producers are actively creating...

matillion etl paging data

A Case for Paging

In this article we will discuss Paging in the context of a REST API and how Matillion can help you download data from your REST APIs as manageable chunks,...

ELT lie Matillion

The “ELT lie” and how to get real benefit from ELT architecture

Here at Matillion we have a breadth of customers, from startups to large enterprises, all taking advantage of the Extract-Load-Transform (ELT) approach for delivering quick results. They are using...

volkswagen-matillion-etl-redshift-r

Matillion uses R integration to investigate Volkswagen

A few years ago Volkswagen were famously caught using defeat devices to influence emission testing. They undertook a technical intervention inside the engine of every affected vehicle to stop...

NRT Replication In Amazon Redshift

Amazon Redshift offers a fast and scalable data processing platform at around 1/10th the cost of a typical equivalent on-premises solution. This makes it perfect for integrating multiple different...

new-features-1-25-3

What’s new in Matillion ETL for Redshift, version 1.25.3?

The latest release of Matillion ETL for Redshift, version 1.25.3 includes a whole host of enhancements, new functionality and new components to make Matillion ETL for Redshift better than...

matillion-etl-elt-diagram-blog-01

Better, faster, smarter: ELT vs. ETL

Is it a typing mistake? That’s a typical reaction from many data professionals familiar with the acronym ‘ETL’—short for ‘Extract, Transform and Load’—when they first encounter the subtly-different acronym...