search

getredash / redash

Make Your Company Data Driven. Connect to any data source, easily visualize, dashboard and share your data.
http://redash.io/
BSD 2-Clause "Simplified" License
25.5k stars 4.31k forks source link

Add DB2 for i support #5894

Open doudz opened 1 year ago

doudz commented 1 year ago

Currently redash support db2 using ibm_db_dbi but it requires a special license

But db2 could be use with pyodbc using the ibm-iaccess for Linux ODBC

Driver could be found here : https://www.ibm.com/support/pages/ibm-iaccess-linux-odbc-configuration

doudz commented 1 year ago

I made it and it works good If my company decide to use redash I will make a fork and publish a pull request

grahamgraham commented 1 week ago

I made it and it works good If my company decide to use redash I will make a fork and publish a pull request

Hello! I'm in a situation where we are using the iseries, and I cannot get a successful connection, short of the DB2 connection which as you stated requires a license.

How were you able to get it to work? Which container did you install the drivers to?

I did something similar with SuperSet, and was able to install the iaccess client using 'pip install iaccess', and that worked using pyodbc. I've tried that and it's not working for redash.