How to specify Active Directory credentials when connecting to MSSQL data source
book
Article ID: KB0081228
calendar_today
Updated On:
Products
Versions
TIBCO Data Virtualization
7.0.5,7.0.6+
Description
How to specify Active Directory credentials when connecting to MSSQL data source
Resolution
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
Issue/Introduction
How to specify Active Directory credentials when connecting to MSSQL data source