repositorydatasourcetemplates

This configuration is optional when using the plugin Cadenza.

  • Documentation

  • YAML Format

  • XML Format

Fill relevant inputs (blue boxes) and click the blue bars on the left to copy XML configuration snippets.
<templates
>
required

Some data source settings are not available in the Management Center for security reasons, but can be configured (see Data Source Templates for Using in Management Center).

<template
<id
>
required

Template ID

xsd:string
</id>
<name
>
required
string

Display name of the template. This name is used in the selection list for the details of the data source server.

</name>
<url
>
required
string

URL of the data source

</url>
<type
>
required
string

The data source type. Allowed entries are either a database type or ARCGIS-REST, Wfs, ElasticSearch, OpenSearch, ogc-raster (for WMS and WMTS data sources), vector-tiles, arcgis-raster.

</type>
<credentials
>
optional

Optional: The credentials to use when connecting. If configured, it takes precedence before any credentials configured in the Management Center.

<userName
>
required
string

The user name to use when connecting to the data source.

</userName>
<password
>
required
string

The password to use when connecting to the data source. The password must be encoded using the Cadenza PasswordEncoder utility.

</password>
</credentials>
<driverName
>
optional
string

Full name of the JDBC driver of the RDBMS data source. Default value: the default driver for the database type..

</driverName>
<dataSourceProperties
>
optional

Configuration of properties that define data source-specific behavior.

Property Name Desciption Values

net.disy.pivot.comparison.collatorlanguage

Defines the collation language for the pivot transformation in memory, in which Cadenza compares and orders the string values (1)

e.g. de-DE, en-US (see IETF BCP 47 language tag strings)

net.disy.pivot.comparison.nullvalues

Defines the sorting behavior of Cadenza regarding NULL values for the pivot transformation in memory (1)

last, first (is default)

net.disy.client.direct.data.access

Defines the direct access of the Cadenza client to the WMS/WMTS server (2)

false, true (is default)

(1) Affects not only the pivot tables, but also all other visualization types that are based on the pivot table. With the exception of pivot transformations, Cadenza uses the behavior of the data source regarding the collation language and the null-comparison behaviour. (2) If credentials are required for the WMS/WMTS server, direct access is not possible. Any available feature information is also automatically requested indirectly via the Cadenza server.

<property
<name
>
required
string

The name of the property.

</name>
<value
>
required
string

The value of the property.

</value>
>
requiredmax. unbounded
</property>
</dataSourceProperties>
<connectionProperties
>
optional

Configuration of the properties to be used by the underlying data source connection. The properties are particular to each type of data source. These are usually JDBC driver connection properties, to be passed to the driver when creating a database connection and are particular to the specific type of database and driver. Typical usages for such connection properties are the fetch size for data sources that rely on JDBC. The use of these properties with non-JDBC data sources is currently unspecified and will be ignored.

<property
<name
>
required
string

The name of the property.

</name>
<value
>
required
string

The value of the property.

</value>
>
requiredmax. unbounded
</property>
</connectionProperties>
<routines
>
optional

Configuration of the routines for RDBMS data sources in database repositories. A routine is an arbitrary SQL statement to be executed when a JDBC connection is borrowed from the connection pool or returned to it.

<routine
xsd:string
executionPhase
required
=
xsd:string
borrow
return

Defines when the routine is executed. Possible values: borrow - On borrowing the connection from the connection pool return - On returning the connection to the connection pool

>
requiredmax. unbounded
</routine>
</routines>
>
optionalmax. unbounded
</template>
</templates>
This is a generated sample file with fake data and all the possible options shown, refer to the Documentation tab for what combinations are valid and what is required or not. 
cadenzaconfig:
  settings:
    repositorydatasourcetemplates:
      template:
      - id: "text"
        name: "text"
        url: "text"
        type: "text"
        credentials:
          userName: "text"
          password: "text"
        driverName: "text"
        dataSourceProperties:
        - name: "text"
          value: "text"
        - name: "text"
          value: "text"
        connectionProperties:
        - name: "text"
          value: "text"
        - name: "text"
          value: "text"
        routines:
        - executionPhase: "borrow"
          value: "text"
        - executionPhase: "borrow"
          value: "text"
      - id: "text"
        name: "text"
        url: "text"
        type: "text"
        credentials:
          userName: "text"
          password: "text"
        driverName: "text"
        dataSourceProperties:
        - name: "text"
          value: "text"
        - name: "text"
          value: "text"
        connectionProperties:
        - name: "text"
          value: "text"
        - name: "text"
          value: "text"
        routines:
        - executionPhase: "borrow"
          value: "text"
        - executionPhase: "borrow"
          value: "text"

Filename: repositorydatasourcetemplates-config.xml

This is a generated sample file with fake data and all the possible options shown, refer to the Documentation tab for what combinations are valid and what is required or not. 
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<templates>
  <template>
    <id>text</id>
    <name>text</name>
    <url>text</url>
    <type>text</type>
    <credentials>
      <userName>text</userName>
      <password>text</password>
    </credentials>
    <driverName>text</driverName>
    <dataSourceProperties>
      <property>
        <name>text</name>
        <value>text</value>
      </property>
      <property>
        <name>text</name>
        <value>text</value>
      </property>
    </dataSourceProperties>
    <connectionProperties>
      <property>
        <name>text</name>
        <value>text</value>
      </property>
      <property>
        <name>text</name>
        <value>text</value>
      </property>
    </connectionProperties>
    <routines>
      <routine executionPhase="borrow">text</routine>
      <routine executionPhase="borrow">text</routine>
    </routines>
  </template>
  <template>
    <id>text</id>
    <name>text</name>
    <url>text</url>
    <type>text</type>
    <credentials>
      <userName>text</userName>
      <password>text</password>
    </credentials>
    <driverName>text</driverName>
    <dataSourceProperties>
      <property>
        <name>text</name>
        <value>text</value>
      </property>
      <property>
        <name>text</name>
        <value>text</value>
      </property>
    </dataSourceProperties>
    <connectionProperties>
      <property>
        <name>text</name>
        <value>text</value>
      </property>
      <property>
        <name>text</name>
        <value>text</value>
      </property>
    </connectionProperties>
    <routines>
      <routine executionPhase="borrow">text</routine>
      <routine executionPhase="borrow">text</routine>
    </routines>
  </template>
</templates>