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 straight to the database would be better than ODBC, but ODBC is my only option) 

 

I am wondering how I set this refesh up. I see the gateway setup prompts for a connection string and I am not sure what I need to include there to make the connection. I have a DSN fully configured on my computer's ODBC Data Source Administrator, but not sure how to format this into a connection string. 

 

Any guidance would be appreciated.

Need Help

14 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Hi mtstewart17,

    Based on your description, you want to add ODBC data source under gateway. In this case, you can input the connection string following the steps below.

    1. Check your DSN name(testodbc1 in my scenario) in ODBC administrator or in Power BI Desktop if you have connected to the odbc data source from Power BI desktop.


    2. Add data source under gateway by entering connection string , account and password as shown in the following screenshot .


    3. Schedule refresh for the dataset in Service.


    In addition, please ensure that you create a system dsn in ODBC administrator .

    Thanks,
    Lydia Zhang

  • 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

         

         

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hi Everyone,

     

    I was trying to set up a Data Source in Power BI Service with AWS Athena via ODBC data source. And was finally successful.

     

    It's very important that Power BI Gateway is running via user PBIEgwService

     

    For this reason, to make AWS authentication (and data source creation) work, you need to add IAM credentials in the folder for this user:

     

    C:\Users\PBIEgwService\.aws

     

    you will have to create a folder ".aws"

     

    Note, that in order to create such a folder, you should actually try to create a folder ".aws." - windows will cut off the last dot and you will receive a folder ".aws"

     

    Then, in this folder, you will need to create a file with AWS IAM Credentials. The name of the file should be "credentials" with no extension.

     

    The contents of the file should be:

     

    [YourIAMUser]

    aws_access_key_id=AKIAIOSFODNN7EXAMPLE

    aws_secret_access_key=wJalrXUtnFEMI/K7MDENG/bPxRfiCYEXAMPLEKEY