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

[Anonymous]

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-...  

thanks