Although Attunity supports replication to HDFS and Hive, both of these targets fail to work with DDL changes and updates/deletes in the data because of their nature. Hive is getting there but we are not using Hortonworks so we cannot use that functionality. What we can use is Kudu and although there is no endpoint, it would be an option to leverage the Impala ODBC to speak SQL to Kudu. This would require setting up a ODBC endpoint in Attunity and probably some advanced settings to bridge possible gaps in SQL statements.

Did anyone try this option? Or did anyone try to connect via ODBC to some other non-supported database and therefore has some insights to share?