How to specify Active Directory credentials when connecting to MSSQL data source

Created
October 08, 2021 23:25

Date Posted: 2018-07-31
Product: TIBCO Spotfire®

Problem:

Solution:

How to specify Active Directory credentials when connecting to MSSQL data source 1. Open Studio ==> Select any folder open "Create New Data Source" ==> Now select "New Adapter" using the Microsoft SQL Server <2012> parent adapter
2. Modify Adapter Class Name to: net.sourceforge.jtds.jdbc.Driver
3. Modify Connection URL Pattern to: jdbc:jtds:sqlserver://localhost:1433/<db>;tds=8.0;lastupdatecount=true
e.g. jdbc:jtds:sqlserver://dvbu-msq-005.dv.local:1433/Northbay;tds=8.0;lastupdatecount=true
****Please provide actual values of host_name, port and database
4. Download jtds.jar from MS site and copy the jTDS driver to /conf/adapters/custom/<name of the new adapter>
5. Restart CIS
6. Create a new data source from the new adapter
7. Supply details: database name, port, database name, authentication domain, login without domain name, password
8. Add a JDBC property in the Advanced data source tab
Property: domain and value
9. Introspect - this should use the supplied credentials in the data source panel