![]() See more in the CONNECT - Files Retrieved Using Rest Queries article. In order to do so, we have to enable the CONNECT storage engine plugin and start with REST_API. Let’s say we create a table using the REST API from JSON data from, and another table using the same mechanism from, and let’s call them webposts and webusers. "Tables" window - shows list of tables that are created.Īs we can see, there are system tables in the “mysql” database as well as “test” database.When “Tables” is selected, the options are: "Tasks window (dependent on what is selected in the “Database” window).In this example, we will save as “fosdem21_mariadb.odb”. Registration in this sense means that the database is viewable by other LibreOffice modules (like LibreOffice Calc and LibreOffice Writer). ![]() Provide a user name (and password if needed) and again check the connection (with the “Test Connection” button) and click “Next”:Īfter that, we have options to register the database. In order to connect to a running MariaDB server, choose “Connect to an existing database” and choose “ODBC” driver as shown below:Īfter that, choose DSN (the one that we created in the previous step) and click “Next”: The default option is to create a new database, which is HSQLDB. Start Libreoffice Base from the terminal by running lobase (make sure to install the libreoffice-base package if needed). Verify successful installation also using the isql utility, for example:.Verify successful installation in the /.odbc.ini file. ![]() Odbcinst -i -s -h -f MariaDB_odbc_data_source_template.ini A sample “MariaDB_odbc_data_source_template.ini” could be:
0 Comments
Leave a Reply. |