Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join us at FabCon Vienna from September 15-18, 2025, for the ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM. Get registered

Reply
kkoba
Frequent Visitor

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

 

2 ACCEPTED SOLUTIONS
NandanHegde
Super User
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




----------------------------------------------------------------------------------------------
Nandan Hegde (MSFT Data MVP)
LinkedIn Profile : www.linkedin.com/in/nandan-hegde-4a195a66
GitHUB Profile : https://github.com/NandanHegde15
Twitter Profile : @nandan_hegde15
MSFT MVP Profile : https://mvp.microsoft.com/en-US/MVP/profile/8977819f-95fb-ed11-8f6d-000d3a560942
Topmate : https://topmate.io/nandan_hegde
Blog :https://datasharkx.wordpress.com

View solution in original post

Anonymous
Not applicable

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.

vkongfanfmsft_0-1732864340766.png

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.

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

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.

vkongfanfmsft_0-1732864340766.png

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
Super User
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




----------------------------------------------------------------------------------------------
Nandan Hegde (MSFT Data MVP)
LinkedIn Profile : www.linkedin.com/in/nandan-hegde-4a195a66
GitHUB Profile : https://github.com/NandanHegde15
Twitter Profile : @nandan_hegde15
MSFT MVP Profile : https://mvp.microsoft.com/en-US/MVP/profile/8977819f-95fb-ed11-8f6d-000d3a560942
Topmate : https://topmate.io/nandan_hegde
Blog :https://datasharkx.wordpress.com

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June FBC25 Carousel

Fabric Monthly Update - June 2025

Check out the June 2025 Fabric update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.