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

Oracle Glue crawler is not adding table to database

0

Hi, I'm trying to setup an integration between Oracle and MySql via Glue. While the Sql crawlers I created have added tables into the Glue database, the Oracle crawler does not. Run is successful and log says BENCHMARK : Finished writing to Catalog What am I doing wrong?

Topics
AnalyticsDatabase
Tags
AWS GlueDatabase
Language
English

asked 3 years ago938 views

2 Answers
0

Hi,

Have you specified the right SID in the JDBC url ?

answered 3 years ago

0

Can you give more details? In glue documentation it's mentioned to use the following rule:

"Oracle Database and MySQL don’t support schema in the path; instead, enter MyDatabase/% "

So for example, try:

Servicename/% on the Include path inside your crawler.

AWS

answered 3 years 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.

Relevant content