Hitachi Vantara Pentaho Community Forums
Results 1 to 6 of 6

Thread: Export to .dbf file

  1. #1
    Join Date
    Sep 2010
    Posts
    2

    Default Export to .dbf file

    Hello,

    Does anyone know if it is possible to export to a .dbf file in PDI?

    Thanks!

    Deborah

  2. #2
    Join Date
    Jun 2012
    Posts
    5,534

    Default

    One way would be to use the JDBC-ODBC bridge driver, but why should you want to do such a thing ...
    So long, and thanks for all the fish.

  3. #3
    Join Date
    Sep 2010
    Posts
    2

    Default

    Thanks. We use a software here that apparently only accepts .dbf files.

    Sorry, a bit of a newbie, what is the JDBC-ODBC bridge driver?

  4. #4
    Join Date
    Jun 2012
    Posts
    5,534

    Default

    Java applications use JDBC to access databases.
    In most cases the vendor of your database system provides a JDBC driver, too.
    For databases only accessible via ODBC you need a bridge driver.

    In order to write rows to a DBF-file you first must create a database connection, either from the Table Output step or from the Connection Wizard (press F3 in Spoon).
    So long, and thanks for all the fish.

  5. #5
    Join Date
    Mar 2013
    Posts
    24

    Default

    You could also use this project:

    http://code.google.com/p/jdbf/

    and use a javascript step to access it, as explained here:

    http://forums.pentaho.com/showthread...ing-Javascript

    Might be easier than finding an ODBC .dbf driver (I don't know, haven't done this myself).

  6. #6
    Join Date
    Jun 2012
    Posts
    5,534

    Default

    Quote Originally Posted by mooreds View Post
    Might be easier than finding an ODBC .dbf driver
    Well, on a Windows machine it's part of the Desktop MDAC.
    You will never see the bridge driver, it just will be used when configuring a dBase database connection.

    While I would prefer jdbf over javadbf (which already comes with Kettle), I would stick to the visual paradigm with Kettle as long as possible.
    If the creation of an ODBC DSN looks feasible and the bridge driver does prove to be reliable, that is.

    But first of all I would double check, that it's absolutely necessary to produce dBase files 2766 years a.u.c.
    So long, and thanks for all the fish.

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.