Microsoft SQL jdbc driver (sqljdbc4) for applicationIntent=ReadOnly, where to put

[lightsailpro]

We have a SQL 2012 HA group that use HA listener for routing readonly traffic  top the secondary replica. We have to use the Microsoft jdbc driver (sqljdbc4) so that we can add the applicationIntent=Readonly to the connection string. I assume we need to add the driver to both JBDS client too and teiid 8.7 server runtime. I am wondering which folder should copy the driver too. Also it seems that the wizrd always remove the "applicationIntent=Readonly" setting from the url after I clicked ok. Thanks.

[shawkins]

> I assume we need to add the driver to both JBDS client too and teiid 8.7 server runtime

No, you don't need to add it to our client.  You just need to configure the server side data source with an additional connection property.  You may need to take this over to the designer forum if you are having trouble with that.

> I am wondering which folder should copy the driver too.

You can follow: JDBC Data Sources - Teiid 8.8 (draft) - Project Documentation Editor