How to connect with ADF to MS access files on Azure VM?

Soni 291 Reputation points Microsoft Employee
2021-04-22T10:23:31.793+00:00

Hello Team,

Would need your inputs. We have MS Access 2000 files on Azure VM, we ADF to extract data from these source files and store on Azure Data Lake.

  1. Do we need to install Self Hosted Integration on Azure VM?
  2. Any specific port needs to be opened?
  3. Any other points to be considered?

Regards,
Soni

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,677 questions
{count} votes

Accepted answer
  1. MartinJaffer-MSFT 26,086 Reputation points
    2021-04-23T01:45:46.567+00:00

    Hello @Soni and welcome to Microsoft Q&A.

    1. Yes you need to install SHIR on the Virtual Machine.
    2. Port 443 Outbound only, according to create-self-hosted-integration-runtime. This may be open by default.
    3. https://learn.microsoft.com/en-us/azure/data-factory/connector-microsoft-access

0 additional answers

Sort by: Most helpful

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.