Forum Discussion

Mat_Mat's avatar
Mat_Mat
New Member
5 years ago

Connection between SQ DEVELOPER ORACLE (DB2) and POWER BI - HELP!:)

Hello,

I would like to connect Oracle SQL Developer (Db2) with Power BI. Could I ask someone how to do it step by step and what I need extactly to do it? Namely, I have several connections/servers in SQL Developer Oracle using db2. On top of that, I have also some reports with ready queries in SQL Developer based on these servers. I would like to constantly use these queries in Power BI based on connections/servers in SQL Developer. How can I do it?

Interesting Links
Need Help
Show and Tell

3 Replies

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    5 years ago

    Are your connections TNS based, TNS-less, ODBC, or something else?  Generally you need to create the same connection environment on your PC and on the gateway, and then be consistent in using it (down to the spelling - gateway connections are now case sensitive).

    • Mat_Mat's avatar
      Mat_Mat
      New Member
      5 years ago

      Hello,

      My connections are only based on DB2. I am connected to DB2 using dedicated drivers (JARs). I know hostname, port and database. So that, I was thinking that it is enough to find some solution in order to connect with POWER BI based on IBM Db2 or Oracle database? 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    HI Mat_Mat,

    I think it should be related to your database type and the data provider. You can at least you the data connector with your database type and the supported data providers to get data from power bi. (please confirm you have enabled these connections mode on your database side)

    Regards,

    Xiaoxin Sheng