You can translate the question and the replies:

How to connect to MariaDB database?

Hi, I want to know how to connect to MariaDB database from Denodo? I noticed that there is a mariadb jdbc client driver available in the following folder: denodo-platform-8.0/lib/extensions/jdbc-drivers/mariadb-2.7/mariadb-java-client-2.7.1.jar When I try to create a new datasource I need to enter the following values: Database adapter: Generic Driver class path: mariadb-2.7 Driver class: ?? Database URI: ?? I could not find any documentation specific to mariadb database connectivity from Denodo. Could you advise the values which I need to enter in the above fields for the new data source creation. Specifically I would like to know the last 2 parameters: Driver class and Database URI
user
08-03-2022 04:02:57 -0500
code

2 Answers

Hi, 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!
Denodo Team
09-03-2022 01:25:42 -0500
code
Dear Team, there seems to be a typo in above answer. A colon is missing. It should be Database URI "jdbc:mariadb://hostname:port/database_name", Best Georg
user
07-02-2023 08:38:21 -0500
You must sign in to add an answer. If you do not have an account, you can register here