Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: Linux, UnixODBC and MDBTools

  1. #1
    Join Date
    Sep 2005
    Posts
    1,403

    Default Linux, UnixODBC and MDBTools

    Hi,

    We need to connect to a MS Access database from a Linux platform.
    I've installed UnixODBC and MDBTools and tested the setup to make sure I can connect to the database and it all works fine. What I am having problems with though, is connecting to the ODBC source from Spoon.

    Is it possible to connect to a UnixODBC database using Spoon, and if so can anyone give me some pointers?

    The error message that spoon is kicking out is 'Error occured while trying to connect to the database'

    Many thanks,
    Ryan

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

    Default RE: Linux, UnixODBC and MDBTools

    Ryan,

    ODBC is supported through the jdbc2odbc bridge from the Java VM (from Sun).
    This is a pure java implementation and I doubt this will work with unixODBC.

    I can't find a reference for Linux on http://java.sun.com/j2se/1.4.2/docs/...ridge.doc.html

    Perhaps there is a UnixODBC to java bridge available somewhere that we can implement?

    Good luck,

    Matt

    P.S. Why not transfer the data from the windows platform to a MySQL database on Linux?

  3. #3
    Join Date
    Sep 2005
    Posts
    1,403

    Default RE: Linux, UnixODBC and MDBTools

    Hi Matt,

    Thanks for the quick reply.

    The access database is part of a production system so unfortunately we can't move it.
    What we want to do is to be able to do periodic transfers of the data to MySQL so we can use the data for reporting etc.

    I'll have a look for a UnixODBC to java bridge and see if that turns up anything.

    Thanks,
    Ryan

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

    Default RE: Linux, UnixODBC and MDBTools

    Ryan,

    Here is an encouraging message:

    http://mail.easysoft.com/pipermail/u...ch/000444.html

    Unfortunately, the required JDBC-ODBC bridge is not free but sold by "easysoft" (!) for US$999.00.
    Note: that's more then the SAP client for Kettle :-((

    Mmm, keep looking. Then again, if the free trial works for you and you want to pay the price...

    Cheers,

    Matt

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.