Al usar AWS re:Post, aceptas las AWS re:Post Términos de uso
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

Temas
AnálisisBase de datos
Etiquetas
AWS GlueExtraer datos de transformación y cargaOracle
Idioma
English
Mayura
preguntada hace un año635 visualizaciones
1 Respuesta
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
respondido hace un año

No has iniciado sesión. Iniciar sesión para publicar una respuesta.

Una buena respuesta responde claramente a la pregunta, proporciona comentarios constructivos y fomenta el crecimiento profesional en la persona que hace la pregunta.

Pautas para responder preguntas

Contenido relevante