![]() In the following example, we have selected the call_center_dimension table: Select the table you want to query and create a form or report to present the data. The Apache OpenOffice Base home page displays the data in the Vertica data source: Select the options for saving and editing the database, then click Finish. When the connection is successful, click OK.ĭatabase Wizard Step 4. Type your user name and password, then click OK. Type your user name and check Password required, then click Test Connection. In the Data Source dialog box, select the DSN you created for your database (for example, Vertica, as shown below) and click OK.ĭatabase Wizard Step 3. The Apache OpenOffice home page displays.Ĭlick Connect to an existing database and select ODBC from the drop-down list, then click Next.ĭatabase Wizard Step 2. Provide your user name, then click Finish. Installation_Directory\OpenOffice 4\program\sofficeĬomplete the registration of Apache OpenOffice, then click Next. Navigate to the Client Drivers page on the Vertica website.ĭownload the client driver that is compatible with the architecture of your operating system and Vertica server version.Follow the on-screen installation instructions.īefore you can connect Apache OpenOffice Base to Vertica, you must install the Vertica ODBC client driver.Navigate to the Apache OpenOffice Download page.To learn about the Apache OpenOffice project, see the Apache Software Foundation project page. To learn more about using Base, see the Apache OpenOffice Wiki database pages. In enterprise mode, Base includes support for JDBC and ODBC connectivity as well native drivers for a variety of multi-user database engines. You can use Base as a single-user or multiple-user (enterprise) database. Base offers wizards for creating tables, queries, forms, and reports and includes a set of predefined table definitions designed for typical business use cases. Apache OpenOffice includes Base, a desktop database manageent system. Vertica and Apache OpenOffice Base: Latest Versions Tested SoftwareĪpache OpenOffice is an open-source office productivity suite. Connection guides are based on our testing with specific versions of Vertica and the partner product. Vertica connection guides provide basic instructions for connecting a third-party partner product to Vertica. Vertica Integration with Apache OpenOffice Base: Connection Guide About Vertica Connection Guides
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |