Forum Discussion

stuartbisset's avatar
stuartbisset
New Member
2 years ago
Solved

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...
General Question
stuartbisset's avatar
stuartbisset
New Member
2 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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

  • stuartbisset's avatar
    stuartbisset
    New Member
    2 years ago

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

     

     

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

     

     

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

     

    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