Skip to main content
September 22, 2022
Question

Appian with SQL Server connection

  • September 22, 2022
  • 1 reply
  • 0 views

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.

1 reply

September 23, 2022

Suggest you to go through from Configuring Relational Databases - Appian 22.3. You can create datasource from the Admin console as well.