Forum Discussion

robarivas's avatar
robarivas
Post Patron
9 years ago

IBM DB2 vs ODBC

My IT department tried to set up a connection to IBM DB2 but could only get it to work through ODBC. This doesn't seem right. Also, the performance over ODBC is horrible. Trying to filter a multi-mil...
Need Help
robarivas's avatar
robarivas
Post Patron
9 years ago

Fantastic, thank you. Hopefully "soon" means really, really, really soon :smileyhappy: 

 

How will I know when it's fixed?

 

I'm assuming this means once it's fixed I should be able to connect using the "IBM DB2 Database" option from the "Database" category of the "Get Data" dialog using the "Microsoft (requires .Net 4.5 or higher)" option under the "Advanced options" dropdown, correct?

 

I don't have the ODBC set-up yet on the machine I am using at the moment but I do have it on my machine at my home so I will generate the trace data on that tonight and email that you. (of course my hope is to eventually not have to use the ODBC approach)

arify's avatar
arify
Microsoft Employee
9 years ago

We don't really have an ETA yet, it seems like an external issue. But, my guess, it probably won't take more than a few releases.

 

You'll know if it's fixed if someone updates this thread, or just start trying every new release in 2017 :) If there are no other issues, you should be able to use that "Microsoft" option.

  • arify's avatar
    arify
    Microsoft Employee
    9 years ago

    Oh, I just learned that this (Value cannot be null. error) was a known issue and it was already fixed :) It'll be out in (end of) October release.

     

    I'll look into the traces about the performance, my guess is the driver reports us that its unable to compare dates, so we have to pull all the data.. I'll let you know once I take a look at them.

  • robarivas's avatar
    robarivas
    Post Patron
    9 years ago

    I've just sent another email with the trace files related to poor ODBC performance. In Power BI Desktop I pulled 3 tables from DB2 and tried filtering one of the tables to show only rows with a transaction posting date between 1/1/2016 and 1/31/2016. After waiting for a very long time I just gave up and closed the program.

  • robarivas's avatar
    robarivas
    Post Patron
    9 years ago

    That's great news arify. I really appreciate the responsiveness. I'm kind of in awe to be honest. I look forward to hear what you may find related to ODBC performance...though it sounds like I may not have to deal with that much longer if I get the October release :smileyhappy:

  • robarivas's avatar
    robarivas
    Post Patron
    9 years ago

    Hello arify. So I just downloaded the October 2016 update and tried to connect to the IBM DB2 database. This time the error I'm getting is: "Microsoft Db2 Client: The package corresponding to an SQL statement execution request was not found. SQLSTATE=51002 SQLCODE=-805".

     

    Any thoughts what might be going on now? I really want to use Power BI for my organization but I'm getting worn down by the connectivity problems. Please help.