Skip to main content
SUBMITTED

Azure AD login options for [Azure Data Factory - SQL Server] connector

Related products:TimeXtender Data Integration
  • September 14, 2023
  • 0 replies
  • 11 views

rogier.helmus
Problem Solver
Forum|alt.badge.img+1

Hi all,

When the TimeXtender environment is in Azure and you want to connect to an on-premise SQL database using the “Azure Data Factory - SQL Server” connection in combination with a Self-Hosted Integration Runtime is the only option. Unfortunately this connection only has the option to connect to the SQL database via a SQL account.

At some clients I work and have worked for the use of SQL accounts for connections to databases has been prohibited. Therefore I would like to have all Azure AD login options added to this connector in the current and legacy (20.10.x) TX release. 

Greets, Rogier

 

Screenshot "Azure Data Factory - SQL Server” connection config: