I would use the Generic adapter when the datasource is not supported by Denodo Platform or the respective adapter is not present in the adapter list. We recommend to use one of this adapters over the Generic adapter if the datasource is supported.
Each of this adapter knows about the capabilities supported by the datasource, and while using Generic adapter, I would ensure I configure the ‘Source Configuration’, class path and driver details.
You can refer to the [Supported JDBC Data Sources](https://community.denodo.com/docs/html/browse/7.0/vdp/administration/appendix/supported_jdbc_data_sources/supported_jdbc_data_sources) section to get more details.
Hope this helps.