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

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
Nicolas_DHONT
New Member

Offline mode for Fabric Data Factory in case of internet cuts ?

Hello,

My client is using OnPremise transactional systems (ERP Microsoft Dynamics 365 Business Central and other tools) as they have a lot of web access troubles (due to their location [their factories and shops are on an island], they don't a a goog internet network).

 

They plan to move to Fabric for their BI (They can accept a delay if data are not up-to-date for a couple of days due to internet cut).

But they are wondering if they can use Fabric Data Factory to synchronize their OnPremise tools together too (i.e. ERP and CRM...) Here they cannot accept delays in the synchronisations in case of internet cut.
They got a proposal from Talend and Informatica to run the flows in SaaS mode by creating a local instance on their network so that the communcation can run in case of internet cut.
Do you know if we have similar technoly in Data Factory?

If not, what can Microsoft offer? SSIS?

Thanks and best regards,
Nicolas

2 ACCEPTED SOLUTIONS
v-yilong-msft
Community Support
Community Support

Hi @Nicolas_DHONT ,

Microsoft Fabric Data Factory can indeed help with synchronizing on-premises tools like ERP and CRM systems. To achieve this, you can use the On-Premises Data Gateway.

This gateway allows you to securely connect your on-premises data sources to Microsoft Fabric, enabling data integration even when your systems are not directly connected to the internet.

 

Here are the specific steps to follow:

1. First you can download and install the gateway.

vyilongmsft_0-1727227342442.png

2. Set up the connection for the on-premise data source in Data Factory.

vyilongmsft_1-1727227445173.png

vyilongmsft_2-1727227504420.png

3. Finally you can connect the gateway to the Data Factory and get the data source.

vyilongmsft_3-1727227602033.png

vyilongmsft_4-1727227849747.png

 

 

 

Best Regards

Yilong Zhou

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

Hi @Nicolas_DHONT ,

Yes, official documentation does exist, you can refer to this document below, I hope it helps you.

How to access on-premises data sources in Data Factory - Microsoft Fabric | Microsoft Learn

 

 

Best Regards

Yilong Zhou

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

4 REPLIES 4
v-yilong-msft
Community Support
Community Support

Hi @Nicolas_DHONT ,

Microsoft Fabric Data Factory can indeed help with synchronizing on-premises tools like ERP and CRM systems. To achieve this, you can use the On-Premises Data Gateway.

This gateway allows you to securely connect your on-premises data sources to Microsoft Fabric, enabling data integration even when your systems are not directly connected to the internet.

 

Here are the specific steps to follow:

1. First you can download and install the gateway.

vyilongmsft_0-1727227342442.png

2. Set up the connection for the on-premise data source in Data Factory.

vyilongmsft_1-1727227445173.png

vyilongmsft_2-1727227504420.png

3. Finally you can connect the gateway to the Data Factory and get the data source.

vyilongmsft_3-1727227602033.png

vyilongmsft_4-1727227849747.png

 

 

 

Best Regards

Yilong Zhou

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

Hi @v-yilong-msft ,

 

Thank you for your reply. I was not aware the gateway was able to run a fabric flow even if it is not able to reach Fabric service due to an internet cut. How does it work technically?

Do you have some documentation about that? (I didn't get find anything on Ms Learn regarding this topic (and my client is asking proof).

 

Thank you for your help!

Hi @Nicolas_DHONT ,

Yes, official documentation does exist, you can refer to this document below, I hope it helps you.

How to access on-premises data sources in Data Factory - Microsoft Fabric | Microsoft Learn

 

 

Best Regards

Yilong Zhou

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

lbendlin
Super User
Super User

The thing that comes to mind is Power BI Report Server.  That's the on-prem equivalent of the Power BI service.

 

I cannot see a future for PBIRS inside Fabric though - they are kind of opposites.

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

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

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

November Update

Fabric Monthly Update - November 2024

Check out the November 2024 Fabric update to learn about new features.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.