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?
you can also try to use ftp to copy the file
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.
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.
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.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Part 2 of a series on Context Variables
Learn how to do cool things with Context Variables
Read about some useful Context Variable ideas