In general, the MariaDB is a fork of the MySQL database, so it is recommended to use the **MySQL adapter** while connecting to the MariaDB database, instead of using the Generic adapter. This will save the configuration time, and thereby maximize the delegation capabilities.
So, in order to connect to the MariaDB database from Denodo, I will follow the below steps:
* Create a new JDBC data source, and provide the necessary parameters as below:
* Database adapter: MySQL 5
* Driver class path: mariadb-2.7 (provide the same as available in the **mariadb-2.7** folder).
* Driver class: org.mariadb.jdbc.Driver
* Database URI: jdbc:mariadb//hostname:port
* Next, provide the correct authentication credentials to establish the connection successfully.
* Finally create a base view, to view the expected data residing in the corresponding table.
For more information, you can refer to the section [**JDBC Sources**](https://community.denodo.com/docs/html/browse/8.0/en/vdp/administration/creating_data_sources_and_base_views/jdbc_sources/jdbc_sources) of Virtual DataPort Administration Guide.
Hope this helps!