Oracle APEX integration with Microsoft Fabric

pallavi_r — Tue, 16 Jul 2024 15:12:20 GMT

Hi Team,

Can you please suggest best approach to integrate Oracle Apex with Microsoft Fabric.

Thanks,

Pallavi

Re: Oracle APEX integration with Microsoft Fabric

Anonymous — Wed, 17 Jul 2024 02:09:47 GMT

Hi pallavi_r ,

It depends on your requirement scenario. Here are a few common approaches and their steps:

Integration using APIs
Oracle APEX provides RESTful Web services and you can integrate with Microsoft Fabric through these APIs.
Steps:
- Create RESTful Web Service: Create a RESTful Web service in Oracle APEX to provide an interface for data access.
- Call APIs: Call these RESTful APIs using HTTP requests in Microsoft Fabric to fetch data.
- Once the data is fetched, subsequent operations can be performed using fabric's powerful data processing and analytics platform.
Connecting directly to the database
If your Oracle APEX database allows external connections, you can connect the database directly to Microsoft Fabric.
Steps:
- Configure the firewall: Ensure that the Oracle database allows external connections and configure the appropriate firewall rules.
- Set connection string: Configure the connection string for the Oracle database in Microsoft Fabric.
- Again, once the data is acquired, you can utilize fabric's powerful data processing and analytics platform for subsequent operations.

Although the fabric platform is very powerful, you still need to consider the scenarios of your needs in order to give a suitable solution and practical steps.

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.

topic Re: Oracle APEX integration with Microsoft Fabric in Dataflow

Oracle APEX integration with Microsoft Fabric

Re: Oracle APEX integration with Microsoft Fabric