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 corresponding Cadenza feature must be enabled.
The following table shows which Cadenza features are required. Additional requirements for using this databases and geodata services are described in the user documentation.
| Feature Name | |
|---|---|
Relational Databases |
|
Oracle, Oracle Spatial and Graph |
|
PostgreSQL/EDB, PostGIS |
|
Microsoft SQL Server (MSSQL) |
|
SAP HANA |
|
H2 |
|
Search and Analysis Engines |
|
Elasticsearch |
|
OpenSearch |
|
Geodata Services |
|
WFS |
|
ArcGIS REST Feature Service |
|
Geo Data Services for Visualization in a Map View Only |
|
WMS, WMTS |
|
Vector Tiles |
|
ArcGIS REST Image/Map Service |
If the Cadenza feature is enabled, 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)
The following table shows the supported import formats with their associated file types and required Cadenza features. Files can also be provided and imported as archive files. Supported archive formats are ZIP and KMZ.
Additional requirements for importing files are described in the user documentation.
| Format | File Type | Feature Name |
|---|---|---|
CSV |
*.csv, *.txt |
|
Excel |
*.xlsx |
|
GPX (GPS Exchange Format) |
*.gpx |
|
GeoJSON |
*.json |
|
GeoPackage |
*.gpkg |
|
KML |
*.kml |
|
ODS |
*.ods |
|
Shapefile |
*.shp, *.dbf, *.shx, optional: *.cpg, *.prj |
|
Archive |
*.zip, *.kmz |
Depending on the format of the files contained (see above; 'KML' for *.kmz files) |
Requirements for Additional Features
To geocode postal addresses:
-
Cadenza feature Address geocoding must be enabbled.
-
A valid geocoder Configuration to connect to an address geocoding service, and optional a valid selfserviceoperationgeocoding Configuration.
Additional requirements for geocoding are described in the user documentation.
To geocode IP addresses:
-
Cadenza feature IP geocoding must be enabled.
-
A valid geocoderip Configuration to connect to an IP address geocoding service, and optional a valid selfserviceoperationgeocoderip Configuration.
Additional requirements for IP eocoding are described in the user documentation.