repositoryDataSourceTemplates

<templates
>
required

Certain data source settings are not available in the Management Center for security reasons, but can be configured. You can create a template for each affected data source, which can then be selected and added to in the Management Center. Data source URL is not visible 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

Data source type. Allowed entries are Oracle, PostgreSQL, MSSQL, SapHana, H2, ARCGIS-REST, Wfs, ElasticSearch, OpenSearch, ogc-raster (for WMS and WMTS data sources), vector-tiles.

</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 the properties defining data source specific behaviour. Typical usages for such data source properties are currently the language for pivot comparison collation and pivot comparison null value handling. Data source properties can either be defined in this template here or be stored with the data source in the database repository but not in both places. For each specific property the code defines where configuration is allowed from.

<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>