question

Soni-9294 avatar image
0 Votes"
Soni-9294 asked KranthiPakala-MSFT commented

ADF to read ms access db files(.mdb) from azure File Share

Hello Team,

Can we leverage ADF to extract the data from .mdb files(Microsoft Access DB), which are stored in Azure File Share.

As per the documentation below link, we need to set Self HIR and install ODBC driver. Can anyone throw some light on configuration that are need to read the files from file share.

connector-microsoft-access




Thanks,
Soni

azure-data-factory
· 6
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @soni-9294,

Thanks for reaching out. If you are looking to copy data from or to Azure File Storage by using Azure Data Factory then please refer to this document: Copy data from or to Azure File Storage by using Azure Data Factory

Do let us know if you have further query.

Thank you

0 Votes 0 ·

Hello @KranthiPakala-MSFT

Thanks for your response. Copying the data from Azure File storage only supports below format. It does not include .mdb files. Any thoughts?

Avro format
Binary format
Delimited text format
Excel format
JSON format
ORC format
Parquet format
XML format


REgards,
Soni

0 Votes 0 ·

Hi @soni-9294,

Could you please confirm if you are looking to copy the file as-is or you would want to read the content of .mdb files? Also please help clarify -> when you say Azure File share - Are you referring to a file share in an Azure VM or Azure File Storage?

Thanks

0 Votes 0 ·
Show more comments
KranthiPakala-MSFT avatar image
1 Vote"
KranthiPakala-MSFT answered

Hi @soni-9294, Thanks for clarifying on the requirement, if it is an Azure VM file share it would have been a bit simpler to achieve, but since your .mdb files are in Azure File storage, I don't think of a way but let me double check with internal teams if there are any workaround to achieve this.

Will get back to as soon as I have an update from the team.

We appreciate your patience.

· 3
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @soni-9294,

Sorry for the delay. I am still awaiting response from internal team. Will keep you posted as soon as I have an update.

Thank you for your patience.

0 Votes 0 ·

Hi @soni-9294,

Apologies for the delay. I'm still waiting for a response from product team on this requirement. Will let you know once I have a response.

Thank you for your patience.

0 Votes 0 ·
JianleiShen-MSFT avatar image
0 Votes"
JianleiShen-MSFT answered KranthiPakala-MSFT commented

hello @Soni-9294 ADF today supports to copy data from Microsoft Access DB directly. In your case, if you store the .mdb file in a storage and try to read the .mdb file, it's not supported. is it possible to copy data from MS Access DB instead in your use case?

· 3
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hey @JianleiShen-MSFT , Thanks for your response.

The customer would like to share these files on Azure File share for further processing in Azure.. Since we do not much control on how customer wants to expose the files, so connecting to their database might not be option.

If not ADF, any other component we can leverage.

0 Votes 0 ·

Hi @soni-9294,

Unfortunately I don't see many options other that writing your own logic/code and use it in Azure Function/custom activity.
One alternate you can give a try by moving those mdb files to a local drive on an Azrure VM try to utilize the existing MS Access ADF connector and see if that helps.

0 Votes 0 ·

Hi @soni-9294,

We still have not heard back from you. Just wanted to check if the above info was helpful, and if you have any further query do let us know.

0 Votes 0 ·