Libreoffice Calc Mysql

Posted onby admin
Libreoffice calc tutorial pdfLibreoffice Calc MysqlMysql

Libreoffice Calc Mysql Connector

LibreOffice Base is an open source RDBMS (relational database management system) front-end tool to create and manage various databases. Preparing the ODBC Connection. First, make sure to prepare MariaDB Connector/ODBC as explained in MariaDB Connector/ODBC. That includes: Download the latest MariaDB Connector/ODBC; Copy the shared library libmaodbc.so to /usr/lib/multi-arch. 2) On a Mac operating system, go to LibreOffice Preferences General on the main menu bar to open the dialog for general options. 3) Select Use LibreOffice dialogs in Open/Save dialogs and, in Linux and Mac OS X operating systems only, Print dialogs to display the LibreOffice dialogs on your computer display. To connect to an ODBC data source from OpenOffice or LibreOffice using our driver for MySQL, perform the steps below: Start OpenOffice or LibreOffice, click Database to open the Database Wizard. Alternatively, you can launch the Database Wizard from OpenOffice or LibreOffice Calc, Writer or any other tool by choosing File New Database. The LibreOffice Base window will open with your database ready to use. Creating a report. From the main window, click on the Reports icon in the left navigation (Figure B), and then click the Use.

Libreoffice Calc Odbc Mysql

Tutorials‎ > ‎

LibreOffice Base: Connect to any kind of database

Although LibreOffice Base works with hsqldb (*.odf) files by default, you can, in fact, use it as a common GUI tool to connect to any kind of database, all you need is the right JDBC driver to do the job. Here is how you do it:
Open LibreOffice main app (with white icon), go to Tools->Options->Libre Office->Advanced and on the right-hand side, click the Class Path button on the right-side of the dialog:

In the dialog that comes up, add the path to your JDBC driver jar files (for example, sqlite-jdbc-3.7.2.jar) for whatever databases you want to connect. In a section below, I'll list down where to get these JDBC drivers for all kinds of databases.
Once this is done, click OK and exit from this configuration dialog, and then click File->New->Database. Select 'Connect to an existing database' radio button, and then select JDBC from the dropdown. Click Next and then enter the connection parameters and JDBC Driver class as shown below:

Click the 'Test Class' button to ensure that everything is good, and in the dialog that comes next, also test the database connection. After that, just file this new database which will be just a link to your actual database, and you are good to go! You can thus use LibreOffice Base as a proper GUI client tool (such as Toad or SQLDeveloper) to connect to just about any kind of database. The only condition is that the Java JDBC driver is available for that database (and it usually is, since Java is a widely used programming language).
Here is where you can obtain JDBC drivers for popular databases:
SQLite:
https://bitbucket.org/xerial/sqlite-jdbc
http://www.ch-werner.de/javasqlite/
MySQL:
https://dev.mysql.com/downloads/connector/j/
MariaDB:
https://mariadb.com/kb/en/mariadb/about-mariadb-connector-j/
MongoDB:
https://docs.mongodb.com/ecosystem/drivers/java/

Microsoft SQL-Server:
https://msdn.microsoft.com/en-us/library/mt484311(v=sql.110).aspx
Microsoft Access:
http://ucanaccess.sourceforge.net/site.html (Also refer to this)
Oracle:
http://www.oracle.com/technetwork/apps-tech/jdbc-112010-090769.html


References:
http://stackoverflow.com/questions/14640907/where-to-download-sqlitejdbc
http://askubuntu.com/questions/10635/how-can-i-install-sqlite-to-be-used-with-openoffice
http://askubuntu.com/questions/276725/how-do-i-get-libreoffice-base-to-access-ms-access-2003-data