Appian with SQL Server connection

Hi,

I have below setting

customer.properties.

conf.data.APPIAN_DATA_SOURCE=jdbc/SqlServerDataSource

 tomcatResources.xml

<Resource name="jdbc/SqlServerDataSource"
factory="com.appiancorp.tomcat.datasource.EncodedPasswordDataSourceFactory"
type="javax.sql.DataSource"
driverClassName="com.microsoft.sqlserver.jdbc.SQLServerDriver"
url="jdbc:sqlserver://xyz.nam.nsroot.net:2431;databaseName=TestDB"
username="xxx"
password="xxx"
..
/>

Now, by using above settings, how can I connect to the database. Do I need to use any specific object to read these properties and form a connection string or do I need to follow any other process.

Can someone advise.

Thanks.

  Discussion posts and replies are publicly visible