Kafka Batch Streamer

1. Login to https://nextbestactionhubs.com/shop and order a key

2. Download the KafkaStreamer_app.zip file

3. Unzip the file into the server directory

4. Configure the sample configuration run script file based on the table above

5. Execute run script with a sample selection

   1. Set SourceQuery to return a small sample of data

   2. Test SourceQuery in SQL client before execution

Alias : Important info for Oracle DB

When defining sourcequery for the Oracle database remember to define an alias for each property.

The format of the alias should be : <alias_name>_dot_<tablename>_

This is because the Oracle JDBC driver does not support getTableName

Example,

select customerID customerid_dot_customertable_, name firstname_dot_customertable_

from customertable