I was wondering if we can use the JTDS driver instead of Microsoft JDBC driver. I believe the driver can be replaced in JBOSS config (Haven't tried, please correct me if there is a different way), however, when using the connection string with JTDS the string start as "jdbc:jtds:sqlserver//" and this causes validation error while creating a new data source. Is there a way to turn off that validation?
The primary reason behind this is to use windows authentication (over NTLM) while connecting to a SQLServer database.
Discussion posts and replies are publicly visible
Arjun -
This is a good question. Right now you'll need to connect an authenticate to SQL Server according to the methods documented. Essentially, you'll need to select a well-entitled database service account per Data Source configuration, and it's that account that will access that data source for all Appian instantiated CRUD operations.
I would recommend you review the available documentation on the subject of Security, as I suspect this is a concern for you.
https://docs.appian.com/suite/help/19.4/Configuring_Security_for_Groups.html#overview
https://docs.appian.com/suite/help/19.4/User_Roles.html#overview
https://docs.appian.com/suite/help/19.4/securing-applications.html