Skip to Main Content
Spotfire Ideas Portal
Status Implemented
Categories data sources
Created by Guest
Created on May 31, 2023

Azure SQL DB pre-connection checkout procedure

Provide support for Azure SQL DB using Hyperscale. Provide the ability to define a pre-connection checkout procedure that can be used to modify the connection string prior to checking out a connection. For Azure SQL DB Hyperscale, it would dynamically switch the context of the Read-Write primary and the Read-Only replicas to achieve better performance. TDV caching and data ship would use ApplicationIntent=ReadWrite and user queries would use ApplicationIntent=ReadOnly in the connection string at the time of connection checkout.

Example connection string: jdbc:sqlserver://myserver.database.windows.net:1433;databaseName=mydb;selectMethod=direct;encrypt=true;trustServerCertificate=true;ApplicationIntent=ReadWrite

or

jdbc:sqlserver://myserver.database.windows.net:1433;databaseName=mydb;selectMethod=direct;encrypt=true;trustServerCertificate=true;ApplicationIntent=ReadOnly

  • Attach files