在Azure数据工厂中创建新的链接服务时遇到问题 [英] Problem creating a New Linked Service in Azure Data Factory

问题描述

我正在尝试在Azure数据工厂中创建新的链接服务.

I'm trying to create a new linked service in Azure Data Factory.

1-"Microsoft Integration Runtime"；已经安装并且在诊断"中具有成功的完整测试.使用ODBC到Oracle 11g 64位数据库.连接测试成功完成.

1- "Microsoft Integration Runtime" is already installed and with succesfull test in "Diagnostics" with ODBC to an Oracle 11g 64-bit Database. The connection test resulted sucessfully.

2-在AzureDataFactory中，在集成运行时中，类型为自托管".并且状态为正在运行".

2- In AzureDataFactory, in the Integration Runtimes the type is "Self-Hosted" and the status is "Running".

有了这个，我想说的是，从内部部署的角度来看，我认为一切都很好.

With this, I'm trying to say that I think everything is OK from the on-premise point of view.

但是，当我尝试创建新的链接服务时，我选择了"ODBC"，一旦我填写了表格，并且按下了测试连接，就会出现以下错误:

However, when I try to create a new linked service, I choose "ODBC", once I fill the form, and I push in test connection I get the following error:

连接失败

错误:找不到状态为404的URL:https://s2.datafactory.ext.azure.com/api/V2query2/EncryptData

Error: Response with status: 404 not found for URL: https://s2.datafactory.ext.azure.com/api/V2query2/EncryptData

我不知道该怎么办.

-----

目的是将数据从本地Oracle数据库复制到云中.我已经安装了64位Oracle Client 11g.我已经在Windows中配置了ODBC 64位.我已经安装了Microsoft Integration Runtime.在Microsoft集成中 运行时配置管理器，它连接到云，在窗口的下方，有一个绿色复选框，并显示已连接到云服务(Data Factory V2)".在家庭中，它说自托管节点已连接到云服务". 在诊断程序中，我测试了ODBC连接，结果正常.

The purporse is the copy data from an Oracle DB on-premise to the cloud. I have already installed Oracle Client 11g 64 bit. I have already configured ODBC 64-bits in Windows. I have already installed Microsoft Integration Runtime. In the Microsoft Integration Runtime Configuration Manager, it is connected to the cloud, in the downside of the window there is a Green Check and it says "Connected to the cloud Service (Data Factory V2). In the home it says "Self-hosted node is connected to the cloud service". In the Diagnostics I tested an ODBC connection, and it resulted ok.

谢谢！

Roberto E.

Roberto E.

推荐答案

我执行了相同的步骤，但使用ADF V1，一切正常.因此，我认为Azure应该是一个问题.

I did the same steps but with ADF V1 and everything worked OK. Therefore, I think it should be a problem with Azure.

谢谢！

Roberto E.

Roberto E.

这篇关于在Azure数据工厂中创建新的链接服务时遇到问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！