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
Verzonden: dinsdag 22 november 2022 09:22
Aan: users@nifi.apache.org
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%7C63804702140388%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=q1%2BMvj5hXzPgJKLV7Xju2hU5DpmSEeNMMvWKyZ9eD%2Fw%3D&reserved=0>
Jeremy
