Hitachi Vantara Pentaho Community Forums
Results 1 to 6 of 6

Thread: borland Paradox

  1. #1
    Join Date
    Mar 2009
    Posts
    26

    Default borland Paradox

    hi :-)


    i have some files with borland Paradox format :

    <snip>urls</snip>


    does Sb know whether Kettle is able to read them or not ?
    Last edited by sboden; 03-24-2009 at 06:48 AM.

  2. #2
    Join Date
    May 2006
    Posts
    4,882

    Default

    Paradox is not in the list of supported databases... However if you have a decent JDBC driver for paradox you can make it work via "Generic Driver".

    Regards,
    Sven

  3. #3
    Join Date
    Mar 2009
    Posts
    26

    Default

    Quote Originally Posted by sboden View Post
    Paradox is not in the list of supported databases... However if you have a decent JDBC driver for paradox you can make it work via "Generic Driver".

    Regards,
    Sven
    ok,
    i don't have sth like that

  4. #4
    Join Date
    May 2006
    Posts
    4,882

    Default

    From the internet:

    pdxJDBC is a JDBC driver for Paradox tables that comes with Paradox 9. It is part of the jPdox Web Utilities, so you must run the separate InstallAnywhere-based installion to get it. pdxJDBC supports JDK 1.2. Documentation is in the form of a PDF version of the jPdox Web Utilities book.
    It comes with your paradox installation.

    Regards,
    Sven

  5. #5
    Join Date
    Mar 2009
    Posts
    26

    Default

    Quote Originally Posted by sboden View Post
    It comes with your paradox installation.

    Regards,
    Sven
    in fact i have no paradox installation,

    we use software from isagri http://www.isagri.fr/
    and they use the paradox format internally

    there is no problem as long as we use only software from isagri and we needn't to put some data out of this "circle"

    but, to make a data warehouse, we need an ETL which is able to read directly this format
    (software from isagri does only accounting and management, no DB management or anything like that)


    what about make a component "on demand" ?
    what is the risk for have this component not working with future versions of pantaho ?

  6. #6
    Join Date
    May 2006
    Posts
    4,882

    Default

    Quote Originally Posted by Thomas View Post
    what about make a component "on demand" ?
    what is the risk for have this component not working with future versions of pantaho ?
    You can't make a JDBC driver ... you can, but it would take an awful lot of time. So you just need to get one from Paradox (or another company) if you want to read their database files. For some databases you have an open source JDBC driver or a redistributable version available, haven't seen a free one yet for Paradox.

    Regards,
    Sven

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.