Forum Discussion
Configuration for updating external data source from Fabric Datawarehouse
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
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
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 KongIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
- NandanHegde
Super User
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
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 KongIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.