Can AWS Glue read data from on-prem Oracle views?

0

Hi, We are using Glue to read data from on-premise Oracle DB table. The table is large and has 40+ columns. We are interested in data from only 3 columns. Does AWS Glue support reading from Oracle views? Has anyone tried and tested it? Please assist

Mayura
질문됨 일 년 전635회 조회
1개 답변
1

Hello, Glue Can read objects from any data source that support JDBC connection, following pre-requisites are required: 1) Connectivity is setup between datasource and AWS/VPC and a Security Groups is configured with access 2) A Glue JDBC connector configured with VPC, Subnet, Security Group that has access to datasouce

If you would like to bring on-prem data to AWS, AWS DMS is a great option which also has support for CDC. Following link can help you with the use-case. https://aws.amazon.com/premiumsupport/knowledge-center/migrate-db-dms/

AWS
답변함 일 년 전

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

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

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

관련 콘텐츠