Skip to main content
Announcements
Qlik Insider: Product Roadmap Edition on March 3, 1 PM ET: REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
avinashu
Contributor

Connect to ReadOnly MS-SQL Server Database through tdbinput

I'm trying to connect to the ReadOnly instance of an MS-SQL Server database using tdbinput, and I've set the "Additional JDBC Parameters" in the advanced settings to "ApplicationIntent=ReadOnly". However, when I check the query output, it still shows that it's connecting to the READ_WRITE instance.

I tested the same connection with "ApplicationIntent=ReadOnly" in SSMS, and it worked fine, showing that I was connected to the READ_ONLY instance.

Has anyone encountered a similar issue or can suggest a solution for connecting to the ReadOnly instance using tdbinput?

avinashu_0-1735019542714.png

avinashu_1-1735019587177.pngavinashu_2-1735019736973.png

 

 

Labels (1)
  • SQL

1 Reply
Dave_Simo
Creator

Hello,


I don't know if it will work but try connecting with a tDBconnexion/tDBInput component in JDBC

Dave_Simo_0-1735040017205.png

Best Reagrds,