How to configure Windows Authentication for MS SQL data source adapter in TIBCO Data Virtualization?

How to configure Windows Authentication for MS SQL data source adapter in TIBCO Data Virtualization?

book

Article ID: KB0073488

calendar_today

Updated On:

Products Versions
TIBCO Data Virtualization All Supported Versions

Description

The article explains the process of configuring MSSQL data source adapter in TDV Studio using the Windows Authentication method. This method can be helpful when multiple MSSQL server instances with Windows authentication needs to be configured.

Environment

All Supported Operating Systems

Resolution

The below JDBC properties need to be added in the Advanced Tab of the MSSQL data source adapter along with the basic configurations in the TDV Studio:

1. domainName: domain name
2. integratedSecurity: true
3. authenticationScheme: NTLM

Issue/Introduction

This article explains the steps to configure Windows Authentication for the built-in MS SQL data source adapter in TIBCO Data Virtualization.