question

Kanna-2940 avatar image
0 Votes"
Kanna-2940 asked MartinJaffer-MSFT commented

ADF On Prem Integration

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
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@Kanna-2940 did MarkKromer's suggestion solve your issue, or do you still need assistance?

0 Votes 0 ·

If you find your own solution, could you please share it with the community?

0 Votes 0 ·

1 Answer

MarkKromer-MSFT avatar image
0 Votes"
MarkKromer-MSFT answered JohnAherne-9205 commented

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.

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

There is always a way but the complexity and cost involved would not be worth it.

0 Votes 0 ·