topic Re: connect to access database in Talend Studio

connect to access database

Gabri11 — Sat, 16 Nov 2024 05:12:20 GMT

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

Re: connect to access database

Anonymous — Mon, 22 Jul 2019 14:42:24 GMT

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

Re: connect to access database

Gabri11 — Mon, 22 Jul 2019 14:52:25 GMT

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

Re: connect to access database

Gabri11 — Mon, 22 Jul 2019 14:52:42 GMT

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

Re: connect to access database

Anonymous — Mon, 22 Jul 2019 14:55:12 GMT

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.

Re: connect to access database

Gabri11 — Mon, 22 Jul 2019 15:56:19 GMT

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?

Re: connect to access database

Anonymous — Tue, 30 Jul 2019 15:41:31 GMT

you can also try to use ftp to copy the file

Re: connect to access database

Gabri11 — Wed, 31 Jul 2019 07:32:25 GMT

could you help me with an example?

Re: connect to access database

Gabri11 — Mon, 19 Aug 2019 10:35:02 GMT

NO ONE WHO CAN HELP ME?

Re: connect to access database

JR1 — Mon, 19 Aug 2019 11:29:52 GMT

Have you tried using the tAccessXXX components?

Re: connect to access database

Gabri11 — Mon, 19 Aug 2019 11:39:01 GMT

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.

Re: connect to access database

JR1 — Mon, 19 Aug 2019 11:50:43 GMT

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.

Re: connect to access database

Gabri11 — Mon, 19 Aug 2019 11:56:51 GMT

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

Re: connect to access database

JR1 — Mon, 19 Aug 2019 12:38:12 GMT

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.

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.

Re: connect to access database

moonshadow — Fri, 11 Oct 2019 17:28:15 GMT

You should use mount command to achieve this task.

Re: connect to access database

Gabri11 — Mon, 14 Oct 2019 07:47:50 GMT

Sorry, What is the command mount?