Process and .mdb database in Azure Data Factory

Question

Process and .mdb database in Azure Data Factory

Rybecký Pavel 1

Hi,

I would like to process .mdb database files stored on Azure Data Lake in Azure Data Factory. Can someone explain to me how to do this.
I found that we need self-hosted Integration service as prereq, but not sure if I can put Blob SAS URL into connectionString or I need to mount this storage to IS.

Thanks for your help

Regards
Pavel

Answer 1

Samy Abdul 3,016

Hi @Rybecký Pavel , please go through official documentation that discusses access database as source and target. Thanks

https://learn.microsoft.com/en-us/azure/data-factory/connector-microsoft-access?tabs=data-factory

https://learn.microsoft.com/en-us/answers/questions/712307/what-should-be-the-connection-string-in-access-db.html

BhargavaGunnam-MSFT 10,326 Reputation points Microsoft Employee

2022-08-15T21:41:14.76+00:00

Thank you @Samy Abdul

Hi @Rybecký Pavel , I am checking in to see if the above answer from @Samy Abdul helped. And if you have any further questions, do let us know.
BhargavaGunnam-MSFT 10,326 Reputation points Microsoft Employee

2022-08-22T21:15:14.83+00:00
Hi @Rybecký Pavel ,
I am checking in to see if the above answer from @Samy Abdul helped. And if you have any further questions, do let us know.

------------------------------

Please don't forget to click on or upvote button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how

Want a reminder to come back and check responses? Here is how to subscribe to a notification

If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators

Process and .mdb database in Azure Data Factory

1 answer

Activity