Reads data from a KDB database table into an Event Stream Processor stream.
The esp_kdbin adapter reads data from a KDB database into a stream in the Event Stream Processor. You can configure the adapter to read either queried or streaming data, based on a configuration parameter.
By default, the adapter matches the field names (in a case-insensitive manner) to decide the mapping between the source KDB table and the target stream. You also have the option of explicitly specifying the mapping.
esp_kdbin -H [kdbhost:]kdbport -p [host:]port -q source -s stream -c user[:password] [OPTION...]
esp_kdbin -p 1190 -H myServer:9200 -q KdbTrades -s SpTrades
esp_kdbin -p 1190 -H myServer:9200 -q KdbTrades -s SpTrades \ -M SpId=KId:SpSymbol=KSymbol:SpPrice=KPrice:SpCount=KCount
esp_kdbin -p outputServer:1221 -H myServer:9200 -q 'select Id, Symbol, Price, Count from KdbTrades' \ -s SpTrades -m -I 5