时间戳

首页 > 解决方案 > 是否可以使用 Matillion ETL 工具将数据从 S3 加载到 SQL Server？

sql-server - 是否可以使用 Matillion ETL 工具将数据从 S3 加载到 SQL Server？

问题描述

是否可以使用 Matillion ETL 工具将数据从 S3 加载到 SQL Server？

标签： sql-serveramazon-web-servicesamazon-s3matillion

解决方案

Matillion ETL can help you to

  • Load data into its supported Cloud Data Warehouse (currently there are five options which are: Snowflake, Amazon Redshift, Google BigQuery, Microsoft Azure Synapse, and Delta Lake on Databricks)
  • Transform and integrate that data inside the Cloud Data Warehouse

MSSQL is not among the list of Matillion ETL supported Cloud Data Warehouses, so you can't use it to directly load data from S3 to MSSQL.

However you could use a Microsoft SQL Server Output component to transfer data into MSSQL, provided it went via one of the above listed supported Cloud Data Warehouses first.

推荐阅读