Connecting Talend to an MS SQL Server DB always on with 'applicationIntent=ReadOnly'

Anonymous — Sat, 16 Nov 2024 03:23:25 GMT

Hi,

i'm trying to connect to Micorsoft SQL Server DB always on with applicationIntent=ReadOnly from Talend ( in order to connect to the secondary server and not to the primary by using "Availability groups" in sql server )

i'm using Talend Big Data Version: 6.5.1.

But although i have added 'applicationIntent=ReadOnly' in the string connection and replaced Talend competent to jdbc ( please see attachment),

when i checked in sql server, the talend user was connected to the wrong server ,to the primary and not to the secondary server.

What i tried so far:

1. Download sqljdbc4.jar and connect via tJDBCConnection

2. setting connection string as : "jdbc:sqlserver://hostserver:1433;databaseName=mydb;applicationIntent=ReadOnly"

3.driver class: "com.microsoft.sqlserver.jdbc.SQLServerDriver

Reference (didn't worked for me): http://kindleconsulting.com/blog/item/155-ms-sql-server-talend-applicationintent-readonly-disasater-recovery-mode.html

thanks

topic Connecting Talend to an MS SQL Server DB always on with 'applicationIntent=ReadOnly' in Talend Studio

Connecting Talend to an MS SQL Server DB always on with 'applicationIntent=ReadOnly'