Talend to Glue migration

0

Customer using Talend for ETL and Postgres as DWH. They are looking to migrate ETL workload on to Glue ETL and DWH on Redshift. They want to know how to implement the following use cases with AWS Glue:

  1. Extracting data from MS Excel in Glue jobs for further processing.
  2. Extracting data from SharePoint. Currently they use Apigee between SharePoint and Talend.
  3. Data Lineage
  4. Sending email with count of processed/rejected records to Admin when jobs complete or fail.

Please provide your inputs on how to implement above use cases with Glue. Any reference information, learning related to Talend to Glue migration will really help. Thanks.

질문됨 4년 전903회 조회
1개 답변
0
수락된 답변

This seems like relatively light load use case, in that case, this all can be implemented within pure-Python libs with Python Glue Shell.

  1. Use python libs for excel to extract/process data from excel files.
  2. Use python REST API for Sharepoint to extract Sharepoint data.
  3. Append columns to track source for data lineage.
  4. Get processing counts and sent data over SNS after processing
AWS
Vivek_S
답변함 4년 전
profile picture
전문가
검토됨 2달 전

로그인하지 않았습니다. 로그인해야 답변을 게시할 수 있습니다.

좋은 답변은 질문에 명확하게 답하고 건설적인 피드백을 제공하며 질문자의 전문적인 성장을 장려합니다.

질문 답변하기에 대한 가이드라인