Tag Archives: StoredProcedure

Over the last couple of days we’ve mentioned the big link between LibreOffice and OpenOffice, and this link is very close when it comes to its database functionality, because the format of the database is shared between the two suites of programs. It is the .odb extension and we talked about it with previous relevant OpenOffice MySql Import Data Migration Primer Tutorial as shown way below. Yesterday, with LibreOffice JDBC MySql Primer Tutorial as shown below, we delved into interfaces to other proprietary existant database formats via the use of a JDBC database connection, whereas, today, we are using an ODBC database connection to a MySql database, and for today we use an existant local MAMP MySql database as our database source. So, today, here is a tutorial that shows you some database functionality of a great suite of office automation programs called LibreOffice, by The Document Foundation. LibreOffice has functionality like the Microsoft Office suite of programs, bringing the user a lot of the feel of those well loved concepts to your document creation work, and integrated into the one place. Today we do a bit of work that Microsoft Access database might do for you, but in LibreOffice the database functionality uses an ODBC database connection to create a LibreOffice .odf scenario to read and/or write to an existant MySql database. During the course of the tutorial we: Install ODBC to Mac OS X with the help of the download resource here … thanks, Actual Technologies, for the great resource for those Mac users on Snow Leopard & up! Use the resultant new Mac utilities desktop application called ODBC Manager to create the new ODBC connection called CirclePoint to the MAMP MySql database. Open LibreOffice via File->New … Database … Connect to an existing Database->ODBC … CirclePoint connection Create new View to joined records of Circle and Point MySql tables in LibreOffice. Create new Circle and Point table rows using the previously created MySql stored procedure called AddCircle in MAMP’s phpMyAdmin and talked about with MySql Stored Procedures Primer Tutorial. Reopen LibreOffice via File->New … Database … Connect to an existing Database->ODBC … CirclePoint connection to sanity check that these records were added and recognized by the CirclePoint ODBC connection’s newly created View. As you would imagine, LibreOffice has many parts to it, and we will explore some over time, but, as always … Feel free to explore … Continue reading →