Connect to MS Access DB on Linux

Highlighted
One Star

Connect to MS Access DB on Linux

Hi to all,
I can't access to an mdb file on linux.
I've talend 3.2 and 4.0. My OS is Ubuntu 9.10.
When I try to configure the tAccessInput, I get this error when I try to retrieve the tables list:
java.lang.NullPointerException
at sun.jdbc.odbc.JdbcOdbcDriver.initialize(JdbcOdbcDriver.java:436)
at sun.jdbc.odbc.JdbcOdbcDriver.connect(JdbcOdbcDriver.java:153)
at org.talend.core.model.metadata.builder.database.ExtractMetaDataUtils.connect(Unknown Source)
at org.talend.core.model.metadata.builder.database.ExtractMetaDataFromDataBase.testConnection(Unknown Source)
at org.talend.designer.core.ui.editor.properties.controllers.DbTableController.checkConnection(Unknown Source)
at org.talend.designer.core.ui.editor.properties.controllers.DbTableController$5.run(Unknown Source)
at org.eclipse.core.internal.jobs.Worker.run(Worker.java:55)
ERROR: java.lang.NullPointerException
ERROR: java.lang.NullPointerException
java.lang.RuntimeException: java.lang.NullPointerException
at org.talend.core.model.metadata.builder.database.ExtractMetaDataUtils.getConnection(Unknown Source)
at org.talend.core.model.metadata.builder.database.ExtractMetaDataFromDataBase.returnTablesFormConnection(Unknown Source)
at org.talend.designer.core.ui.editor.properties.controllers.DbTableController$5.run(Unknown Source)
at org.eclipse.core.internal.jobs.Worker.run(Worker.java:55)
Caused by: java.lang.NullPointerException
at sun.jdbc.odbc.JdbcOdbcDriver.initialize(JdbcOdbcDriver.java:436)
at sun.jdbc.odbc.JdbcOdbcDriver.connect(JdbcOdbcDriver.java:153)
at org.talend.core.model.metadata.builder.database.ExtractMetaDataUtils.connect(Unknown Source)
... 4 more


There is a tutorial to connect an Access mdb in linux?
Thanks to all and happy new year!
Stefano
Community Manager

Re: Connect to MS Access DB on Linux

Hello
You need install the odbc driver for linux machine.
Download access odbc driver for linux
http://www.easysoft.com/products/data_access/odbc-access-driver/index.html?location=Easysoft%20Data%...
Here is the getting started guide
http://www.easysoft.com/products/data_access/odbc-access-driver/getting-started.html
I install access odbc driver on CentOS5.3 and use tDBInput to read records from a access data source, it works fine.
Best regards
shong
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

Re: Connect to MS Access DB on Linux

I am using TIS Administrator to run jobs in UNIX.
I am also trying to populate access tables with this environment.
Will this driver work for this? Isn't there a free way to get this working other than the not free driver you mentioned?
Thanks for any help on this.
- Bob
One Star

Re: Connect to MS Access DB on Linux

Note: My post is referring to MS Access tables and how to get Administrator working.
- Bob
One Star

Re: Connect to MS Access DB on Linux

Hi Shong, I followed your instructions and could connect to MS Access on Linux, the only problem was the charset, so I got ? instead of special chars.
Is there anyone experienced with this? Can I specify the charset on odbc.ini file?
Thanks a lot.

15TH OCTOBER, COUNTY HALL, LONDON

Join us at the Community Lounge.

Register Now

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

6 Ways to Start Utilizing Machine Learning with Amazon We Services and Talend

Look at6 ways to start utilizing Machine Learning with Amazon We Services and Talend

Blog