Forum Discussion

robarivas's avatar
robarivas
Icon for Post Patron rankPost Patron
9 years ago
Solved

IBM DB2 Connection

Hello. I'm using Microsoft's built-in connector in Power BI to try to connect to an IBM DB2 database (for z/OS mainframe). However, I'm getting the following error message:   "Microsoft Db2 Client:...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    I recently had to help a group of clients connect, and we found that the following conditions were necessary:

    1) You must have the DB2 client installed on the machine from which you are trying to connect

    2) Under Advanced Options in the Power BI connection dialog:

       a) You have to use the Microsoft driver (as you mention)

       b) You have to uncheck the "Navigate Using Full Hierarchy" option

    3) You need to connect using the Database tab (not the Windows tab) and use your MF credentials

     

    Without all of these in place, we had to use ODBC to connect.  

     

    FWIW, the view provided form the MF was basically just a selection of tables -- no individual columns were selectable. 

     

     

     

     

fherrera's avatar
fherrera
Frequent Visitor
9 years ago

Did someone resolved this problem? I have the latest version of Power BI Desktop, but, even in this new version it doesn't work.

  • robarivas's avatar
    robarivas
    Icon for Post Patron rankPost Patron
    9 years ago

    Finally the DBA group in my IT department did something (maybe they had to call Microsoft??) such that now the DB2 connector works...but only when you choose Microsoft as the driver option. Still doesn't work with the IBM option. But even though the DB2 connection now sorta works I can't say that I have witnessed any difference as compared to the ODBC connection I had been using previously. Anyone know what I should be looking for to see if the whole drama re: the DB2 connector had been worthwhile?

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      I recently had to help a group of clients connect, and we found that the following conditions were necessary:

      1) You must have the DB2 client installed on the machine from which you are trying to connect

      2) Under Advanced Options in the Power BI connection dialog:

         a) You have to use the Microsoft driver (as you mention)

         b) You have to uncheck the "Navigate Using Full Hierarchy" option

      3) You need to connect using the Database tab (not the Windows tab) and use your MF credentials

       

      Without all of these in place, we had to use ODBC to connect.  

       

      FWIW, the view provided form the MF was basically just a selection of tables -- no individual columns were selectable. 

       

       

       

       

      • FrankOveres's avatar
        FrankOveres
        New Member
        6 years ago

        Yes!!!
        Thanks it works but what a strange solution.