Microsoft Fabric as Data source in OAC

User_R9J83

Hi, we have the ODBC driver from Microsoft Fabric which can be used to connect from other sources to Fabric. Is there a way that we can use this ODBC driver as a connector from OAC- RPD and fetch the data from Fabric warehouse? We tried using the default ODBC driver in call interface and selecting the newly created ODBC connection to Fabric but the connection is not getting created successfully.

Please help

Gianni Ceresa

Hi,

In OAC you can't deploy a custom ODBC driver, therefore if your source requires its own ODBC driver, you can't use it directly with OAC.

You can find the list of supported sources for OAC here: https://docs.oracle.com/en/cloud/paas/analytics-cloud/acsds/supported-data-sources.html

Or you should connect your Microsoft Fabric via a source supported by OAC (a random Google search: https://community.fabric.microsoft.com/t5/General-Discussion/Fabric-Warehouse-as-Upstream-for-Oracle-Analytics-Cloud-OAC/m-p/4112371 , SQL Server is a valid source in OAC).

User_R9J83

Hi,

We could actually use the same ODBC driver and connect to Fabric warehouse and lakehouse using RPD!

Alan Lee - Oracle-Oracle

As Gianni mentions, OAC does not support custom ODBC. You can try JDBC: https://docs.oracle.com/en/cloud/paas/analytics-cloud/acsds/connect-remote-data-using-generic-jdbc.html