openofficelogo1) Download and Install Open Office from the Apache Open Office website.

2) If you haven’t already set-up the PostgreSQL ODBC driver to connect to the deltaDNA data warehouse, follow the sets in the Postgres ODBC Connection Guide

3) Connect to your data.

Start Open Office and select File >> New >> Database from the menu in the Open Office launcher.

newDB

Then choose to connect to an existing database and select the ODBC option in the database connection type selector, then press Next.

selectdatabase

Press the Browse button on the set-up connection page and choose the data source (DSN) that you created earlier in the Postgres ODBC Connection Guide, then press Next.

dataSource

The next step in the Wizard will ask you to confirm your User name. Populate the User name with the username you use to login to deltaDNA.net and check the Password Required option and press Test Connection.

username

test

The Windows version of Open Office is a 32-bit application, it requires you to install the 32-bit version of the PostgreSQL driver and set-up your DSN using the 32-bit ODBC Data Source Administrator tool. If you get an error when you test your connection, but your connection tested successfully when you set-up your DSN, it is likely to be because you have installed 64-bit driver. 

success

Press NEXT >> and you will be prompted to save your connection.

OpenOffice-save

Choose a location and file name and Save.

save

4) Run some queries.

Now when you launch the Open Office database program you will be able to select the database connection that you created above. When you open a connection you will see 4 tables, an Events and Users table for each of your environments DEV and LIVE.

tables

Please do not drag whole tables into the worksheet, or use SELECT * like queries. These will attempt to retrieve all data from your table, this will naturally fail if you have a large data set. Always use a LIMIT e.g SELECT * FROM events_live LIMIT 100;  or design your queries to return a limited number of rows.

Now you can create some SQL queries.

OpenOffice-data

NB: You may need to toggle the “Run SQL command directly” button to “ON”.

You can now save your query and use it to drive Spreadsheets etc…

chart