DB2 database connection

gana1992

Can someone please explain how to use the ODBC connections to connect to a DB2 database?

I have all the drivers installed and all required permissions, but it still doesn't pull the database correctly (empty Db; 0 tables).

PS: I must say, I assumed Alteryx would be able to connect to DB2 directly and purchased the tool, but I've had to run around in circles to bridge this gap. Please fix this.

Datasets

Input

Connectors

Help

Database Connection

Alias Manager

Accepted answers

gana1992

Update: I was able to solve this by doing the following -

Deleting all previous connections
Updating drivers
Using SQL by variable names (in the SQL editor) instead of physically selecting the table.

Thank you for the help.

All comments

JakeS

Hi @gana1992

If you are using a User or System DSN for the connection, are you pointing to the correct database name in the ODBC DSN settings? Which driver are you using? The supported versions are stated in the help documentation.

https://help.alteryx.com/current/DataSources/DB2.htm?tocpath=Data%20Sources%7CSupported%20Data%20Sources%7C_____22

Jake

gana1992

Hi JakeS, Thanks for the reply.

I did partially solve that problem, but there seems to be an extended problem.

I need to connect to 2 different DB2 Databases (say A & , structured similarly. I'm currently using a System DSN for the connection and it connects only to a single database (Connects only to A, B doesn't connect irrespective if A is / isn't connected) . I use the same method for B, but it doesn't work. To be more specific, I can see the correct table in the input/import option, but when I run it, I see a "no columns returned".

Please help.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703