Apache openoffice vs libreoffice 2015 drivers#
Apache openoffice vs libreoffice 2015 driver#

Dealing with DB2 Security and my Stupidity.More closely aligned with Microsoft Office applications.Using dashDB or DB2 with Apache OpenOffice (or Lib.My DB2 pureScale / Parallel Sysplex Moment.Bluemix: Combining the Cloud App with my On-Premis.If you have questions or this was useful, please let me know. With the work of connecting OpenOffice and dashDB done, I can now dive deep into building dynamic database reports or use result set from SQL database queries for my spreadsheets. Sample data from dashDB as seen in OpenOffice Calc It is the table GOSALES.COUNTRY which holds country names in various languages.

The screenshot below shows parts of the sample data available in dashDB. It is possible to build reports in OpenOffice Base, view and use data sources in OpenOffice Calc, and more. Once the described configuration is done, the data from dashDB can be used within OpenOffice or LibreOffice. By adding the JDBC property to the URL so-called 'asensitive' cursors are used and OpenOffice works well with dashDB on Bluemix. While accessing some database tables I ran into sqlcode -243 (SQL00243N). Highlighted in the picture above is a part of the Datasource URL which reads ' cursorSensitivity=2 '. JDBC Properties for dashDB within OpenOffice Using the 'Test Class' button I made sure that OpenOffice can load that class.

Apache openoffice vs libreoffice 2015 driver#

As can be seen in the picture below, the JDBC driver class needs to be specified. The information to be entered can be found in the dashDB web interface in the 'Connection Settings' screen. The Datasource URL is the based connection string up to the database name. This is where the JDBC connection string, the user name, and options can be entered. In order to access dashDB you have to pick 'Connect to an existing database' and JDBC as the technology.Īfter pressing 'Next' in the wizard the most important configuration dialog shows up. This opened up the OpenOffice Database Wizard as shown below. For it I clicked on 'File->New->Database' in the OpenOffice Menu (e.g., from within Calc). Now it was time to configure the database connection to dashDB itself. Once I was done, I needed to restart OpenOffice to pick up the new configuration. Within the classpath menu is the option 'Add Archive' which I chose to add the files db2jcc.jar, db2jcc4.jar and db2jcc_license_cu.jar to my OpenOffice environment.

Apache openoffice vs libreoffice 2015 drivers#

A link to download the drivers is offered in the dashDB dashboard/administration console. Next I added the classpath (Class Path) to my IBM JDBC driver files that are used to access DB2, Informix, and dashDB. I chose my IBM Java.Įnable Java for use in OpenOffice/LibreOffice The switch can be found under 'Tools->Options' in the OpenOffice configuration (see screenshot below). The first step was to enable Java within OpenOffice. So why not try to hook up the cloud-based dashDB and my local OpenOffice? This can be done using a JDBC connection. ODC (Office Data Connection) files are not supported (yet) by OpenOffice and LibreOffice, but the programs offer the component 'Base' as database (front-end) similar to Microsoft Access. I got curious because my Linux machine only has Apache OpenOffice installed. That button shows up in the web-based query interface where you can compose SQL queries and execute them against the dashDB database. When I played with dashDB, a fully managed data warehouse service, I came across the 'Run Query in Excel' button. Here are the details of my evening activity. :) I ended up fiddling with dashDB on Bluemix and building reports with my local OpenOffice. Why not surf in the Internet? That's why there are services like YouTube or Bluemix where you can spend hours without too much thinking. Yesterday evening, I had some time on my own and didn't want to read.