topic Re: Microsoft Access x Talend in Talend Studio

Microsoft Access x Talend

Anonymous — Sat, 16 Nov 2024 07:21:53 GMT

I need to extract from a database access .mdb multiple tables, generating a .csv file for each table and then uploading to an azure blob. For this I used an access -> tFilleOutputDelimited -> tAzureStoragePut connection. Is there a component that can pull multiple tables at once to create multiple .csv files?

Note: The way I'm doing I have to do the same procedure for each table separately.

Re: Microsoft Access x Talend

fdenis — Fri, 02 Nov 2018 09:23:51 GMT

if you have a file with the liste of table to extract.
then use a tFileInput, tFlowToIterate then add iterate Link to RoadShow.
regards,

Re: Microsoft Access x Talend

Anonymous — Sun, 04 Nov 2018 20:50:02 GMT

Thanks for the help, but that still does not solve. I have a .mdb with many tables, where I need to have an output in .csv file, however for each table a .csv file is generated

Re: Microsoft Access x Talend

fdenis — Mon, 05 Nov 2018 13:30:32 GMT

on mdb you must have table liste.
try to use "SELECT * FROM MSysObjects WHERE Type=1 AND Flags=0"
then you will retrieve table liste.

Re: Microsoft Access x Talend

Anonymous — Tue, 06 Nov 2018 17:02:19 GMT

Thank you very much