1) 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.
Then choose to connect to an existing database and select the ODBC option in the database connection type selector, then press Next.
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.
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.
Press NEXT >> and you will be prompted to save your connection.
Choose a location and file name and 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.
Now you can create some SQL queries.
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…