Licensing options for this format begin with FME Desktop Professional Edition.
The Qlik Connector Reader allows FME to read QlikJSON (Qlik JavaScript Object Notation) documents.
Overview
QlikJSON allows users to import their data from Qlik Sense to FME. Qlik Sense users may use the Qlik Engine JSON API to extract their spatial data and import it into FME using the QlikJSON reader. The extracted JSON document from the Qlik Engine will contain spatial data stored in identical fashion to the GeoJSON (Geographic JavaScript Object Notation) Reader/Writer format.
For more information about Qlik Sense, see the Qlik Help documentation.
Qlik Connector Quick Facts
|
Format Type Identifier |
QLIKCONNECTOR |
|
Reader/Writer |
Reader |
|
Professional and above |
|
|
Dependencies |
None |
|
Dataset Type |
JSON file |
|
Feature Type |
Varies: schema is dependent on the source dataset |
|
Typical File Extensions |
.json |
|
Automated Translation Support |
Yes |
|
User-Defined Attributes |
Yes |
|
Coordinate System Support |
No |
|
Generic Color Support |
No |
|
Spatial Index |
Never |
|
Schema Required |
No |
|
Transaction Support |
No |
|
Geometry Type |
json_type |
Qlik Connector Geometry Support
|
Geometry |
Supported? |
|---|---|
|
aggregate |
yes |
|
circles |
no |
|
circular arc |
no |
|
clothoid |
no |
|
donut polygon |
yes |
|
elliptical arc |
no |
|
ellipses |
no |
|
line |
yes |
|
none |
yes |
|
point |
yes |
|
polygon |
yes |
|
raster |
no |
|
solid |
no |
|
surface |
no |
|
text |
no |
|
z values |
no |
Reader Overview
The Qlik Connector reader produces an FME feature type for each QlikJSON file. QlikJSON files are saved JSON responses from the Qlik Engine JSON API.
The general layout of the JSON file extracted from Qlik Sense is a generic object which contains a HyperCube. The HyperCube contains an array of spatial data stored in the GeoJSON format. The QlikJSON reader extracts this array of spatial data and transforms it into a list of spatial features.
Data Extraction
Extracting data from Qlik Sense requires a degree of understanding and knowledge on how data in Qlik Sense is stored and structured. At the top level, there is the global object which then contains a doc object, and that doc object will contain a number of AppObjects. For more information, please refer to the topic Generic Objects in Qlik Sense help documentation.
The data file can be extracted by executing commands using the Qlik Engine JSON API.
In the Qlik Engine JSON API, navigate to the list of generic objects and retrieve the generic object that contains the spatial data. The resulting JSON response then can be saved to a file and read into FME using the Qlik Connector reader.