MDL v2.0 (01/04/2022)
  • Dark
    Light

MDL v2.0 (01/04/2022)

  • Dark
    Light

Matillion Data Loader 2.0

(1st April 2022)

Matillion Data Loader 2.0 adds several new capabilities:

  • A new, streamlined user interface for wizard-style creation and management of both Batch and change data capture (CDC) pipelines.
  • Administration functions for saving cloud data warehouse destinations and storing passwords, cloud credentials, and OAuths for easier and faster pipeline creation.
  • The ability to launch Matillion Data Loader straight from the Matillion Hub.

CDC Pipelines

CDC Pipelines created within Matillion Data Loader require the use of CDC agents (containers).

  • CDC Agent installation templates provided, simplify the installation and configuration into supporting on-premise or AWS and Azure cloud environments.
  • Use of Secrets Management applications to host password credentials further secure access to sources.
  • Support for the following CDC pipeline data sources:
    • Oracle
    • PostgreSQL
    • MS SQL
  • Support for the following CDC pipeline destinations:
    • Amazon S3
    • Azure Blob Containers

Batch Pipelines

  • Support for the following Batch pipeline data sources:
    • Amazon Redshift
    • Excel
    • Google BigQuery
    • Google Sheets
    • MariaDB
    • Microsoft SQL Server
    • MySQL
    • Oracle
    • PostgreSQL
    • Salesforce
    • Snowflake
  • Support for the following Batch pipeline destinations:
    • Amazon Redshift
    • Snowflake
    • Google BigQuery