Kinetica Reader/Writer for FME

Overview

This Kinetica reader and writer plug-in enables FME to read attribute data from Kinetica and write attribute data to 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 coordinates as WMS maps and have functions which operate on them.

The connector API, source code, and install/config instructions can be found at:

Kinetica Quick Facts

Format Type IdentifierKINETICA
Reader/WriterBoth
Licensing LevelFME Professional Edition & up
Typical File ExtensionsN/A
Generic Color SupportN/A
Schema RequiredYes
Transaction SupportNo
Geometry Type AttributeWKT

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

reader_params

  • URL: The URL of the Kinetica server (ex. https://<aws.fqdn>/<aws.cluster.name>/gpudb-0).
  • 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. See Expressions for details.
  • Username: The username to use in authenticating to Kinetica.
  • Password: The password to use in authenticating to Kinetica.

reader_add

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

Kinetica Writer Parameters

writer_params

  • URL: The URL of the Kinetica server (ex. https://abcdefg.cloud.kinetica.com/hijklmn/gpudb-0;CombinePrepareAndExecute=1;RowsPerFetch=20000).
  • Table: The name of the table to write to.
  • Collection: The name of the schema containing the target table. This is an optional parameter. It is only needed if you would like to create the table in a specific schema; otherwise, the default schema will be used.
  • 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. Available when Write Geometry is checked.
  • X Field Name: The name of the field to insert longitude data into. The Kinetica WMS service assumes longitude is stored in the field x, but another field name can be specified. Available when Write Points is checked.
  • Y Field Name: The name of the field to insert latitude data into. The Kinetica WMS service assumes latitude is stored in the field y, but another field name can be specified. Available when Write Points is checked.
  • Username: The username to use in authenticating to Kinetica.
  • Password: The password to use in authenticating to Kinetica.

writer_add

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

Kinetica Reader and/or Writer Feature Type: User Attributes

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

The User Attributes of the Feature Type are listed on the User Attributes tab.

feature_type_props

The Kinetica writer supports the following types:

  • int8
  • int16
  • int32
  • int64
  • real32
  • real64
  • string
  • date
  • time
  • datetime
  • IPv4
  • decimal
  • timestamp
  • WKT

Additionally, you can specify fields as primary_key, and give them data handling properties like text_search, disk_optimized, and store_only.

Testing

Data in Kinetica can be viewed and edited through Workbench.