# Applying OPPSA compatibility configuration changes

Users must apply OPPSA compatibility configuration changes to their appropriate Expere distributed or hosted installation package. This allow their Expere instance to connect to the Expere OPPSA database to receive policy and organization data and FileSystem content.

## .NET Installations

.NET users must enter the Expere database information in the `bsi.properties` file.

In the `bsi.properties` file, update the following lines with your Expere database values:

    ## Expere data source JNDI name
    com.bankerssystems.expere.db.DataSourceName=java:comp/env/jdbc/ExpereDataSource
    com.bankerssystems.expere.db.Host=MyDatabaseServerName
    com.bankerssystems.expere.db.Port=1433
    com.bankerssystems.expere.db.Sid=MyExpereDatabase
    com.bankerssystems.expere.db.User=DbUsername
    com.bankerssystems.expere.db.Pass=DbPassword

## JBoss/Wildfly installations

JBoss/Wildfly usrs must add the Expere database information to the `standalone.xml` file located at `wildfly-10.0.0.Final\standalone\configuration\` on their installation media. In the `standalone.xml` file, update the following lines with your Expere database values:

- `<connection-url>jdbc:jtds:sqlserver://MyDatabaseServerName:1433;DatabaseName=MyExpereDatabase</connection-url>`
- `<user-name>DbUsername</user-name>`
- `<password>DbPassword</password>`

Datasources section of `standalone.xml`:

    <subsystem xmlns="urn:jboss:domain:datasources:4.0">
     <datasources>
     <datasource jta="true" jndi-name="java:/jdbc/ExpereDataSource" pool-name="ExpereDataSource" enabled="true" use-java-context="true" use-ccm="true">
     <connection-url>jdbc:jtds:sqlserver://MyDatabaseServerName:1433;DatabaseName=MyExpereDatabase</connection-url>
     <driver>jTDS</driver>
     <transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation>
     <pool>
     <min-pool-size>100</min-pool-size>
     <max-pool-size>300</max-pool-size>
     <prefill>true</prefill>
     <use-strict-min>false</use-strict-min>
     <flush-strategy>FailingConnectionOnly</flush-strategy>
     </pool>
     <security>
     <user-name>DbUsername</user-name>
     <password>DbPassword</password>
     </security>
     <statement>
     <prepared-statement-cache-size>100</prepared-statement-cache-size>
     <share-prepared-statements>true</share-prepared-statements>
     </statement>
     </datasource>
     <drivers>
     <driver name="jTDS" module="net.sourceforge.jtds">
     <driver-class>net.sourceforge.jtds.jdbc.Driver</driver-class>
     <xa-datasource-class>net.sourceforge.jtds.jdbcx.JtdsDataSource</xa-datasource-class>
     </driver>
     </drivers>
     </datasources>
     </subsystem>