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