> ## Documentation Index
> Fetch the complete documentation index at: https://docs.kinetica.com/llms.txt
> Use this file to discover all available pages before exploring further.

# 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](/content/location_intelligence/geo_objects#geometry-types) 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](/content/api/rest/wms_rest) maps and have functions which operate on them.

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

* [https://github.com/kineticadb/kinetica-connector-fme](https://github.com/kineticadb/kinetica-connector-fme)

## 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

<img src="https://mintcdn.com/kinetica/sjJMVofFVyzBN4Br/content/connectors/FMEReaderParams.jpg?fit=max&auto=format&n=sjJMVofFVyzBN4Br&q=85&s=52ba2fb082b30dd31a6cd89080171872" alt="reader_params" width="424" height="249" style={{display: "inline", margin: 0, verticalAlign: "middle"}} data-path="content/connectors/FMEReaderParams.jpg" />

* **URL**:  The URL of the *Kinetica* server (ex. http\://\<db.host>: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. See [Expressions](/content/concepts/expressions) for details.

* **Username**: The username to use in authenticating to *Kinetica*.

* **Password**: The password to use in authenticating to *Kinetica*.

<img src="https://mintcdn.com/kinetica/sjJMVofFVyzBN4Br/content/connectors/FMEReader.jpg?fit=max&auto=format&n=sjJMVofFVyzBN4Br&q=85&s=d527da10ad5f7210c4360a605a9ba781" alt="reader_add" width="418" height="241" style={{display: "inline", margin: 0, verticalAlign: "middle"}} data-path="content/connectors/FMEReader.jpg" />

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

## Kinetica Writer Parameters

<img src="https://mintcdn.com/kinetica/sjJMVofFVyzBN4Br/content/connectors/FMEWriterParams.jpg?fit=max&auto=format&n=sjJMVofFVyzBN4Br&q=85&s=3606d51d9bb9702b645e7ad64f945368" alt="writer_params" width="344" height="345" style={{display: "inline", margin: 0, verticalAlign: "middle"}} data-path="content/connectors/FMEWriterParams.jpg" />

* **URL**:  The URL of the *Kinetica* server (ex.
  [http://localhost:9191;CombinePrepareAndExecute=1;RowsPerFetch=20000](http://localhost:9191;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*.

<img src="https://mintcdn.com/kinetica/sjJMVofFVyzBN4Br/content/connectors/FMEWriter.jpg?fit=max&auto=format&n=sjJMVofFVyzBN4Br&q=85&s=237f5d2c8c3343fb69253e8ccc00b023" alt="writer_add" width="355" height="247" style={{display: "inline", margin: 0, verticalAlign: "middle"}} data-path="content/connectors/FMEWriter.jpg" />

* **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 <img src="https://mintcdn.com/kinetica/sjJMVofFVyzBN4Br/content/connectors/FMEgear.png?fit=max&auto=format&n=sjJMVofFVyzBN4Br&q=85&s=79f3979c12514fbd31a602c617c79529" alt="gear" width="20" height="20" style={{display: "inline", margin: 0, verticalAlign: "middle"}} data-path="content/connectors/FMEgear.png" /> 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.

<img src="https://mintcdn.com/kinetica/sjJMVofFVyzBN4Br/content/connectors/FMEFeatureTypeProperties.jpg?fit=max&auto=format&n=sjJMVofFVyzBN4Br&q=85&s=ad9621e5b53c82db022c76bc7e8e9d0c" alt="feature_type_props" width="807" height="682" style={{display: "inline", margin: 0, verticalAlign: "middle"}} data-path="content/connectors/FMEFeatureTypeProperties.jpg" />

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](/content/concepts/tables#primary-key),
and give them [data handling properties](/content/concepts/types#types-data-handling) like
**text\_search** and **dict**.

## Testing

Data in *Kinetica* can be viewed and edited through
[GAdmin](/content/admin/gadmin).