CODEWITHSUNDEEP
jdbcaws-glue
Joschua Xner
Joschua Xner

Reputation: 115

Database connection failed with JDBC to SAP Hana

I'm currently trying to test a JDBC connection to SAP Hana with AWS Glue.

Testing the connection results in the following error message:

com.amazonaws.glue.jobexecutor.commands.exception.CommandExecutorException: java.lang.IllegalArgumentException: No enum constant com.amazonaws.glue.jobexecutor.commands.jdbc.SupportedDriver.SAP

My JDBC URL looks like that jdbc:sap://ip:port/?databaseName=tdb

After looking in the developer guide from AWS for the JDBC Connection Properties, it looks like that required protocol for hana is not a supported right now.

So is this the case that you currently can't connect to a SAP Hana database with AWS Glue or am I missing something in my connection configuration?

Upvotes: 0

Views: 1529

Answers (1)

breadcrumb42
breadcrumb42

Reputation: 225

The HANA JDBC driver seems not to be supported at the moment. AWS describes a way via S3, that, depending on your requirements might be enough for you:

https://aws.amazon.com/de/blogs/awsforsap/extracting-data-from-sap-hana-using-aws-glue-and-jdbc/

Upvotes: 1

Related Questions