Oracle APEX integration with Microsoft Fabric

[pallavi_r]

Hi Team, 

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

Thanks,

Pallavi

[Anonymous · Accepted solution]

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.