I was using the look up activity to read my tables in Oracle .I want the output of Look up to be the Source of DataFlow ,Because at dataflow designer i could not connect Oracle at source side,Oracle connector is not available in Dataflow level.

So is it possible this way or is there any efficient way to do it .

CodePudding user response：

For this pattern, use a Copy Activity in your pipeline prior to your Data Flow activity and stage the data in a Blob or ADLS folder, then use that dataset as the source in your data flow next in the pipeline.