在Azure数据工厂中查找 [英] Lookup in Azure Data Factory

问题描述

您好，

Azure数据工厂V2

Azure Data Factory V2

我们需要在Azure SQL和Oracle数据库之间移动数据。将数据从Azure SQL移动到Oracle数据库时，我们需要在Oracle数据库表上查找一些ID列，然后填充其相应的描述。例如，如果来自Azure
的数据只有Country_ID，我们需要在Oracle数据库上进行查找以获取相应的国家/地区名称，然后将结果填充到Oracle数据库表中。我是Azure数据工厂的新手，无法弄清楚如何解决这个问题。请告诉我
如何进行查找？

We need to move data between Azure SQL and Oracle database. When moving the data from Azure SQL to Oracle database, we need to lookup some ID column on Oracle database tables and then populate its corresponding description. For example if the data from Azure has only Country_ID, we need to do lookup on Oracle database to get the corresponding country name and then populate the result to Oracle database table. I am new to Azure data factory and couldn't figure out how to tackle this scenario. Please let me know how to do the lookup ?

我能想到的唯一解决方法是将Oracle数据库表复制到Azure，然后在复制活动SQL中执行查找逻辑。我们不想采用这种方法，因为我们必须维护另一个表并刷新。

Only workaround I can think of is copying the Oracle database table to Azure and then do the lookup logic in Copy Activity SQL. We don't want to take that approach as we had to maintain another table and refresh.

谢谢！

推荐答案

您好Ebin，

Hi Ebin,

您可以使用自定义活动连接到Azure SQL，获取数据，转换数据，然后使用其连接器写入Oracle DB。

You can have a custom activity to connect to Azure SQL, fetch data, transform the data and then write to Oracle DB using its connector.

要阅读有关ADF中自定义活动的更多信息，请参阅此文档：

To read more about custom activities in ADF, please refer this doc :

https://docs.microsoft.com/en-us/azure/ data-factory / transform-data-using-dotnet-custom-activity

https://docs.microsoft.com/en-us/azure/data-factory/transform-data-using-dotnet-custom-activity

如果有帮助，请告诉我们。否则，我们可以继续进一步探讨这个问题。

Let us know if this helps. Else, we can continue to probe into the issue further.

这篇关于在Azure数据工厂中查找的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！