To add the ATGProductionDS datasource to the ATGStaging server:

<xa-datasource enabled="true" jndi-name="java:/ATGProductionDS"
pool-name="ATGProductionDS" use-java-context="true">
    <xa-datasource-property name=
"URL">jdbc:sqlserver://localhost:1433;databaseName=name;
sendStringParametersAsUnicode=false;</xa-datasource-property>
    <xa-datasource-property name="User">name</xa-datasource-property>
    <xa-datasource-property name="Password">password</xa-datasource-property>
    <xa-datasource-class>com.microsoft.sqlserver.jdbc.SQLServerXADataSource
</xa-datasource-class>
    <driver>sqljdbc4.jar</driver>
    <security>
        <user-name>name</user-name>
        <password>password</password>
    </security>
    <xa-pool>
        <min-pool-size>5</min-pool-size>
        <max-pool-size>100</max-pool-size>
        <is-same-rm-override>false</is-same-rm-override>
    </xa-pool>
    <timeout>
        <blocking-timeout-millis>5000</blocking-timeout-millis>
        <idle-timeout-minutes>15</idle-timeout-minutes>
    </timeout>
    <!-- To avoid deadlocks you need set this -->
    <transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation>
</xa-datasource>