从Redshift提取数据 [英] Pull data from Redshift

问题描述

我们想将数据从Redshift数据库中提取到SQL Server中.当前，我们正在使用SQL Workbench分析Redshift数据库.我们引用了以下链接-

We want to pull data from Redshift database into SQL Server. Currently, we are using SQL Workbench to analyze Redshift database. We referred the following link -

使用SQL Workbench连接集群

我们在这里使用-RedshiftJDBC41-1.1.17.1017驱动程序进行连接. 现在，我们想将此数据推送到SQL Server 2016中的DWH.

Here we used - RedshiftJDBC41-1.1.17.1017 driver to connect. Now we want to push this data to DWH in SQL Server 2016.

那么实现这一目标的最佳方法是什么?网上没有太多有关如何从Redshift提取数据的信息.

So what is the best way to accomplish this? There is not much information on net on how to pull data from Redshift.

我们可以在SSDT/SSIS2015中使用SSIS组件或某些东西来加载此数据吗?

Can we have SSIS component or something in SSDT/SSIS2015 to load this data?

还是我们可以在任何工具(任何ETL工具或Excel)的中间层将这些Redshift数据转储为CSV或在SSIS中可读的东西?

Or can we have a middle layer of any tool (any ETL tools or Excel) which will dump this Redshift data into CSV or something which will be readable in SSIS?

推荐答案

可以提取来自Amazon Redshift的数据，然后将其加载到几乎任何平台上.

Data from Amazon Redshift can be extracted and consequently loaded into almost any platform.

您有几种选择将数据从Redshift移到SQL Server.

You have several options to move data from Redshift to SQL Server.

1. ETL工具-您可以使用商业ETL工具. SSIS是一个 从Redshift提取并着陆的完美合法方法 SQL Server中的数据.
2. S3文件-您可以将数据从Redshift卸载到S3存储桶和 然后使用SSIS或bcp将数据桶中的数据复制到SQL Server
3. 本地文件系统-您可以运行unload命令提取数据 到本地文件系统.您可以在服务器中本地运行psql 在您的网络内部.

1. ETL Tool - You can use a commercial ETL tool. SSIS is a perfectly legitimate way to extract from Redshift and to land the data in SQL Server.
2. S3 Files - You can unload the data from Redshift into S3 buckets and then use SSIS or bcp to copy data from buckets to your SQL Server
3. Local file system -- You can run the unload command to extract data to local file system. You can have psql running locally in a server inside of your network.

有关如何连接SSIS和任何其他Redshift的ETL或BI工具，请参见此链接.

这篇关于从Redshift提取数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！