Enterprise Administration Guide › Configuring SAM Endpoints › Prepare a JBoss Application to Use a Database (JDBC) Password Consumer › Customize the Datasource Configuration Files for Microsoft SQL Server

Customize the Datasource Configuration Files for Microsoft SQL Server

You can configure a JDBC database password consumer to replace hard-coded passwords in applications that use JDBC to connect to a Microsoft SQL Server database. Complete the following steps after you have prepared the endpoint to use a JDBC password consumer.

To customize the datasource configuration files for Microsoft SQL Server

1. Locate the <driver-class> tag and replace the default value with the JDBC driver class properties. For example:

   <driver-class>com.ca.ppm.clients.jdbc.CAJDBCDriver</driver-class>
   

2. Locate the <connection-url> tag and replace the default value with the database connection settings. For example:

   <connection-url>>@@@com.microsoft.sqlserver.jdbc.SQLServerDriver@@@jdbc:sqlserver://SQLServer1:1433;selectMethod=cursor;DatabaseName=tempdb</connection-url>
   

3. Start CA ControlMinder.

   You have customized the datasource configuration files to Microsoft SQL Server. You must now create a password consumer for the application in CA ControlMinder Enterprise Management. You start the application after you create the password consumer.