Hi Jeremy, Have you tried the JDBC client? NiFi, being a Java application works with JDBC drivers, not ODBC.
https://code.kx.com/q/interfaces/jdbc-client-for-kdb/ After building the driver jar or obtaining a binary somehow, you can upload it to the nifi server in an accessible directory and create a DBCP ConnectionPool with the location of the jar file in the driver location and class name (I’m not sure what the class name is supposed to be, it looks like just “jdbc”). Regards, Isha Van: Jeremy Pemberton-Pigott <[email protected]> Verzonden: dinsdag 22 november 2022 09:22 Aan: [email protected] Onderwerp: ODBC with unixODBC in Linux Hi, has anyone had success using unixODBC to make an ODBC connection to a DB that supports this mode of connection in Linux (CentOS/Debian). We are trying to connect NiFi to Kx's kdb+ and this is the initial feedback that they gave to connect to the time series database. Or has anyone connected to kdb from NiFi on Linux? Reference page: https://code.kx.com/q/interfaces/q-client-for-odbc/<https://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Fcode.kx.com%2Fq%2Finterfaces%2Fq-client-for-odbc%2F&data=05%7C01%7Cisha.lamboo%40virtualsciences.nl%7C37174305610a4b51e9bb08dacc62aaa8%7C21429da9e4ad45f99a6fcd126a64274b%7C0%7C0%7C638047021403555588%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=q1%2BMvj5hXzPgJKLV7Xju2hU5DpmSEeNMMvWKyZ9eD%2Fw%3D&reserved=0> Jeremy
