Sample SQL Server connection configuration for the Ignite caching configuration

The Ignite caching configuration is found in a file called cache-conf.xml. This configuration contains a section, <property name="dataSource">, in which the connection to the database is configured. This topic shows a sample section, which you can use to connect to a Microsoft SQL Server database.

Here's the section, configured for Microsoft SQL Server:
<property name="dataSource">
  <bean class="com.zaxxer.hikari.HikariDataSource">
    <property name="poolName" value="ignite-ipfinder-pool"/>
    <property name="maximumPoolSize" value="1"/>
    <property name="dataSourceClassName" value="com.microsoft.sqlserver.jdbc.SQLServerDataSource"/>
    <property name="username" value="TridionBrokerUser"/>
    <property name="password" value="8%oTU2^z80Ge"/>
    <property name="dataSourceProperties">
      <bean class="com.sdl.delivery.ignite.FilteredDataSourcePropertiesFactory">
        <property name="dbClass" value="com.microsoft.sqlserver.jdbc.SQLServerDataSource"/>
        <property name="dataSourceProperties">
          <props>
            <prop key="serverName">staging.example.com</prop>
            <prop key="portNumber">1433</prop>
            <prop key="databaseName">Tridion_Broker</prop>
            <!-- SQL Server specific properties -->
            <prop key="encrypt">${dbencrypt:false}</prop>
          </props>
        </property>
      </bean>
    </property>
  </bean>
</property>

If you want to use your own discovery settings instead of this sample, refer to the following Ignite documentation: https://ignite.apache.org/docs/latest/clustering/tcp-ip-discovery