connect to access database

Six Stars

connect to access database

Hi, I need to connect to a microsoft access database. The problem that talend is installed on a linux machine while the database on a microsoft machine
Does anyone know how I can connect and what string to use?
Thank you

Tags (3)
Nine Stars

Re: connect to access database

Hello
Just to know, are you able to connect to the same access db from your linux computer using another tool?
Regards
DGM
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Six Stars

Re: connect to access database

yes, I use dbveaver on my local windows machine and I can connect (windows-windows)
Six Stars

Re: connect to access database

yes, I use dbveaver on my local windows machine and I can connect (windows-windows)

Nine Stars

Re: connect to access database

Since Talend is on linux machine

I suggest you first try to connect to your access db from linux,
The find out how you can connect using Talend.
Regards
DGM
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Six Stars

Re: connect to access database

The problem is that I can't reach the file from linux to windows. What could the connection string be? Do I have to use smb?

Nine Stars

Re: connect to access database

you can also try to use ftp to copy the file

 

Regards
DGM
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Six Stars

Re: connect to access database

could you help me with an example?

Six Stars

Re: connect to access database

NO ONE WHO CAN HELP ME? Smiley Sad

Nine Stars JR
Nine Stars

Re: connect to access database

Have you tried using the tAccessXXX components?

Six Stars

Re: connect to access database

yes, the problem is that if I connect to the acces database copied to the same machine where it runs talend (linux) then the job works. But if I try to connect to the database access on the windows machine then an error appears.

Nine Stars JR
Nine Stars

Re: connect to access database

The access file is present in a folder shared over the network, correct? Can you access this folder from within linux? The Access connection relies on an accessible  file.

Six Stars

Re: connect to access database

Exactly, could you tell me what is an example of a connection string to insert in talend (tAccess)? thanks a lot

Nine Stars JR
Nine Stars

Re: connect to access database

In e.g. the tAccessConnection component, you do not have to provide a connection string. Simply provide the path & filename to your Access DB and Talend creates the connection string in the background.

Unbenannt.PNG

If you need to provide additional parameters for the connection string, you can add them under "Advanced Settings --> Additional JDBC Parameters".

I hope this helps.

And by the way: you are running your job locally, correct? I.e. it is not built and deployed to a job server.

Four Stars

Re: connect to access database

You should use mount command to achieve this task.

 

Six Stars

Re: connect to access database

Sorry, What is the command mount?

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 2

Part 2 of a series on Context Variables

Blog

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Best Practices for Using Context Variables with Talend – Part 3

Read about some useful Context Variable ideas

Blog