By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post

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

Topics
AnalyticsDatabase
Tags
AWS GlueExtract Transform & Load DataOracle
Language
English
Mayura
asked a year ago621 views
1 Answer
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
knamburi
answered a year ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions

Relevant content