Skip to main content Skip to complementary content

JSON: Existing source

Adding a new JSON entity to an existing source

Select radio button: To existing Source

This will kick off the Add Data wizard to define a new entity within an existing source.

Source wizard select add data to existing source

Select Source Name from dropdown. This is the source that the new entity will be added to.

Entity Level: Specify level of data management

(see System Settings: Level Control)

The default level for the source will populate in the dropdown and this can be modified and applied to new entities.

Base Directory: Pre-defined (This is the directory where data will be stored in file system)

Groups: Select Group(s) requiring access from the dropdown options. At least one group must be added for the data to be discoverable.

Click Next.

Complete source configuration fields

File Format

File Path (or Kafka Topic Name when adding Entities to Existing Kafka JSON sources) For non-Kafka sources, enter the file path (to the originating external source, ending with the file name and file format suffix.

In the case of Kafka (this example) the Entities (tables) display Preview of fields.

Enter entity data filepath and JSON definition language file

Make sure the JSON Definition File is viewable: View JSON Definition File

Select view of JSON definition file to ensure HEN file is parsed

Select Entities & Fields

The entities specified within the .hen validation file display; this step allows the user to select the entities to generate (with ability to rename).

Select Fields Metadata Preview.

Information note

JSON fields can be selected and renamed but not added or removed.

Select entities to ingest

Fields Metadata Preview

Enitities can be renamed upon selection

Internal file format Type

Options include:

  • AVRO
  • ORC

Qlik Catalog Stored Format Type step is skipped for single node environments where stored format is always TEXT_TAB_DELIMITED.

Specify stored file format

Load Data to the Entity(s). Once the Entity has been saved, navigate to Entities screen in Source to load the data.

Select Load from the More dropdown.

Load data to the entity

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!