Skip to main content
Announcements
Introducing a new Enhanced File Management feature in Qlik Cloud! GET THE DETAILS!
cancel
Showing results for 
Search instead for 
Did you mean: 
Gabri11
Contributor
Contributor

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

Labels (2)
15 Replies
Anonymous
Not applicable

Hello
Just to know, are you able to connect to the same access db from your linux computer using another tool?
Gabri11
Contributor
Contributor
Author

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

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

Anonymous
Not applicable

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.
Gabri11
Contributor
Contributor
Author

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?

Anonymous
Not applicable

you can also try to use ftp to copy the file

 

Gabri11
Contributor
Contributor
Author

could you help me with an example?

Gabri11
Contributor
Contributor
Author

NO ONE WHO CAN HELP ME? 0683p000009MPcz.png

JR1
Creator III
Creator III

Have you tried using the tAccessXXX components?