Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
stuartbisset
New Member

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

1 ACCEPTED SOLUTION

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.

View solution in original post

6 REPLIES 6
v-nikhilan-msft
Community Support
Community Support

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 Learn

vnikhilanmsft_1-1713375320825.png

 

vnikhilanmsft_2-1713375341695.png

 

 

After 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.

Many thanks for your response.  I believe I have a personal gateway installed correctly which seems to be online:

stuartbisset_3-1713865866577.png

 

 

I also managed to create a connection (though I'm not sure if this is necessary or not?):

stuartbisset_4-1713865895167.png

 

 

But the real trouble begins when I try a dataflow gen 2, using the ODBC connector:

 

stuartbisset_2-1713865216885.png

As you can see above:

1. I have guessed the connection string to be "dsn=Blackford Hubspot ODBC".  

2. "Create new connection" is the only option i have in the drop down list for 'connection'

3. "(none)" is the only option I have for 'Data Gateway' but I know this should be pointing to my personal mode gateway.

 

Just can't seem to get this ODBC part working.  Any further help, again, very much appreciated.

 

Many thanks

 

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.

Hi @stuartbisset 
We haven’t heard from you on the last response and was just checking back to see if you got some insights regarding the query. Otherwise, will respond back with the more details and we will try to help.
Thanks

Helpful resources

Announcements
Sept Fabric Carousel

Fabric Monthly Update - September 2024

Check out the September 2024 Fabric update to learn about new features.

Expanding the Data Factory Forums

New forum boards available in Data Factory

Ask questions in Apache Airflow Job and Mirroring.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

Find out what's new and trending in the Fabric Community.