Glue connection Oracle JDBC URL with TNS

Question

Hello,

On premise my Pyspark application is using JDBC URL = "jdbc:oracle:thin:@(DESCRIPTION =(LOAD_BALANCE=off)(FAILOVER=on)(ADDRESS = (PROTOCOL = TCP) (HOST = my1.service.net) (PORT = 1521))(ADDRESS = (PROTOCOL = TCP) (HOST = my2.service.net) (PORT = 1521))(ADDRESS = (PROTOCOL = TCP) (HOST =  my3.service.net) (PORT = 1521))(CONNECT_DATA =(SERVER = dedicated)(SERVICE_NAME = my.service.net)))"

However, if I am trying to create glue connection with this URL I am getting error: URL is not supported. Check the Developer Guide for the list of supported data stores / URL formatting.

is it possible to use such formatting with GLUE? If not how can I overcame this limitation?

Thank you.

Accepted Answer

You are right, GlueContext doesn't recognize that Oracle tns format, I'll report it to the team.   
In the meanwhile, you can read using spark.jdbc(), and then convert to DynamicFrame if you need to.

If you accept losing the failover capability, you can convert the url to the standard format, keeping just one server, e.g.:
 jdbc:oracle:think:@//my1.service.net:1521/my.service.net

Glue connection Oracle JDBC URL with TNS

Relevant content