Can IntegrationRuntime on Synapse and on-prem-gateway exists and work for Synase and fabric?

[XhevahirMehalla]

Hello- 

I know we have to migrate to Fabric from synapse but we are not there yet.

I want to have two systems: Synapse working as is for now (get oracle from OCI db, use data lake and azure sql db as the datawarehouse). I don't have time to migrate this solution yet.

But now I want to create the fabric portion where I want to:

1. Use data mirroring for oracel for some tables where I need near-real-time reporting and develop some reports on those selective objects. I guess I need to create a DWH on fabric for them or use the LakeHouse. DWH probably will be more appropriate. 
2. I want to be able to use Copilot to create some reports using F4 capacity.

In order to use the fabric and I need to install on-premise-gateway. Right now I am yusing my machine which is not prod like solution.

Can I use the same azure vm where integration runtime is running for Synapse and install onpremise gateway? 

Please can you help me and guide me through this solution?

Thanks

Xhev

[v-dineshya]

Hi @XhevahirMehalla ,

Thank you for reaching out to the Microsoft Community Forum.

You want to migrate to Fabric from synapse .

Please follow below steps.

1. Install On-premises Data Gateway on the same Azure VM. Use standard mode. Register it under your Fabric workspace.

2. Connect to Oracle via the gateway. Select tables for mirroring. Choose Fabric DWH as the target.

3. Use Power BI in Fabric. Connect to the mirrored DWH. Use F4 capacity for performance and Copilot features.

4. Use Azure Monitor or Log Analytics to track performance. scale the VM or split services later.

Oracle Data Mirroring Setup:

Microsoft Fabric supports Oracle Data Mirroring for real-time analytics. This feature is currently in preview and supports Oracle versions 11 and above.

Requirements: Oracle DB with LogMiner enabled. Archive log mode and supplemental logging enabled. On-premises Data Gateway installed and configured. Fabric workspace with Trial or Premium F4 capacity.

On-premises Data Gateway with Microsoft Fabric:

To connect on-premises data sources to Fabric like Oracle, SQL Server, you must install and configure the On-premises Data Gateway.

Please refer below links.

Tutorial: Set up Oracle database mirroring in Microsoft Fabric (Preview) - Microsoft Fabric | Micros...

Mirror Oracle Databases in Microsoft Fabric (Preview) - Microsoft Fabric | Microsoft Learn

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

Install an on-premises data gateway | Microsoft Learn

I hope this information helps. Please do let us know if you have any further queries.

Regards,

Dinesh

[XhevahirMehalla]

Thanks Dinesh!

In fact I will be working on hybrid mode - meaning the current solution n Synapse stays as is (Data lake, OCI data as source, ETL - use Synapse pipelines and Azure SQL db as the DWH). This cannot be migrated now.

What I am planning is:

For real time data/reporting want to use Fabric data mirroring for Oracle - take few tables and build some reports from there which will use the Direct lake mode. This is how I see this.

The rest of reports will come from Azure SQL db which has the Synapse as the ETL. 

That's I call it hybrid for now.

My question is:

For synapse implementation I use VM on azure to install SHIR. 

On fabric in order to do data mirroring with oracle OCI I need to setup the standard on-premise-gateway.

The question is:

can this VM be used as SHIR as we well as onpremise gateway and the implications - 4cpu and 16 GB memory.

If I can do that I need some guidance how to do and install and assign a workspace. I do have F4 capacity.

Thanks

Xhev 

[v-dineshya]

Hi @XhevahirMehalla ,

Thank you for the update.  It appears this issue might require deeper investigation from the Microsoft  Fabric support team. I recommend opening a Microsoft support ticket so they can trace the issue. To raise a support ticket for Fabric and Power BI, kindly follow the steps outlined in the following guide:

How to create a Fabric and Power BI Support ticket - Power BI | Microsoft Learn

Regards,

Dinesh

[ibarrau]

Hi @XhevahirMehalla . Sure you can. They are different clients that can live in the same machine. However, best practice guidance suggests not to install the Self Hosted Integration Runtime SHIR (or gateway) on the same machine as other heavy workloads or conflicting software (especially gateways + SHIR together) because of resource, port (they use the same one) and maintenance. It might depend on the data volume you need to handle.

https://learn.microsoft.com/en-us/answers/questions/797825/power-bi-gateway-installation-on-adf-self...

I hope that helps,

[XhevahirMehalla]

I have Synapse and not ADF. 

I want to have Synapse and a portion of Fabric to extract data from the same OCI Oracle DB. 

the question is: 

Do I need to have a seperate VM for each of them or can live on the same machine?

[ibarrau]

ADF and Synapse uses the same service for IR. That's why the docs is talking about that. Like I said before. You can. It's not recommended, but you totall can.

Regards

[v-dineshya · Accepted solution]

Hi @XhevahirMehalla ,

Thank you for the update.  As mentioned by @ibarrau ,  For best practice guidance suggests not to install the Self Hosted Integration Runtime SHIR (or gateway) on the same machine as other heavy workloads or conflicting software (especially gateways + SHIR together) . 

In addition to @ibarrau  response, I have attached snap and Micrsoft document.

Create a self-hosted integration runtime - Azure Data Factory & Azure Synapse | Microsoft Learn

One again thank you @ibarrau .

I hope this information helps. Please do let us know if you have any further queries.

Regards,

Dinesh

[v-dineshya]

Hi @XhevahirMehalla ,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. And, if you have any further query do let us know.

Regards,

Dinesh

[v-dineshya]

Hi @XhevahirMehalla ,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. And, if you have any further query do let us know.

Regards,

Dinesh