From Thursday, July, 9, 3:00 PM Pacific,
our Community site will be in
read-only mode
through Sunday, July 12th.
Thank you for your patience.

connect to access database

Highlighted
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)
Highlighted
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.
Highlighted
Six Stars

Re: connect to access database

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

Re: connect to access database

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

Highlighted
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.
Highlighted
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?

Highlighted
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.
Highlighted
Six Stars

Re: connect to access database

could you help me with an example?

Highlighted
Six Stars

Re: connect to access database

NO ONE WHO CAN HELP ME? Smiley Sad

Highlighted
Nine Stars
Nine Stars

Re: connect to access database

Have you tried using the tAccessXXX components?

Highlighted
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.

Highlighted
Nine Stars
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.

Highlighted
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

Highlighted
Nine Stars
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.

Highlighted
Four Stars

Re: connect to access database

You should use mount command to achieve this task.

 

Highlighted
Six Stars

Re: connect to access database

Sorry, What is the command mount?

2019 GARTNER 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

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