1

How to take oracle as the source dataset in the look up activity in azure data factory V2 ? I have an Oracle dataset 'DS_ORAC'. I would like to take this dataset as the Source Dataset in a look up activity.

Aritra Sarkar
  • 225
  • 4
  • 13
  • What have you tried so far? Have you used a look up activity yet? – Nick.Mc Apr 07 '18 at 11:05
  • @Nick.McDermaid I have used a look up activity. It is accepting Azure Sql Dataset as the Source Dataset but I can't find my 'DS_ORAC' dataset in the Look activity's Source Dataset's dropdown list. – Aritra Sarkar Apr 07 '18 at 11:15
  • Under "Supported Capabilities" here https://learn.microsoft.com/en-us/azure/data-factory/control-flow-lookup-activity, Oracle is not listed. – Nick.Mc Apr 07 '18 at 11:17
  • So, there isn't any other ways I guess – Aritra Sarkar Apr 07 '18 at 11:19
  • That depends on what you're actually trying to do. What kind of source are you looking up against? Where is the final data going? How many rows in each source? – Nick.Mc Apr 07 '18 at 11:20
  • I'm looking to store the count of an Oracle table in a look up activity, whose value will then be used to update the 'SourceCount' column of the Audit table present in Azure Sql – Aritra Sarkar Apr 07 '18 at 11:24
  • I would always suggest simply loading the Oracle results into a staging table in SQL Azure then use T-SQL to assign those results wherever required – Nick.Mc Apr 07 '18 at 13:22

1 Answers1

0

The oracle dataset is now supported as well in Lookup Activity. We will soon update the Supported Capabilities at https://learn.microsoft.com/en-us/azure/data-factory/control-flow-lookup-activity. You may take a try. The dataset and link service definition would be the same as Copy Activity.

Joe Lu
  • 16
  • The OP mentioned that the dataset was not in the dropdown list. – Nick.Mc Apr 07 '18 at 13:21
  • Right. So you are using Madrid App, correct? The UX change may still take several days. I will reply when it is ready. – Joe Lu Apr 09 '18 at 05:36
  • I don't normally do this but since you seem to have an inside line on Azure... could I draw your attention to this question: https://stackoverflow.com/questions/48607627/does-azure-analysis-services-support-service-principal-signon-to-sql-azure – Nick.Mc Apr 09 '18 at 07:47
  • Sorry, not close with AAS. – Joe Lu Apr 11 '18 at 11:15
  • Thanks for responding. Do you have any contacts who are? No one anywhere has clarified what types of data source authentication it supports – Nick.Mc Apr 11 '18 at 11:26