topic Access DataBase as a source? in Talend Studio

Access DataBase as a source?

Anonymous — Sat, 16 Nov 2024 14:38:15 GMT

Is there a way to query from an Access Database? I have tried with the Generic ODBC stage to no avail.
We are trying to convert a large Access Database into Mysql and re-define some data. I thought Talend would be ideal for this, but can't seem to connect to and Access MDB file.

Re: Access DataBase as a source?

Anonymous — Wed, 22 Nov 2006 08:57:31 GMT

Hello,
With Talend you can query from an Access Database, the way is to use the Generic Odbc connexion.
Are you sure that you have defined your Access database in your Windows ODBC Manager (Data source (ODBC)).
The name of your connexion is the DataSource to fill in the Database connection wizard.
If you have a good definition of your database in windows odbc manager, can you explain your problems ?
I you council to test your connection in Metadata > DbConnections > Create connection in Talend (use Check Button), and to use this DbConnection in your future Job.
Regards.

Re: Access DataBase as a source?

Anonymous — Thu, 18 Jan 2007 00:50:51 GMT

With Talend you can query from an Access Database, the way is to use the Generic Odbc connexion.

It would also be great to have a direct tInputAccess thingy ...

Re: Access DataBase as a source?

Anonymous — Thu, 18 Jan 2007 16:36:59 GMT

Hello,
We are currently working about Sybase, and others Databases connection, we will search a direct Access connection as soon as possible.
We don't believe that direct connection will be more fast, because we will give the odbc connection string in this direct connection.
Thank you for your support.

Re: Access DataBase as a source?

Anonymous — Thu, 18 Jan 2007 16:41:15 GMT

Hi,
for me it's not a matter of speed, but one of comfort - I don't want to create and manage ODBC connections for a few dozens of Access databases ...

Re: Access DataBase as a source?

Anonymous — Thu, 18 Jan 2007 17:12:32 GMT

Hi,
There is a solution to make it.
In the DbConnection wizard Datasource field or Database field, you can specify your direct connection as following :
by example for my Access database in my local harddrive : Driver={Microsoft Access Driver (*.mdb)};DBQ=D:\\testFiles\\bd1.mdb
Driver={Microsoft Access Driver (*.mdb)};DBQ= Connection String
D:\\testFiles\\bd1.mdb path of my DB
Thank you for your support.

Re: Access DataBase as a source?

Anonymous — Thu, 18 Jan 2007 17:14:09 GMT

There is a solution to make it. ...

Exactly what I was looking for - thx a lot!