Knowing this is a pretty broad question but does anyone know of a general odbc tap?

I'm not aware of one, but https://github.com/singer-io/tap-db2 uses ODBC, so that could serve as a starting point if you'd like to use a different driver or create a generic tap