Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Kettle and LibreOffice Base

  1. #1
    Join Date
    Jun 2013
    Posts
    2

    Default Kettle and LibreOffice Base

    Hello, is it possible to use Kettle to access a database created with LibreOffice (file with .odb extension)?

    I think LibreOffice Base uses Hypersonic (HSQLDB). So I tried to make a database connection using Hypersonic connection type and Native (JDBC).

    I left the fields Host Name, Port Number, User Name and Password blank. And in the Database Name field I put the path to the .odb file.

    The connection seems to work OK, but in the end it doesn't show any table (only metadata).

  2. #2
    Join Date
    Nov 1999
    Posts
    9,729

    Default

    Usually these OO files are zip files themselves. Did you try to look into it?
    There should be a database folder, the HSQLDB files are probably located in there.

  3. #3
    Join Date
    Jun 2013
    Posts
    2

    Default

    I unzipped the file and tried to view the tables in the database connection explorer and could not make it work.

    I will use SQLite as local database instead, it seems to be much more easier to setup.

    Thanks,

    Guillermo

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.