Kinetica Reader/Writer

Overview

The Kinetica reader and writer plug-in enables FME to read attribute data from Kinetica and write attribute data Kinetica. In Kinetica, general geometric data can be stored as WKT in a standard string field and geometric points can be stored as a pair of float fields. While there are no specific geometric field types, Kinetica can render WKT and longitude,latitude points as WMS maps and have functions which operate on them.

Kinetica Quick Facts

Format Type Identifier	KINETICA
Reader/Writer	Both
Licensing Level	FME Professional Edition & up
Typical File Extensions	N/A
Generic Color Support	N/A
Schema Required	Yes
Transaction Support	No
Geometry Type Attribute	WKT

Kinetica Geometry Support

Kinetica supports any geometry which can be expressed in WKT format. Additionally, point data can be stored in longitude and latitude fields.

Kinetica Reader Parameters

• URL: The URL of the Kinetica server (ex. http://localhost:9191).

• Table: The name of the table to read from.

• Expression: An optional Kinetica filter expression.

  This parameter is only needed if you wish to filter data from the source table, rather than read the whole table. For details on Kinetica expressions, see HTTP://www.kinetica.com/docs/concepts/index.html#expression .

• Username: The username to connect to Kinetica.

  This parameter is only needed if security is enabled on the Kinetica instance you are connecting to.

• Password: The password to connect to Kinetica.

  This parameter is only needed if security is enabled on the Kinetica instance you are connecting to.

• Dataset: Each reader must be given a unique Dataset name.

Kinetica Writer Parameters

• URL: The URL of the Kinetica server (ex. http://localhost:9191)

• Table: The name of the table to write to.

• Collection: The name of the collection to insert the table into.

  This is an optional parameter. It is only needed if you would like to create the table in a collection, which is similar to a MySQL database schema.

• Geometry Field Name: The name of the field to insert the WKT representation of the geometry into.

  If you will be using the Kinetica WMS service, this field should be named “WKT”

• X Field Name: The name of the field to insert point data longitude into.

  The Kinetica WMS service assumes longitude is stored in the field “x”, but another field name can be specified.

• Y Field Name: The name of the field to insert point data latitude into.

  The Kinetica WMS service assumes latitude is stored in the field “y”, but another field name can be specified.

• Username: The username to connect to Kinetica

  This parameter is only needed if security is enabled on the Kinetica instance you are connecting to.

• Password: The password to connect to Kinetica

  This parameter is only needed if security is enabled on the Kinetica instance you are connecting to.

Kinetica Reader and/or Writer Feature Type: User Attributes

To access User Attributes, open the Feature Type dialog by clicking the gear button on a feature type in the workspace. These parameters are applicable only to the selected feature type.

User Attributes describe the Feature Type properties User Attributes tab.

The Kinetica writer supports the following types:

Int16, int32, int64, real32, real64, string, and datetime

Additionally, you can specify fields as primary_key, text_search, disk_optimized, and store_only. For information on these properties, see https://www.kinetica.com/docs/concepts/types.html#column-properties .

Troubleshooting

Data in Kinetica can be viewed and edited through the Kinetica Administration application (see http://www.kinetica.com/docs/gpudbAdmin/gadmin.html).