Vertica Integration with Apache OpenOffice Base: Connection Guide

About Connection Guides

Vertica connection guides provide basic instructions for connecting a third-party partner product to Vertica. Connection guides are based on our testing with specific versions of Vertica and the partner product.

Vertica and Apache OpenOffice Base: Latest Versions Tested

Software Version
Partner Product

Apache OpenOffice Base 4.1.6

Desktop Platform

Windows Server 2012 R2

Vertica Client

Vertica ODBC 9.2.0-0

Vertica Server Vertica Database 9.2.0-0

Apache OpenOffice Base Overview

Apache OpenOffice is an open-source office productivity suite. Apache OpenOffice includes Base, a desktop database manageent system. Base offers wizards for creating tables, queries, forms, and reports and includes a set of predefined table definitions designed for typical business use cases.

You can use Base as a single-user or multiple-user (enterprise) database. In enterprise mode, Base includes support for JDBC and ODBC connectivity as well native drivers for a variety of multi-user database engines.

To learn more about using Base, see the Apache OpenOffice Wiki database pages.

To learn about the Apache OpenOffice project, see the Apache Software Foundation project page.

Install Apache OpenOffice Base

  1. Navigate to the Apache OpenOffice Download page.
  2. Click Get OpenOffice.
  3. Follow the on-screen installation instructions.

Install the Vertica Client Driver

Before you can connect Apache OpenOffice Base to Vertica, you must install the Vertica ODBC client driver. Follow these steps:

  1. Navigate to the Client Drivers page on the Vertica website.
  2. Download the client driver that is compatible with the architecture of your operating system and Vertica server version.

    Note  

    For details about client and server compatibility, see Client Driver and Server Version Compatibility in the Vertica documentation.

  3. Double-click the installer and follow the prompts. When prompted to select one or more drivers, select ODBC only.

    Note

    The package provides several drivers, however ODBC is the only one you need. For more details, see The ODBC Client Driver for Windows in the Vertica documentation.

  4. Create a DSN as described in Creating an ODBC Data Source Name (DSN).

Connect Apache OpenOffice Base to Vertica

  1. To start Apache OpenOffice, either click the desktop icon or double-click the executable file in the installation directory:

    Installation_Directory\OpenOffice 4\program\soffice
  2. Complete the registration of Apache OpenOffice, then click Next.

  3. Provide your user name, then click Finish.

    The Apache OpenOffice home page displays.

  4. Click the Database button.

    The Database Wizard opens.

  5. Database Wizard Step 1. Select database:

    Click Connect to an existing database and select ODBC from the drop-down list, then click Next.

  6. Database Wizard Step 2. Set up ODBC connection:

    In the Data Source dialog box, select the DSN you created for your database (for example, Vertica, as shown below) and click OK.

  7. Database Wizard Step 3. Set up user authentication:

    Type your user name and check Password required, then click Test Connection.

  8. Type your user name and password, then click OK.

  9. When the connection is successful, click OK.

  10. Database Wizard Step 4. Save and proceed:

    Select the options for saving and editing the database, then click Finish.

    The Apache OpenOffice Base home page displays the data in the Vertica data source:

  11. Select the table you want to query and create a form or report to present the data.

    In the following example, we have selected the call_center_dimension table:

    The data is displayed as follows:

Known Limitations

  • VarChar data type is supported up to 5459 characters.
  • LongVarChar data type is supported up to 65534 characters.
  • Float and Decimal data types are rounded off to 2 and 1 decimal points recpectively.
  • Milliseconds are ignored in Time and TimeTz data types
  • The lowest date supported in OpenOffice is 01/03/1.
  • Timestamp, TimestampTz, Binary,VarBinary, LongVarBinary and UUID data types are not supported.

For More Information