topic Re: Connection MS Access in Talend Studio

Connection MS Access

Anonymous — Sun, 24 Jul 2016 05:21:12 GMT

Hello,

I'm doing an Access data extraction process and saving in MySql, the total size Access file is 250 mb, there are some tables with enough records in it but the table I'm doing this extraction process is well lead has only 6 records something this strange because the extraction of data from Access takes a long time to happen. I made a comparison with the same amount of data between MySQL and Acces, following image.

Access this taking 176,37s to perform this task and which are only 6 records that are in this table, put a comparison with these same 6 records coming from mysql and it took 1,12s. Because the process is so time consuming in Access?

Re: Connection MS Access

Anonymous — Mon, 25 Jul 2016 04:16:50 GMT

Hi,
The row rate of your job is not normal(6 rows in 176,37s ).
From your screenshot, it seems that there is something wrong with your tAccessInput source. What does query look like in your tAccessInput? Have you tried to use tAccessInput-->tlogrow to see if it works well?
Best regards
Sabrina

Re: Connection MS Access

Anonymous — Mon, 25 Jul 2016 23:02:01 GMT

hello, all the queries that I do with Access source are well slow extraction, follows a picture of a table that has 28 records that it took 130 seconds to make the extraction.

The query is quite simple, it is only a select two columns, do not understand why taking so long, when I start the job he is several seconds on with the "Starting" message on the object, it takes about 120 seconds to start the extraction after start until extracts and extract a 1000 lines per second, did a test with extraction in a mysql database and it extracts very fast and draws more lines per second and does not get caught in that starting.

You know what could be causing this?

Re: Connection MS Access

Anonymous — Tue, 26 Jul 2016 09:41:19 GMT

Hi,
What's your access DB version you are using? Have you tried to use other Access source(not BDPERFORMANCE.accdb) to see if it is working well?
Best regards
Sabrina

Re: Connection MS Access

Anonymous — Wed, 27 Jul 2016 00:58:26 GMT

Hi , I'm using Access 2013 , this bank was Access 2003 , was in mbd format, Talend was giving error while reading the file in this format , made his conversion pro accdb and this format the Talend this managing to read the file , however with this delay .

I did a test here craidno a new file with a 100 lines , he read very fast , I did another test saving just a bdperformance table in a separate file and it read well slow the file , I believe that the basis of dbperformance may be in trouble .

Anyway thanks for help.

Re: Connection MS Access

Anonymous — Wed, 27 Jul 2016 10:39:30 GMT

Hi,
This issue should be in your BDPERFORMANCE.accdb file if you can read another access DB file normally by using tAccessInput component.
Best regards
Sabrina