kohera-logo-regular.svg

How to connect to IBM DB2 from Power Query

For a proof of concept Yves Groenen was asked to make a connection from Excel powerquery to an IBM DB2 database. Read more about his findings. Situation For a proof of concept I was asked to make a connection from Excel powerquery to an IBM DB2 database. Since I didn’t have a server somewhere with DB2 installed on it, so I went searching for a solution. A thing to keep in mind is that this post isn’t a deep dive into DB2, but a connectivity test between Excel and DB2.