ADF On Prem Integration

Kanna 1 Reputation point
2021-03-30T04:49:16.297+00:00

I understand that one of the way of Integrating ADF dataflow with On Prem sources (such as SAP, Oracle etc) is to Use Copy Data to move data to Data store and then use Dataflow to perform data integration.

Are there any other ways which can enable to use On-Prem Data sources (as Lookups, source, target etc) directly in a Data flow.

Please advise.

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,639 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. MarkKromer-MSFT 5,186 Reputation points Microsoft Employee
    2021-03-30T16:09:04.157+00:00

    Use the ELT pattern by staging data in the Lake using Copy Activity, then transform w/data flow is currently the only mechanism for SAP or Oracle.