英文:
Azure Data Factory - connect to onprem accdb
问题
我需要使用adf从Access本地数据库检索数据。我在Azure虚拟机上安装了集成运行时。Access数据库位于另一台虚拟机上。我知道在Azure虚拟机上应该有一个路径指向该Access数据库，但该如何操作呢？
英文:
I need to retrieve data from Access onprem database by using adf. I have integration runtime installed on azure vm. Access database is on the other virtual machine. I know that on the azure virtual machine I should have a path to that Access database but how to do that?
答案1
得分: 0
- 要在 Azure 虚拟机上连接 Access 数据库，您应该有一个路径指向该数据库，但如何做呢？
- 要连接本地的 Access 数据库到数据工厂，您需要在该虚拟机上安装 SHIR（Self-Hosted Integration Runtime）。只需为出站流量开放端口 443。这可能默认已开放。
- 集成运行时机器需要安装 Microsoft Access ODBC 驱动程序以用于数据存储。
- Microsoft Access 2016 版本的 ODBC 驱动程序不适用于此连接器。请改用 Microsoft Access 2013 或 2010 版本的 ODBC 驱动程序。
- 在链接服务中选择特定的 SHIR，该 SHIR 托管在特定的虚拟机上。
- 为链接服务属性提供正确的值，如
connectionString、authenticationType。
参考- 使用 Azure 数据工厂从 Microsoft Access 复制数据 遵循此官方文档。
英文:
> I know that on the azure virtual machine I should have a path to that Access database but how to do that?
- To connect on-premises Access database with Data factory you need to install SHIR on that particular Virtual Machine. Only for port 443 outbound traffic. This may be open by default.
- The Integration Runtime Machine needs to have the Microsoft Access ODBC driver installed for the data storage.
> Microsoft Access 2016 version of ODBC driver doesn't work with this connector. Use Microsoft Access 2013 or 2010 version of ODBC driver instead. - In linked service select that particular SHIR hosted on that particular Virtual Machine.
- Provide correct values to the linked service properties like
connectionString,authenticationType.
Reference- Copy data from and to Microsoft Access using Azure Data Factory follow this official document.
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论