How to connect from Glue ETL job to Oracle Autonomous Database?

0

Hi all! I need some guidance on the proper way to connect to an Oracle Free Tier Autonomous Database from a Glue ETL Job. I’ve been using the following code snippet, but I encountered an error - “Connection reset by peer.” db_url=“jdbc:oracle:thin:@//adb.eu-frankfurt-1.oraclecloud.com:1521/ga8a15e2c641e7b_bfrceddyo0fopful_low.adb.oraclecloud.com” connection_oracle19c_options = { “url”: db_url, “dbtable”: “docrow”, “user”: “atpc_user”, “password”: “*******“, “customJdbcDriverS3Path”: “s3://abernads-oracle-jdbc-drivers/ojdbc8-21.7.0.0.jar”, “customJdbcDriverClassName”: “oracle.jdbc.OracleDriver”} df_oracle19 = glueContext.create_dynamic_frame.from_options(connection_type=“oracle”, connection_options=connection_oracle19c_options) mTLS is disabled, and network access is confirmed to be okay. Can you help me identify what I might be missing?

AWS
질문됨 3달 전614회 조회
답변 없음

로그인하지 않았습니다. 로그인해야 답변을 게시할 수 있습니다.

좋은 답변은 질문에 명확하게 답하고 건설적인 피드백을 제공하며 질문자의 전문적인 성장을 장려합니다.

질문 답변하기에 대한 가이드라인