Microsoft Fabric as Data source in OAC
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
Answers
-
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:
Or you should connect your Microsoft Fabric via a source supported by OAC (a random Google search:
, SQL Server is a valid source in OAC).0 -
Hi,
We could actually use the same ODBC driver and connect to Fabric warehouse and lakehouse using RPD!
0 -
As Gianni mentions, OAC does not support custom ODBC. You can try JDBC:
1