Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: SQLite and JDBC

  1. #1
    Join Date
    May 2012
    Posts
    1

    Default SQLite and JDBC

    Hi

    Im a complete newb to PRD, although have used DBs for quite a while (including ODBC connections).

    My query is how I connect to a SQLite database. If I goto

    Data->Add Data Source -> JDBC

    I can add a new connection and SQLite is one of the supported types. However the panel requests standard settings for accessing a server system (e.g. host, name, port, user,pass), yet SQLite is file based.

    What do I need to enter to access a local SQLite file?

    thanks

    mike

  2. #2
    Join Date
    Oct 2011
    Posts
    17

    Default

    Just add the full path, including file name, in the Database Name field. Leave the other fields blank.

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.