All geek questions in one place

AWS Data Stream Support for SQL Server RDS

I am trying to find documentation regarding a supported data source for AWS Data Pipeline. What I need to do is export SQL Server RDS data to S3. I find a lot of documentation saying that the Data Pipeline can use RDS as a source, but every example that I see is for MySQL RDS only.

Does anyone have experience with Data Pipeline and SQL Server RDS? If so, what node data do you use to connect to SQL Server RDS (for example, MySqlDataNode, SqlDataNode)?

The ultimate goal is to move data from SQL Server RDS to AWS Red Shift.

thank

+4
source share
2

Data Pipeline . ETL . - Windows-, SSIS, , , Pentaho Talend.

, ASCII? SQL Server UTF16-LE UTF8 . (http://blog.joeharris76.com/2013/09/migrating-from-sql-server-to-redshift.html).

+1

, , MySQL RDS.

, EMR sqoop. sqoop s3 Redshift COPY ( ).

EMRResource. , sqoop master jdbc.

EMRActivity, , jar, sqoop script . , . , ShellCommandActivity EMRResource?

0

Source: https://habr.com/ru/post/1534364/

More articles:


All Articles