|Run query against dashDB in Excel|
The first step was to enable Java within OpenOffice. The switch can be found under "Tools->Options" in the OpenOffice configuration (see screenshot below). I chose my IBM Java.
|Enable Java for use in OpenOffice/LibreOffice|
Next I added the classpath (Class Path) to my IBM JDBC driver files that are used to access DB2, Informix, and dashDB. A link to download the drivers is offered in the dashDB dashboard/administration console. 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.
|DB2/dashDB JDBC driver archives|
|OpenOffice Database Wizard|
|JDBC Properties for dashDB within OpenOffice|
Once the described configuration is done, the data from dashDB can be used within OpenOffice or LibreOffice. It is possible to build reports in OpenOffice Base, view and use data sources in OpenOffice Calc, and more. The screenshot below shows parts of the sample data available in dashDB. It is the table GOSALES.COUNTRY which holds country names in various languages.
|Sample data from dashDB as seen in OpenOffice Calc|
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. But that would be another blog post.
If you have questions or this was useful, please let me know.