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

Hi,

 

I have a system DSN set up (64-bit) using vertica driver. It works well.

I can easly connect to the DB via Power BI Desktop, however when I try to create a datasource using this DSN in Gateway manager I'm facing following issue:

 

 

Can you help me figure out how to define the string correctly?

 

What should be the connection string format when connecting to Oracle DB?

 

Anonymous's avatar
Anonymous
Not applicable
9 years ago

arielgasek,

Ensure that you create a system DSN rather than a user DSN.

Regards,
Lydia

  • arielgasek's avatar
    arielgasek
    Regular Visitor
    9 years ago

    I did that, it's working well, I can connect via Desktop App easly, just Gateway MAnager does not get me to create new source.

    Below screen from my sys DSN

     

    Thanks

    ariel

     

     

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

      If you go to "Edit Queries" then select your ODBC data table and click the "Advanced Editor" option you can see more detail on the DSN string

      • curtismob's avatar
        curtismob
        Icon for Helper IV rankHelper IV
        8 years ago

        I just tried the same thing and received the same error.  I'm guessing the DSN needs to be set up on the gateway server.  I am going to try this to see if this resolves the issue.

  • andrejmfreitas's avatar
    andrejmfreitas
    Icon for Helper I rankHelper I
    5 years ago

    Thank you very much! That was the answer for me!

    I didn't have a system DSN 

  • duardo08's avatar
    duardo08
    Icon for Advocate I rankAdvocate I
    3 years ago

    Thank you very much, it worked for me, I was trying to put the scheduled update via enterprise gateway to work for days