KDB Input Adapter

Adapter type: KDBInput. The KDB Input adapter reads kdb or kdb+tick database tables.

By default, the adapter matches the field names (in a case-insensitive manner) to determine the mapping between the source kdb+tick table and the target stream. The KDB Output adapter also supports custom field-mapping.

This adapter supports schema discovery.

If you use the CCL ATTACH ADAPTER statement to attach an adapter, you must supply the adapter type.

Property Label Property ID Type Description
KDB Server server string (Required) Specifies the name or IP address of the database server machine. Default value is localhost.
KDB Port port range (Required) Specifies the IP port of the database listener. Default value is 5001. Minimum value is 0, maximum value is 65535.
Event Stream Processor User ID espUser string (Optional) Specifies the user name for connecting to the Event Stream Processor. Default value is t.
Event Stream Processor Password espPassword password (Optional) Specifies the password for the Event Stream Processor user ID. If you are using RSA authentication, you can leave this property blank. Default value is t.
Authentication authentication choice (Optional) Specifies the method used to authenticate to the kdb or kdb+tick database tables. Valid values are:
  • value="user_password" label="username/password"
  • value="rsa" label="RSA"
  • value="kerberos" label="Kerberos V5"
No default value.
Project URI projectUri string (Optional) Specifies the URI to connect to a project in cluster environment. No default value.
RSA Key File rsaKeyFile filename (Optional) Specifies the RSA private-key file name and location. No default value.
KDB User user string (Optional) Specifies the user ID for the database connection. No default value.
KDB Password password password (Optional) Specifies the password for the database connection. No default value.

PropertySet

 propertyset string

(Advanced) Specifies the name of the property set from the project configuration file. If you specify the same properties in the project configuration file and the ATTACH ADAPTER statement, the values in the property set override the values defined in the ATTACH ADAPTER statement. No default value.
Source Table table tables (Advanced) Specifies the name of the source table to retrieve data from. This property supports SQL query statements.No default value.
Field Mapping permutation string

Mapping between Event Stream Processor and external fields, for example:

<esp_columnname>=<database_columnname>:<esp_columnname>=<database_columnname>. No default value.
Streaming Mode mode choice (Advanced) Specifies if the adapter should connect to a kdb+tick database and read in streaming data or execute the supplied query and feed the result to Event Stream Processor. Valid value list:
  • value="stream", label ="Stream"
  • value="pull", label="One time pull"
Default value is "stream".
Polling Interval pollInterval int (Advanced) Specifies the number of seconds to wait before reexecuting query in pull mode. If set to 0, the query is not reexecuted. Default value is 0.
Block Size blockSize int (Advanced) Specifies the number of records to block into one pseudotransaction. Default value is 64.
Async Mode async boolean (Advanced) If set to true, the adapter does not wait for an acknowledgement from Event Stream Processor that is received the data. Default value is false.
Encrypt Connection encrypt boolean (Advanced) If set to true, the traffic between Event Stream Processor and the adapter is encrypted. Default value is false.
Print Debug Info debug boolean (Advanced) Specifies if the adapter prints additional debugging information to the console. Default value is false.
Use Transaction Blocks useTransaction boolean (Advanced) For better performance, use transaction blocks instead of envelopes while sending data to Event Stream Processor. Default value is false.
Connection Retries connectionRetries int (Advanced) Specifies the number of times to retry connection if it breaks. Default value is 1.
Event Stream Processor Host Name gatewayHost string (Advanced) Specifies the explicit gateway host name. No default value.
Parameter File x_paramFile filename (Advanced) Specifies the file to write the parameters into, to pass to the external process. No default value.
Parameter File Format x_paramFormat choice (Advanced) Specifies the format in which the external process expects the parameters. Valid value list:
  • value = prop, label = "Java properties"
  • value= shell, label="Unix shell assignments"
  • value = xml, label = "Simple XML"
Default value is "prop".

Known limitations:

Parent topic: KDB Input and Output Adapter