添加秘密用户名&密码到数据工厂中的肥皂API调用
我使用复制数据活动方法(HTTP Linked Service / XML DataSet等),使用ASESERAME(用户名,密码和其他参数)从SOAP API获取数据。我也能够填充SQL Server表。
但是,出于安全原因,我需要在数据工厂的复制数据活动中隐藏用户名和密码,我提供的参数才能连接到SOAP API。
我创建了一个用户名和密码秘密,并试图用用户名和密码参数替换它。看来我无法与服务连接,我会得到此错误:
你们中有人知道是否可以实现吗?我知道肥皂API可能是一种旧技术,但我想知道这是否可以实现。也许我缺少中间的东西。感谢您的想法。
作为其他信息,让我分享我在SOAPUI中提供的参数的图像,以连接到SOAP API。
arg0是用户名,arg1是密码。
问候
I am getting data from Soap API with security (username, password and additional parameters) call with Azure Data Factory using the Copy Data Activity approach (HTTP Linked Service / XML Dataset, etc.). Also I am able to populate SQL Server tables.
However, for security reasons, I need to hide username and password in Copy Data Activity in Data Factory, parameters that I provide in order to connect to Soap API.
I have created a username and password secrets and attempted to substitute it in username and password parameters. It seems I am not able to connect with the service, I get this error:
Does any of you know if this is possible to achieve? I know Soap API could be a kind of old technology but I would like to know if this is possible to achieve or not. Maybe I am missing something in the middle. I will appreciate your thoughts.
As additional information let me share an image of the parameters I provide in SoapUI in order to connect to Soap API.
arg0 is username, arg1 is password.
Regards
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。

绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(1)
我可以建议您使用Azure密钥保险库,但并不能回答您的所有要求。
您可以检索密码,但不能从Azure Data Factory的链接服务中检索用户名,这是一个设计限制。
我强烈建议您将密码保存在Azure密钥库中,因为它的安全性很高。
请在Microsoft文档中阅读有关它的更多信息: https://learn.microsoft.com/en-us/azure/data-factory/store-credentials-in-key-vault
i can recommend to you to use Azure Key Vault, but it does not answer all your requirements.
You can retrieve your password but you can't retrieve your username from a linked service in azure data factory, its a design limitation.
i highly recommend saving your password in azure key vault since its highly secured.
please read more about it in Microsoft docs: https://learn.microsoft.com/en-us/azure/data-factory/store-credentials-in-key-vault