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
Suggest you to go through from Configuring Relational Databases - Appian 22.3. You can create datasource from the Admin console as well.