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

1 answer

Samy Abdul 3,366 Reputation points

2022-08-12T10:37:44.727+00:00

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
Please sign in to rate this answer.

1 person found this answer helpful.
BhargavaGunnam-MSFT 25,971 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 25,971 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
Sign in to comment