Forum Discussion
Locally installed ODBC driver
Hi
I am new enough to Fabric that I'm not sure if this question belongs in Dataflows or Data Pipelines so please forgive me if I've posted in the wrong place.
I have an ODBC driver (authored by a company called cData) for Hubspot installed locally on my work laptop. I use it to import data into Excel models. I currently have a trial licence for Fabric. Is there a way for me to use that ODBC driver to get data into my Fabric Lakehouse?
Cheers
Stuart
Please check the requirements from the link below:
https://learn.microsoft.com/en-us/power-query/dataflows/using-dataflows-with-on-premises-data
Only standard gateways are supported in Dataflows. Not personal gateways.
6 Replies
Hi stuartbisset
Thanks for using Fabric Community.
Currently ODBC connection is possible in Dataflow Gen2.
https://learn.microsoft.com/en-us/fabric/data-factory/connector-odbc
Please check the supported types here
https://learn.microsoft.com/en-us/power-query/connectors/odbc#prerequisites
Hope this helps. Please let me know if you have any further questions.
Yes, I have had a look at that but can't seem to figure out how to make that work. Any further step by step or screenshots would be very much appreciated
Hi stuartbisset
First you would need to install an On-Premises Gateway.
Install an on-premises data gateway | Microsoft LearnAfter creating On-Prem gateway, then you can connect this gateway in Fabric.
Hope this helps. Please let me know if you have any further questions.
