I would like to inform you that there is a slight correction required for Oracle URL used in dynamic frame creation. Please use URL in below format:
Hello Shubham , Thanks for taking out time . I tried with ORCL and ORCLPDB1 also but still getting issue and getting below mentioned error .
java.io.InvalidObjectException: JDBC connection URL jdbc:oracle:thin:@10.4.0.5:1521/ORCL is not supported. Check the Developer Guide for the list of supported data stores / URL formatting.
: JDBC connection URL jdbc:oracle:thin:@10.4.0.5:1521/ORCLPDB1 is not supported. Check the Developer Guide for the list of supported data stores / URL formatting.
Also I would like to add that instead of using glueContext.create_dynamic_frame_from_options I used spark session to read DB and that is working fine
from pyspark import SparkContext url='jdbc:oracle:thin:@10.4.0.5:1521/ORCLPDB1' user='system' password='root' dbtable='xxgmdmadm.MDM_DNB_MONITORING_DTL' df=spark.read.format('jdbc')\ .option('url',url)\ .option('dbtable',dbtable)\ .option('user',user)\ .option('password',password).load() df.printSchema()
and converting into dynamic frame dy_output = DynamicFrame.fromDF(df, glueContext, "Data")
Using DMS CDC for Oracle to Postgresasked 2 months ago
How to configure Glue Connection to successfuly connect to Oracle RDS Using NNE (Not SSL)asked 4 months ago
Support for RDS Oracle as source while using DMS SCN for CDCAccepted Answerasked 4 years ago
ETL Replication from Oracle to Postgres
Refactoring from Oracle to postgres, Do I need to drop foreign key constraitns at postgres
How to push multi-arch docker image built with docker-compose to ECRasked 8 months ago
Oracle Migration from on-premises using DMS and RmanAccepted Answerasked 2 years ago
One-shot docker containers using Docker composeasked 6 months ago
On AWS RDS for Oracle how to install Oracle Database Gateway for SQL Serverasked 4 days ago
Pyspark Code failing while connecting to Oracle database ----Invalid Oracle URL specifiedasked 2 months ago