Apache NiFi can read from Oracle, land in HDFS as Apache ORC files for Hive, also send to Kafka. You can stream data but for Oracle right now there is no connection to its Write Ahead Logs, you have to point to tables and know how they are changing either a datetime increase or sequence id increase. Some people will create triggers to send data to special staging tables. Or add Attunity to Apache NiFi for pure CDC. see: https://community.hortonworks.com/articles/113941/change-data-capture-cdc-with-apache-nifi-version-1-1.html https://community.hortonworks.com/articles/81153/basic-cdc-using-apache-nifi-and-sap-hana.html https://community.hortonworks.com/articles/55422/change-data-capture-using-nifi.html https://community.hortonworks.com/articles/48843/slowly-changing-dimensions-on-hadoop-part-1.html https://community.hortonworks.com/articles/64122/incrementally-streaming-rdbms-data-to-your-hadoop.html https://community.hortonworks.com/articles/87632/ingesting-sql-server-tables-into-hive-via-apache-n.html https://community.hortonworks.com/articles/108718/ingesting-rdbms-data-as-new-tables-arrive-automagi.html
... View more
