Configuration for updating external data source from Fabric Datawarehouse

[kkoba]

I want to update tables in an Oracle database in an on-premise or Azure environment from Fabric Datawarehouse.
Is it possible to update external data via a private network?

Could you please tell me about the necessary components?

thank you

[NandanHegde · Accepted solution]

As your Oracle database is in On Prem which would already be within a Vnet/private network, you can set up an on premises data gateway on a server that would act as a bridge between your oracle database and fabric warehouse for transfer/movement of data

[Anonymous · Accepted solution]

Hi @kkoba ,

As a supplement, updating tables in your Oracle database from Fabric Datawarehouse is possible both in your local environment and in your Azure environment.

A data gateway is necessary, which acts as a bridge to securely transfer data between your local Oracle database and Fabric Datawarehouse.

For more details, you can refer to below document:

Set up your Oracle database connection - Microsoft Fabric | Microsoft Learn

Best Regards,
Adamk Kong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[NandanHegde · Accepted solution]

As your Oracle database is in On Prem which would already be within a Vnet/private network, you can set up an on premises data gateway on a server that would act as a bridge between your oracle database and fabric warehouse for transfer/movement of data