Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
avinashu
Contributor
Contributor
‎2024-12-24 01:01 AM

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)
Labels

  • SQL

1,560 Views
1 Reply
Dave_Simo
Creator II
Creator II
‎2024-12-24 06:37 AM

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,

1,532 Views
0 Likes