How to setup a IBM DB2 connection

[Kaustubh17]

Hi team,

Please request your help or guidance to setup a IBM DB2 Connection with Alteryx. i am not getting any proper documentation or step by step process to setup the connection. Request your help.

Best Regards,

Kaustubh

[Raj]

@Kaustubh17 
To connect IBM DB2 with Alteryx, you need to download the IBM Data Server Driver for ODBC and CLI. This driver is available for both 32-bit and 64-bit systems

1. Install the IBM DB2 ODBC Driver:

   • Download the ODBC driver from the IBM website.
   • Install the driver on your machine.

2. Configure the ODBC Data Source:

   • Open the ODBC Data Source Administrator on your computer.
   • Go to the “System DSN” tab and click “Add”.
   • Select the IBM DB2 ODBC driver and click “Finish”.
   • Fill in the required details such as Data Source Name (DSN), Description, and Database alias.
   • Test the connection to ensure it is working correctly.

3. Set Up the Connection in Alteryx:

   • Open Alteryx Designer.
   • Drag an Input Data tool onto the canvas.
   • In the configuration window, select “ODBC” from the Data Source drop-down menu.
   • Choose the DSN you created earlier from the list.
   • Enter your DB2 credentials (username and password).
   • Click “OK” to establish the connection.

[Kaustubh17]

Hi @Raj 

Thanks for sharing the valuable information:

i have few questions:

• Which driver should i download(version)
• When i download the driver i get the zip file.
• Don't understand what to do next because in ODBC it directly shows in the user DSN or system DSN but its not showing. 
• Can you share the exact driver details.

Best Regards,

Kaustubh

[Raj]

@Kaustubh17 
try the latest one
IBM Support: Fix Central: IBM Data Server Client Packages: *odbc_cli-*FP000

[ann1]

Hello

I tried to connect DB2 DB and it popped up error as below:

and I installed the DB2 ODBC driver as you mentioned link, but our DB2  version is V7R5.

this error means Unable to locate program input point? GetfuncAddress ......in dynamic link library E: \ Tool \...

 After I click ok button, and another different error message popped up as below:

the error means ： Internal error SQLDriveConnect: [Microsoft] [ODBC Driver Manager] Data source name not found and default driver not specified

and ODBC config as below:

Could you please help check this issue?

Thanks a lot