How do I connect with oracle in fabric?

[leesukjun]

Hello, fabric masters

I wonder how I can import Oracle's data into Fabric.
According to the guide, a window system is required.
Without a window system,
How to import directly from on-premises oracle to my fabric.
Is there any way to use connector or notbook?

I read this. 

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

https://learn.microsoft.com/en-us/fabric/data-factory/how-to-access-on-premises-data

Installing an On-Premises Data Gateway

https://learn.microsoft.com/ko-kr/data-integration/gateway/service-gateway-install

Set up your Oracle database connection

https://learn.microsoft.com/en-us/fabric/data-factory/connector-oracle-database

Previous community posts : Connecting Oracle to Microsoft fabrics

but But it didn't help much.

https://community.fabric.microsoft.com/t5/Fabric-platform/Connecting-Oracle-to-Microsoft-fabrics/m-p...

I need to bring various DBs(Oracle,MySQL,MS-SQL,Snowflake,Databrics. etc..).
I also need to communicate with the API that is Auto2.0 certified, but it's already blocked.

First, tell me the Oracle connection

Thank you.

Regards

[Anonymous]

Hi @leesukjun 

Thank you very much spencer_sa for your prompt reply.

I found your post while checking the forum. Did you solve your problem? If not, here are some ideas I can offer:

To import data from an on-premises Oracle database into Microsoft Fabric without a Windows system, you can consider the following methods:

On-premises data gateway: This is the recommended method for securely connecting on-premises data sources to Microsoft Fabric, but it generally requires a Windows system. If you don't have a Windows system, you can consider setting up a virtual machine (VM) with Windows to host the gateway.

If setting up a Windows VM is not feasible, you can try exploring third-party tools or services.

Solved: Need to load data from oracle and import into fabr... - Microsoft Fabric Community

Regards,

Nono Chen

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

[leesukjun]

thank you. your reply..

I want to get Oracle's data periodically without additional resources (VMs).
Thank you for your reply, but it doesn't seem to be the ultimate problem solving with that method, because there will be additional costs.

Thank you.

[Anonymous]

Hi @leesukjun 

I have some ideas:

If conditions permit, you can use Oracle Database with cloud storage.

For example, back up the data of Oracle Database to Oracle Cloud Storage and use the backup data in the pipeline of Data Factory to process and import the data regularly.

By backing up data from Oracle Database to Oracle Cloud Storage and using the backed-up data in Data Factory pipelines, you typically don't need to use a gateway or additional resources:

Because the data is already backed up to Oracle Cloud Storage, you can read the data directly from the cloud storage without going through an on-premises data gateway.

You don't need additional VMs or other hardware resources. Simply use Data Factory's built-in connectors and activities to process and import the backup data.

Make sure your Data Factory has permission to access the backup files in Oracle Cloud Storage. You can configure access using the appropriate authentication method, such as API keys or OAuth tokens.

Oracle Cloud Storage connector overview - Microsoft Fabric | Microsoft Learn

Hope this can give you some help.

Regards,

Nono Chen

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

[leesukjun]

Thank you for your additional reply.

I wonder if Oracle Cloud Storage can only import the incremental data in the way you told me. I'll look into it more.

If that's the way it is, it's rather the same as putting Oracle's incremental data into Azure Storage and getting it.
However, that will require one more unnecessary procedure in the middle.

Thank you.

[Anonymous]

Hi @leesukjun 

You can try to handle incremental data import directly from Oracle Cloud Storage, which can simplify the process and avoid unnecessary steps. Here are a few possible approaches:

File-based Data Import (FBDI):
Oracle's File-based Data Import (FBDI) can be used to import incremental data over time. This approach involves creating CSV files for incremental data and uploading them to Oracle Cloud Storage. You can then use these files in a Data Factory pipeline to import only new or updated data.

Incremental Export-Import:
Oracle supports incremental exports, which only export tables that have been modified since the last export. Upload these incremental export files to Oracle Cloud Storage, and then use these files in a Data Factory pipeline for data import.

By using these approaches, you can simplify the process and avoid the extra step of moving data to Azure Storage.

Regards,

Nono Chen

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

[leesukjun]

Thank you for your quick response.
But what I want is to access Oracle installed on-premises (Public IP Address) from Fabric and get the data periodically.

I am not familiar with Azure and Fabric yet.

When I was working on GCP, I developed it from Airflow to Python and got Oracle data.
But I couldn't do something similar with Notebook right now.
So I found a NoCode connection method, but it should also have a Windows server (or PC) in the middle. This is too unreasonable.
I have to force my customers to purchase additional Windows servers.

Connect on notbook and save data in Fabric?
I need to find an oracle connection tool.

thank you..

[leesukjun]

Thank you for your quick response.
But what I want is to access Oracle installed on-premises (Public IP Address) from Fabric and get the data periodically.

I am not familiar with Azure and Fabric yet.

When I was working on GCP, I developed it from Airflow to Python and got Oracle data.
But I couldn't do something similar with Notebook right now.
So I found a NoCode connection method, but it should also have a Windows server (or PC) in the middle. This is too unreasonable.
I have to force my customers to purchase additional Windows servers.

Connect on notbook and save data in Fabric?
I need to find an oracle connection tool.

thank you..

[spencer_sa]

As you say, in order to connect to an 'on premise' Oracle database you will need an Oracle gateway running on a Windows machine.
Technically that machine could be an Azure VM, but you'd need to make sure all the networking was set up so a) Fabric can see the VM and b) the VM can contact the On Premise database.
You also need to install the Oracle Client on the same machine the Gateway is living on.
As per your original link https://learn.microsoft.com/en-us/fabric/data-factory/connector-oracle-database

An alternative (and limited) method to get data from Oracle into Fabric in bulk would be to write PL/SQL code to write data out to Fabric via the API.  This is something I've seen done.

[leesukjun]

Thank you for your quick response.
But what I want is to access Oracle installed on-premises (Public IP Address) from Fabric and get the data periodically.

I am not familiar with Azure and Fabric yet.

When I was working on GCP, I developed it from Airflow to Python and got Oracle data.
But I couldn't do something similar with Notebook right now.
So I found a NoCode connection method, but it should also have a Windows server (or PC) in the middle. This is too unreasonable.
I have to force my customers to purchase additional Windows servers.

Connect on notbook and save data in Fabric?
I need to find an oracle connection tool.

thank you..

[leesukjun]

Thank you for your quick response.
But what I want is to access Oracle installed on-premises (Public IP Address) from Fabric and get the data periodically.

I am not familiar with Azure and Fabric yet.

When I was working on GCP, I developed it from Airflow to Python and got Oracle data.
But I couldn't do something similar with Notebook right now.
So I found a NoCode method connection, but it should also have a Windows server (or PC) in the middle. This is too unreasonable.
I have to force my customers to purchase additional Windows servers.

Connect on notbook and save data in Fabric?
I need to find an oracle connection tool.

Thank you..