Tag: python
Install ibm_db on Ubuntu
Ok so this one was a bit tricky. I needed to access remote DB2 databases using Python. I found ibm_db (page here) and followed the instructions. First you need to set up DB2 drivers : you can get it here (Data Server Driver Package, NOT the ODBC) or here here (I used this one). You [...]
Load various excel files into MySQL
I recently had to write a python script that was unzipping a an archive containing several excel files and then load the data of a specific sheet into a MySQL 5 database. Doing it with only SQL was not an option since it required some manual actions (saving the sheet as csv, which resulted in [...]