Search code examples
jdbcaws-glue

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?


Solution

  • 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/