Hitachi Vantara Pentaho Community Forums
Page 1 of 2 12 LastLast
Results 1 to 10 of 13

Thread: How connect to ms access mdb starting from a linux server

  1. #1

    Default How connect to ms access mdb starting from a linux server

    Dear all,

    I got the needing to connect to a mdb database located on a remote xp server .
    I have to daily read data from access db and update a mySQL database located on Linux server.
    Im not a technician and probably it's a stupid quesion ... ;-)
    Is it possible ?
    If yes, Can you suggest me how ??
    Many thanks
    Giovannino

  2. #2
    Join Date
    Oct 2010
    Posts
    369

    Default

    create odbc connection for ms-access in windows from datasource-odbc and use this connection from PDI.

  3. #3

    Default

    Hi Lal,
    when you define a new ms access connetion there is only the ODBC DSN Source Name.
    How can it understand that the ODBC driver is located on the remote XP Server ?
    Don't you need also a server address ??

  4. #4
    Join Date
    Oct 2010
    Posts
    369

    Default

    you need to define ODBC on your server machine once added no driver required just access by creating a normal connection in PDI with ODBC as connection type

  5. #5

    Default

    Sorry for my ignorance. But within Linux server is it possible to create an ODBC driver ?

  6. #6
    Join Date
    Oct 2010
    Posts
    369

    Default

    yep unixodbc drivers are there check some of the documentation on that.

  7. #7

    Default

    Hi, thanks
    Just to be sure to have understood. So, using unixodbc driver, I can create a connection to a remote XP Server mdb file.
    If true is ... wonderful !!!
    Thank again

  8. #8

    Default

    I've just checked but the cost of a license is about 499$ ...... WOW !!!
    Any alternative under OS environment ??? It's really too much for the use I've to do.

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

    Default

    unixODBC is a driver manager - you'll have to bring a Linux ODBC driver for MS Access.
    Next thing is to install a decent JDBC-ODBC bridge driver.
    JRE8 comes without bridge driver.
    You may have luck using the out-dated Sun bridge coming with JRE7 and earlier (end of support April 2015, though).

    A more promising approach could be to install MS SQL Server Express on the Windows machine, add the Access database as a linked server, and use a JDBC database connection for the Table-Input step.
    Didn't try this yet, though.
    So long, and thanks for all the fish.

  10. #10
    Join Date
    Apr 2008
    Posts
    4,690

    Default

    Quote Originally Posted by Giovanni View Post
    I have to daily read data from access db and update a mySQL database located on Linux server.
    So why not use the Access Input step, and a Table Output?

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.