Forum Discussion

mtstewart17's avatar
mtstewart17
Icon for Advocate I rankAdvocate I
9 years ago

Enterprise Gateway with ODBC

Hello,   I have an ODBC source that I use for several Dashboards. I would like to setup a Gateway in order to keep the data up to date. The source is an IBM DB2 database. (I know that connecting st...
Need Help
arielgasek's avatar
arielgasek
Regular Visitor
9 years ago

This is how it worked for me:

1. local machine and gateway server dns need to be set up the same way, name specifically must be the same, as well as schema, table etc. This will ensure both connection strings are the same

2. the database needs to have a view created for the data you're trying to extract, so you can refer to the view while creating the dashboard in desktop app and create the same source under gateway manager

3. as long as both sources are the same the scehduler will see the gateway source.

 

Rgds

Ariel

curtismob's avatar
curtismob
Icon for Helper IV rankHelper IV
9 years ago

Thank you Ariel for the information, this is very helpful.

 

curtismob

  • jijoyav's avatar
    jijoyav
    Frequent Visitor
    8 years ago

    Hello All,

     

    I am trying to set my Power BI Gateway and I receive below error. I am able to connect to ODBC from Power BI Desktop.

     

    I have tried to configure ODBC via Manage gateway but have received errors. Appreciate any help.

     

    Please find below error.

     

  • nassaf's avatar
    nassaf
    Regular Visitor
    8 years ago

    I'm getting the same error, did you figure this out?

     

    Error:

     

    Unable to connect: We encountered an error while trying to connect to . Details: "We could not register this data source for any gateway instances within this cluster. Please find more details below about specific errors for each gateway instance."

  • sirros_iot's avatar
    sirros_iot
    Icon for Helper III rankHelper III
    7 years ago

    Try to download On-premises data gateway (personal mode). It worked for me.