Enabling Access to Data

Access to Databases and Geodata Services

Cadenza enables access to data databases and geodata services (see Supported Data Sources (Overview)). Depending on the database or geodata service, a plugin must be activated for access.

The following table shows which plugins need to be activated. Additional access requirements may need to be met.

Plugin

Relational Databases

Oracle, Oracle Spatial and Graph

Gis_DataSource_Oracle

PostgreSQL/EDB, PostGIS

Gis_DataSource_PostGis

Microsoft SQL Server (MSSQL)

–

SAP HANA

DataSource_SapHana

H2

–

Search and Analysis Engines

Elasticsearch

DataSource_Elastic

OpenSearch

DataSource_OpenSearch

Geodata Services

WFS

Gis_DataSource_Wfs

ArcGIS REST Feature Service

Gis_DataSource_ArcGisRest

Geo Data Services for Visualization in a Map View Only

WMS

Gis_DataSource_Wms

WMTS

Gis_DataSource_Wtms

Vector Tiles

–

ArcGIS REST Image/Map Service

DataSource_ArcGis_Raster

By activating the plugin, authorized users can add a Cadenza data source in the Management Center so that Cadenza can access the database or geodata service. The URL and other access information are entered either manually or via a data source template.

Access to Files (via Import into the Cadenza Data Store)

Format File Type Plugin System Privilege

Excel

*.xlsx

Import_Office

Import Excel and CSV files

CSV

*.csv, *.txt

Import_Office

Import Excel and CSV files

Shapefile

*.shp, *.dbf, *.shx, optional: *.prj, *.cpg

Gis_Datasource_Shapefile

Import shapefiles

KML

*.kml

Kml

Importing KML files

GPX

*.gpx

Import_Temporal_Data

–

GeoPackage

*.gpkg

GeoPackage

Import GeoPackage files

ZIP, KMZ

Directories in an archive file are supported, but not archives in archives

*.zip, *.kmz

depending on the format of the files contained (see above)

Import archive files

GeoJSON

Import via Cadenza API-only

*.geojson

Import_GeoJson

Import GeoJSON data as a layer (via Cadenza API only)

Further Requirements