Unsupported jdbc driver classname with com.ibm.as400.access.AS400JDBCDriver

[javicamarababel]

Hello

I am trying to create a Glue Crawler using JDBC driver jt400-20.0.7.jar (obtained from https://mvnrepository.com/artifact/net.sf.jt400/jt400), and getting error "Unsupported jdbc driver classname" . This was reported also for AWS Advanced JDBC Driver, and apparently the problem is Glue doesn't support all JDBC drivers.

I also tried to manually creating a job using the custom JDBC Connection, and it failed, and I think the root failure was “WARNING - Glue ETL Marketplace - Connection my connection name is not a CUSTOM or Marketplace connection, skip jar downloading for it”.

Could you please confirm whether is possible to use Glue with any JDBC Driver, such as this DB2 one? Or is Glue limited to a handful of supported JDBC Drivers?

Thanks and best regards

[javicamarababel]

Hello again

It seems that:

• You can use only a limited set of supported JDBC drivers with AWS Glue, more or less listed here. Contrary to what the superficial documentatioon says, Glue will not work with every JDBC driver .
• If your driver is not supported, you need to use a Glue-specific connector for it; you can either by it from AWS Marketplace, or you can build it by yourself in Java.

Therefore, the answer to ny original question is that Glue is limited to a handful of supported JDBC Drivers.

Thanks and best regards